DSXchange

Hi,
I have a pipe delimited file with follwoing column:

Countryname
oldid
newid
newname

I have the table with following column
country
id
name
datetimestamp

I have to replace the old id with new id in the table.
I am using following query in odbc

update <table> set id=?, name=? where country=? and id = ?

after running the job i am getting following error

[DataStage][SQL Client][ODBC][DataDirect][ODBC Oracle Wire Protocol driver]Error in SQL Parser.|

Could you please help in resolving this

Thanks,

post the complete error

Are the first two columns marked as Key fields?