Update Query Failing

Database
Enthusiast

Update Query Failing

I have the following simple update query which fails

UPDATE TARGET_TABLE SET TARGET_TABLE.COL_VARCHAR = 'a';

*** Failure 3706 Syntax error: expected something between the word 'TARGET_TABLE' and '.'

This query is generated by an application and works on all databases (ora, db2, sybase) but fails on Teradata.

Any suggestions ?
1 REPLY
Enthusiast

Re: Update Query Failing

UPDATE TARGET_TABLE SET COL_VARCHAR = 'a';