Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett, rschirm, roy
-
allavivek
- Premium Member
![Premium Member Premium Member](./images/ranks/premium.gif)
- Posts: 211
- Joined: Sat May 01, 2010 5:07 pm
Post
by allavivek »
Hi All,
I have a procedure which gives output , like
procedure(out).
How can i test in OE stage using open command..
For out , how should i capture the output column..
Thanks...
-
chulett
- Charter Member
![Charter Member Charter Member](./images/ranks/charter_member%s.gif)
- Posts: 43085
- Joined: Tue Nov 12, 2002 4:34 pm
- Location: Denver, CO
Post
by chulett »
You can't, at least not there. You should be using the Stored Procedure stage for that.
-craig
"You can never have too many knives" -- Logan Nine Fingers
-
allavivek
- Premium Member
![Premium Member Premium Member](./images/ranks/premium.gif)
- Posts: 211
- Joined: Sat May 01, 2010 5:07 pm
Post
by allavivek »
chulett wrote:You can't, at least not there. You should be using the Stored Procedure stage for that. ...
Hi Chulett,
So we can execute simple procedures with input args or no args in an OCE but we cannot execute procedure output arguments.
Is this valid senetece..
Thanks...
-
chulett
- Charter Member
![Charter Member Charter Member](./images/ranks/charter_member%s.gif)
- Posts: 43085
- Joined: Tue Nov 12, 2002 4:34 pm
- Location: Denver, CO
Post
by chulett »
That would be correct. It may work (never tried) but you'd have no mechanism to capture the output.
-craig
"You can never have too many knives" -- Logan Nine Fingers
-
allavivek
- Premium Member
![Premium Member Premium Member](./images/ranks/premium.gif)
- Posts: 211
- Joined: Sat May 01, 2010 5:07 pm
Post
by allavivek »
chulett wrote:That would be correct. It may work (never tried) but you'd have no mechanism to capture the output. ...
Thanks chulett..