Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good Morning All,
As I have a typical issue in update query.
As I a trying to write a macro to update in AS400 Database table, since the insert and delete query which is working fine but when try to update it showing a error of
"[IBM][iSeries Access ODBC Driver][DB2 UDB]SQL0206 - Column D not in specified tables."
Any idea about this error ....
Regards
Chriss
hi,
can u post your sql code?
Hi,
Thanks for your reply...
Please find the attached code.
Regards
Chriss
if u connecto to AS400 like user QPGMR and run sql statement works with
not problem?
Hello,
Yes, in AS400 its working fine and even I can insert and delete a record from the table and more I have tried the same in MsSQL its perfectly working fine.
I don't why its not working in AS400. ...
Regards
Chriss
Good Evening,
Can anybody help me in AS400 I need to use the update query and dateadd is not working can anybody tell me is there is any equalent function.
Regards
Chriss
Maybe you are not using a good ODBC driver? If the files are created in SQL or compiled files with DDS source this might impact the SQL statement. the field naming convention could be different? It could also be an authorisation issue. Are you sure the user that is used for the ODBC connection has enough rights on the AS400 to update this particular object?