Open command in OE stage

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

Post Reply
allavivek
Premium Member
Premium Member
Posts: 211
Joined: Sat May 01, 2010 5:07 pm

Open command in OE stage

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
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
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
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
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..
Post Reply