Stored Procedure Calls using DS

bensonian · Post by **bensonian** » Tue Feb 12, 2008 8:54 am

Could any body shed some light on how to call a stored procedure in DataStage Job. The database is DB2 and OS is unix. Any help in this regard would certainly be appreicated.

chulett · Post by **chulett** » Tue Feb 12, 2008 9:34 am

One would typically use the Stored Procedure stage... or is DB2 not supported there?

Teej · Post by **Teej** » Tue Feb 12, 2008 11:38 am

DB2 is supported for 8.0. Oracle support is added for 8.0.1. Other databases should be coming in future versions.

Use the Stored Procedure Stage.