I have a Stored Procedure which gives the Output as set of records (20 Columns) as Table type.
I have to execute this Stored Procedure through STP Stage in DS Job.
Can I take the O/P of this Procedure through the STP Stage which is a 'Table Type' and insert the records of this table Type in to the target tabe.
Thanks for your Inputs.....Actually I am executing a Stored Procedure through DS Job .....the stored procedure is returining values in a "table type" format....just wanted to know if the STP can take this records set and proceed ahead with the transformation.....I will check in pdf and try in practically and let u all know my findings....
You can call a stored procedure that returns a record set (if, indeed, this is what you're talking about) using a connection stage, such as an ODBC stage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.