Update command error 3706

Database
Enthusiast

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 you

Regards
Akhshay Gandhi
2 REPLIES
Teradata Employee

Re: Update command error 3706

Hello,

Please put AND or OR in the WHERE clause expressions.

E.g.

SELECT * FROM TABLE1
WHERE Col1 = 1 AND Col2 = 2 AND Col3 <> 4 OR Col4 <> 5;

HTH!

Regards,

Adeel
Enthusiast

Re: Update command error 3706

thank you adeel..

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

Regards
Akhshay