Need help in AS400 Update query using a macro

[#1]

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

[Anonymous]

hi,

can u post your sql code?

[#3]

Hi,

Thanks for your reply...

Please find the attached code.

Regards

Chriss

[Anonymous]

if u connecto to AS400 like user QPGMR and run sql statement works with

not problem?

[#5]

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

[#6]

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

[#7]

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?