Archives of the TeradataForum

Message Posted: Mon, 28 Jan 2013 @ 10:26:19 GMT

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

Hi,

I am getting 5977 error during merge. Please suggest how to resolve.

     MERGE INTO   C1
     USING
     (
            SELECT
                  COL1
                 ,COL2
                 ,COL3
                 ,COL4
                 ,COL5
                 ,COL6
                 ,COL7

            FROM 
     ) C2

     ON  C1.COL1 = C2.COL1
     AND C1.COL2 = C2.COL2
     AND C1.COL3 = C2.COL3
     AND C1.COL4 = C2.COL4

     WHEN MATCHED THEN UPDATE
        SET
                  COL5 = C2.COL5
                 ,COL6 = C2.COL6
                 ,COL7 = C2.COL7

Now Table1 structure is something like below :

     CREATE MULTISET TABLE TABLE ,NO FALLBACK ,
          NO BEFORE JOURNAL,
          NO AFTER JOURNAL,
          CHECKSUM = DEFAULT,
          DEFAULT MERGEBLOCKRATIO
          (
           COL1 CHAR(32) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
           COL3 CHAR(6) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
           COL4 CHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
           COL5 DECIMAL(2,0) NOT NULL,
           COL6 CHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
           COL2 CHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
           COL7 BIGINT NOT NULL)
     PRIMARY INDEX ( COL1 )
     PARTITION BY RANGE_N(CAST((COL5) AS SMALLINT) BETWEEN 1  AND 10  EACH 1 ,
     NO RANGE)
     INDEX ( COL3 );

Regards,

Koushik Chandra

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