DSXchange

Hi

I have a stored procedure which returns 2 cursors. My stored procedure has been written in MS SQL dabase. Can datastage handle this stored procedure... I mean whether datastage supports multiple cursors as output paramter of a stored procedure ?


Please reverk back.

Thanks
kamal

Don't know for certain, but I don't think it will support that. From what I recall, what the Stored Procedure stage does support is listing in the pdf documentation for it, have you checked that?

SP stage for SQL Sever has a CursorOutput parameter available for a record or a result set returned from the stored procedure, but it sure cannot handle the multiple cursors.