How to delete & update records from DB2 API Stage?
Posted: Wed Sep 13, 2006 9:41 am
Hi,
I need to delete or update a record from DB2 table.
My job design is like this.
DB2 API stage--------->Transformer-------->DB2 API Stage
(To read the table) (To assign a value (To update or Delete)
Into stage variable)
Qurey(in Second API Stage):
'DELETE FROM raoridbf.model WHERE (raoridbf.model.CODE=ORCHESTRATE.CODE)
Here is issue with this code:
"CopyOfModel1_job..DB2_UDB_API_6: [IBM][CLI Driver][AS] SQL5001N "CODE" does not have the authority to change the database manager configuration file. SQLSTATE=42703
SQLExecDirect: Error executing statement 'DELETE FROM raoridbf.model WHERE (raoridbf.model.CODE=ORCHESTRATE.CODE)'. See following DB2 message for details."
Please suggest me to where i am doing wrong. Please explain in what stage whats need to be done.
Even my design is wrong, please advice me for correct design.
Thanks & Regards,
iamnagus
I need to delete or update a record from DB2 table.
My job design is like this.
DB2 API stage--------->Transformer-------->DB2 API Stage
(To read the table) (To assign a value (To update or Delete)
Into stage variable)
Qurey(in Second API Stage):
'DELETE FROM raoridbf.model WHERE (raoridbf.model.CODE=ORCHESTRATE.CODE)
Here is issue with this code:
"CopyOfModel1_job..DB2_UDB_API_6: [IBM][CLI Driver][AS] SQL5001N "CODE" does not have the authority to change the database manager configuration file. SQLSTATE=42703
SQLExecDirect: Error executing statement 'DELETE FROM raoridbf.model WHERE (raoridbf.model.CODE=ORCHESTRATE.CODE)'. See following DB2 message for details."
Please suggest me to where i am doing wrong. Please explain in what stage whats need to be done.
Even my design is wrong, please advice me for correct design.
Thanks & Regards,
iamnagus