All Forums Database
akhshay 16 posts Joined 07/08
10 Oct 2008
Update command error 3706

hi i am trying to execute this query in teradata sql assistant:Update appl_student_t_04.functionalHierarchy SET hierarchy_Name='SNC', hierarchy_Desc='XXXYYYYY' ,parent_Hierarchy=null,operation_Type='U' ,operation_Reason='Test',rec_Eff_Date=1080725, last_Updated_By='Akhshay',last_Updated_Date=1081010 WHERE hierarchy_Name='snc', hierarchy_Desc='XXXyyyyy' ,parent_Hierarchy=null,operation_Reason=null;but i am getting the error 3706 syntax error: expected something between a string and ','i am not able to get anything from this error please do help.the definition of table is: CREATE SET TABLE appl_student_t_04.functionalHierarchy ,NO FALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL, CHECKSUM = DEFAULT ( hierarchy_Name VARCHAR(50) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL, hierarchy_Desc VARCHAR(100) CHARACTER SET LATIN NOT CASESPECIFIC, parent_Hierarchy VARCHAR(50) CHARACTER SET LATIN NOT CASESPECIFIC, operation_Type CHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC, operation_Reason CHAR(50) CHARACTER SET LATIN NOT CASESPECIFIC, rec_Eff_Date DATE FORMAT 'yyyy-mm-dd' NOT NULL, rec_End_Date DATE FORMAT 'yyyy-mm-dd', create_By VARCHAR(50) CHARACTER SET LATIN NOT CASESPECIFIC, create_Date DATE FORMAT 'yyyy-mm-dd', last_Updated_By VARCHAR(50) CHARACTER SET LATIN NOT CASESPECIFIC, last_Updated_Date DATE FORMAT 'yyyy-mm-dd') UNIQUE PRIMARY INDEX functionalHierarchy ( hierarchy_Name ,rec_Eff_Date );thanking youRegardsAkhshay Gandhi

Adeel Chaudhry 773 posts Joined 04/08
10 Oct 2008

Hello,Please put AND or OR in the WHERE clause expressions.E.g.SELECT * FROM TABLE1WHERE Col1 = 1 AND Col2 = 2 AND Col3 <> 4 OR Col4 <> 5;HTH!Regards,Adeel

-- If you are stuck at something .... consider it an opportunity to think anew.

akhshay 16 posts Joined 07/08
10 Oct 2008

thank you adeel..i am completely confused, sorry to worry you about such silly mistakes.RegardsAkhshay

You must sign in to leave a comment.