Hi All,
I am running sql server stored Prcoedure using ODBC stage, with input parameters which returns output 'sequence key, return code.
i am storing its output in a sequential file.
this 'sequnce key' should go as input parameter value to second stored procedure.
how can i pass 'sequence key' value from sequential file to second stored procedure (which i am going call with ODBC).
How to pass output of one sp as input to other sp
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Thanks Ray.
yes, i did that.
ODBC(SP1)----TRANSOFORMER---seq (first job)
seq--- transofrmer---ODBC(SP2). (second job)
After executing second SP, i need to pass its out put parameter value to third job.
after finsihing second job, i am able to load table in database. but i need to one output column to third job.
i want get resultset (return value) from SP2
How can i do that.
Thanks
.ray.wurlod wrote:Can't you just pass the value along a link to the ODBC stage that invokes the second Stored Procedure?
yes, i did that.
ODBC(SP1)----TRANSOFORMER---seq (first job)
seq--- transofrmer---ODBC(SP2). (second job)
After executing second SP, i need to pass its out put parameter value to third job.
after finsihing second job, i am able to load table in database. but i need to one output column to third job.
i want get resultset (return value) from SP2
How can i do that.
Thanks