Archives of the TeradataForum

Message Posted: Wed, 14 Dec 2011 @ 20:44:47 GMT


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

Subj:		Re: Insert load half of my data

From:		Issah, Gabriel

No both tables were created with the same syntax

Source table

     CREATE SET TABLE ETL_Test.AcIn ,NO FALLBACK ,
          NO BEFORE JOURNAL,
          NO AFTER JOURNAL,
          CHECKSUM = DEFAULT,
          DEFAULT MERGEBLOCKRATIO
          (
           Segmt_Id INTEGER TITLE 'Coverage Segment Identifier' NOT NULL,
           Unit_Id INTEGER TITLE 'COVERAGE UNIT Id' NOT NULL,
           Acct_Id INTEGER TITLE 'Product Id' NOT NULL,

           Lmt_Acum_Cd VARCHAR(50) CHARACTER SET LATIN NOT CASESPECIFIC TITLE 'Limit Accumulator Cd',
           Lmt_Acum_Desc VARCHAR(250) CHARACTER SET LATIN NOT CASESPECIFIC TITLE 'Limit Accumulator Desc')
     PRIMARY INDEX ( Acct_Id );

Target table

     CREATE SET TABLE T_Test.Ac_In ,NO FALLBACK ,
          NO BEFORE JOURNAL,
          NO AFTER JOURNAL,
          CHECKSUM = DEFAULT,
          DEFAULT MERGEBLOCKRATIO
          (
           Segmt_Id INTEGER TITLE 'Coverage Segment Identifier' NOT NULL,
           Unit_Id INTEGER TITLE 'COVERAGE UNIT Id' NOT NULL,
           Acct_Id INTEGER TITLE 'Product Id' NOT NULL,

           Lmt_Acum_Cd VARCHAR(50) CHARACTER SET LATIN NOT CASESPECIFIC TITLE 'Limit Accumulator Cd',
           Lmt_Acum_Desc VARCHAR(250) CHARACTER SET LATIN NOT CASESPECIFIC TITLE 'Limit Accumulator Desc')
     PRIMARY INDEX ( Acct_Id );

Thanks

Gabriel Issah


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

Attachments

Library

Quick Reference