Page 1 of 1

Stored Procedure Calls using DS

Posted: Tue Feb 12, 2008 8:54 am
by bensonian
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.

Posted: Tue Feb 12, 2008 9:34 am
by chulett
One would typically use the Stored Procedure stage... or is DB2 not supported there?

Posted: Tue Feb 12, 2008 11:38 am
by Teej
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.