How to delete & update records from DB2 API Stage?

[iamnagus]

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

[Kirtikumar]

What is the job type?

The one mentioned in your post is server.

[vicmania]

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

[iamnagus]

Hi,

The same query is able execute in the DB2 Client database. I am getting this issue from datastage.

Regards,
iamnagus