trafodion-firefighters team mailing list archive

Thread
Date

FW: [Question #253604]: Merge SQL fails

To: "trafodion-firefighters@xxxxxxxxxxxxxxxxxxx" <trafodion-firefighters@xxxxxxxxxxxxxxxxxxx>
From: "Varnau, Steve (Trafodion)" <steve.varnau@xxxxxx>
Date: Tue, 26 Aug 2014 16:55:32 +0000
Accept-language: en-US
In-reply-to: <20140826030759.17414.91750.launchpad@loganberry.canonical.com>
Thread-index: AQHPwNrx4RDrMeppF0mIgAaPdjpRW5vjGtbQ
Thread-topic: [Question #253604]: Merge SQL fails

FYI.  SQL question on LaunchPad Q&A board.  

-Steve

-----Original Message-----
From: bounces@xxxxxxxxxxxxx [mailto:bounces@xxxxxxxxxxxxx] On Behalf Of Amol
Sent: Monday, August 25, 2014 20:08
To: Varnau, Steve (Trafodion)
Subject: [Question #253604]: Merge SQL fails

New question #253604 on Trafodion:
https://answers.launchpad.net/trafodion/+question/253604

I am executing the merge statement and get below error. Please let me know whats the problem and the correction required.

CREATE TABLE Test_1 (Col1 integer,Col2 Varchar (100)); CREATE TABLE Test_2 (Col1 integer,Col2 Varchar (100));


MERGE INTO Test_2 USING
(SELECT * FROM Test_1) z(Col1,col2) on Col1 =Z.Col1 WHEN MATCHED THEN UPDATE SET Col2 = z.Col2 WHEN NOT MATCHED THEN INSERT VALUES (z.Col1, z.Col2);

*** ERROR[3241] This MERGE statement is not supported. Reason:  SYSKEY not allowed.

*** ERROR[8822] The statement was not prepared.


Thanks,
Amol


--
You received this question notification because you are an answer contact for Trafodion.