topic Need help in AS400 Update query using a macro in QlikView

Need help in AS400 Update query using a macro

Mon, 05 Mar 2012 05:44:25 GMT

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

Need help in AS400 Update query using a macro

Anonymous — Mon, 05 Mar 2012 08:52:03 GMT

hi,

can u post your sql code?

Re: Need help in AS400 Update query using a macro

Mon, 05 Mar 2012 09:19:22 GMT

Hi,

Thanks for your reply...

Please find the attached code.

Regards

Chriss

Need help in AS400 Update query using a macro

Anonymous — Mon, 05 Mar 2012 10:02:56 GMT

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

not problem?

Need help in AS400 Update query using a macro

Mon, 05 Mar 2012 10:11:16 GMT

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

Need help in AS400 Update query using a macro

Mon, 05 Mar 2012 11:51:25 GMT

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

Re: Need help in AS400 Update query using a macro

Mon, 05 Mar 2012 14:46:14 GMT

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?