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
How to delete & update records from DB2 API Stage?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 437
- Joined: Fri Oct 15, 2004 6:13 am
- Location: Pune, India
Re: How to delete & update records from DB2 API Stage?
Hello,
try to execute the same sql with the same user from a DB2 client directly. I assume you have a problem with the user - not the correct rights on the database ...
Rgds Vicmania
try to execute the same sql with the same user from a DB2 client directly. I assume you have a problem with the user - not the correct rights on the database ...
Rgds Vicmania