Update query in ODBC

[bkumar103]

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,

[betterthanever]

post the complete error

[chulett]

Are the first two columns marked as Key fields?