need help in using the stored procedure stage

velagapudi_k · Post by **velagapudi_k** » Wed Mar 10, 2010 9:45 am

How to use a STP Stage in DataStage Parallel Extender.

chulett · Post by **chulett** » Wed Mar 10, 2010 11:19 am

Your question is a wee bit too broad... what kind of help do you need? Have you read the docs? Pressed the Help button in the stage? Tried to actually use it?

Do you have any specific questions?

ray.wurlod · Post by **ray.wurlod** » Wed Mar 10, 2010 3:53 pm

The same as any other stage. You connect links to it and edit its properties.

John Smith · Post by **John Smith** » Thu Mar 11, 2010 6:24 pm

Hi,
If your stored procedures expects parameters then you need to pass these onto the stage. Typically you will need to have input parameters and output parameters. The data type for the parameters must match up to what the stored procedure is expecting.
Other than that it's the same as any other stage.
JS

kamalshil · Post by **kamalshil** » Fri Mar 12, 2010 12:09 am

John Smith wrote:Hi,
If your stored procedures expects parameters then you need to pass these onto the stage. Typically you will need to have input parameters and output parameters. The data type for the parameters must match up to what the stored procedure is expecting.
Other than that it's the same as any other stage.
JS

Yes you can do the parameter mapping in Stage -> Parameter Tab.
you can set parameter type is in or out there or can import the metadata of SP and use it.

out parameter values would be available in output link.