Archives of the TeradataForum

Message Posted: Thu, 05 Jun 2014 @ 10:16:29 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi All,

I need some help. We are encountering this error when the ODBC connection was configured to use Teradata Session Mode? The records are successfully being inserted when using ANSI Session Mode. Please see below the sample target table definition. Any help will be greatly appreciated. Thank you.

     CREATE SET TABLE SampleTable ,NO FALLBACK ,
          NO BEFORE JOURNAL,
          NO AFTER JOURNAL,
          CHECKSUM = DEFAULT
          (
           Col1 VARCHAR(8) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
           Col2 SMALLINT NOT NULL,
           Col3 TIMESTAMP(6) NOT NULL,
           Col4 CHAR(5) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
           Col5 DECIMAL(18,0) NOT NULL,
           Col6 DATE FORMAT 'yyyy-mm-dd',
           Col7 BYTEINT,
           Col8 VARCHAR(255) CHARACTER SET UNICODE NOT CASESPECIFIC,
           Workflow_Run_Id INTEGER NOT NULL)
     UNIQUE PRIMARY INDEX (Col1, Col2, Col3, Col4, Col5);

Please note that the values in all the columns included in the UPI are unique in all records.

Best regards,

Win

	<Prev	Next>		<<First	<Prev	Next>	Last>>