![](//teradataforum.com/imgs/ptdfw1.gif) |
![](//teradataforum.com/imgs/ptdfw2.gif) |
Archives of the TeradataForum
Message Posted: Mon, 28 Jan 2013 @ 10:26:19 GMT
Subj: | | MERGE Failed 5977: Invalid MERGE-INTO statement |
|
From: | | Koushik Chandra |
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
| |