Page 1 of 1

Call DB2 SQL Stored Procedure

Posted: Tue May 26, 2009 12:57 am
by wfis
Hi,

We have a requirement to call a DB2 sql stored procedure in our datastage job. This procedure has no input of ourput stages present.

Tried searching the forum but did not receive any clear picture.

We do not have a stored procedure stage on our DS PX 7.5.2 version.
We only have DB2/UDB API, DB2/UDB Enterprise and DB2/UDB fast load stages.

Please advice

Thanks

Posted: Tue May 26, 2009 1:20 am
by ray.wurlod
Enterprise stage, Before/SQL or After/SQL (Open or Close command).

Posted: Tue May 26, 2009 1:22 am
by sendmkpk
Thank you will test this.