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?
Running Stored Procedure SQL 2005 in DataStage
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am
Re: Running Stored Procedure SQL 2005 in DataStage
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.ylai20 wrote:I have try to use this method but it required input and output which i think is not necessary.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: