Running Stored Procedure SQL 2005 in DataStage

ylai20 · Post by **ylai20** » Mon Jan 31, 2011 1:08 am

Hi all, i have create a simple stored procedure and want to run from DataStage. Can i just use one Stored Procedure stage to do it?

I have try to use this method but it required input and output which i think is not necessary.

Is there any better way i just have something like a StoredProcedure that just link to the SP in SQL server 2005?

Sreenivasulu · Post by **Sreenivasulu** » Mon Jan 31, 2011 3:35 am

You can use a 'dummy input' using rowgenerator and a 'dummy ouput' (dummy output if you do not need error handling)

Regards
Sreeni

chulett · Post by **chulett** » Mon Jan 31, 2011 8:17 am

ylai20 wrote:I have try to use this method but it required input and output which i think is not necessary.

It's necessary. And since we're talking Server job, that dummy input would need to come from a Transformer. Make sure you define a stage variable in it and use a constraint of @OUTROWNUM=1.

ray.wurlod · Post by **ray.wurlod** » Mon Jan 31, 2011 3:50 pm

Doesn't have to come from a Transformer at all. You can select one row from any reliable source (for example the "VOC" entry from "VOC").

chulett · Post by **chulett** » Mon Jan 31, 2011 6:46 pm

... or you can use a Transformer. 100% reliable.

Change "would need to" to "could" in my previous post.

DSXchange

Running Stored Procedure SQL 2005 in DataStage

Running Stored Procedure SQL 2005 in DataStage

Re: Running Stored Procedure SQL 2005 in DataStage