Stored Procedure

[ray.wurlod]

It depends on the database in which the stored procedure exists but, in general, you can use job parameters to provide input values to stored procedures, but there is no mechanism for supplying arrays or recordsets; DataStage is a tool that operates one row at a time.
You can not upload the returned values (which must be scalar) from a stored procedure into a job parameter, because job parameters are evaluated when a job starts and do not change subsequently.
Possible solutions include:
create a stored procedure that only uses scalar arguments
create a plug-in stage type (definitely a non-trivial exercise)