Call DB2 SQL Stored Procedure

wfis · Post by **wfis** » Tue May 26, 2009 12:57 am

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

ray.wurlod · Post by **ray.wurlod** » Tue May 26, 2009 1:20 am

Enterprise stage, Before/SQL or After/SQL (Open or Close command).

sendmkpk · Post by **sendmkpk** » Tue May 26, 2009 1:22 am

Thank you will test this.