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,
Update query in ODBC
Moderators: chulett, rschirm, roy
Update query in ODBC
Birendra
-
- Participant
- Posts: 152
- Joined: Tue Jan 13, 2009 8:59 am
Re: Update query in ODBC
post the complete error