FYI. SQL question on LaunchPad Q&A board. -Steve
-----Original Message----- From: [email protected] [mailto:[email protected]] 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. -- Mailing list: https://launchpad.net/~trafodion-firefighters Post to : [email protected] Unsubscribe : https://launchpad.net/~trafodion-firefighters More help : https://help.launchpad.net/ListHelp
