Stored procedure stage and the use of cursors

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
acavarra
Premium Member
Premium Member
Posts: 10
Joined: Wed Sep 16, 2009 10:12 am

Stored procedure stage and the use of cursors

Post by acavarra »

Is it possible to receive a cursor variable as the result set from one stored procedure and use it as input into another stored procedure to actually break it down into the appropriate columns?

Also, does DS understand row types as a result set back from a stored procedure.

If anyone has any info regarding this, it would be greatly appreciated.
Post Reply