Joined: 10 Feb 2003 Posts: 6076 Location: Somewhere over the Rainbow this side of Never-never land.
If I understand it correctly,
1) you have a Stored Pro doing something
2) you want to control what 'terminal' is used for the output based upon a value returned from the SP
You will really have to explain what you want a bit clearer.
Then go look up
IF
do something
ELSE
do alternative something
END IF
or something similar.
I really do have to ask what software development experience you have. These questions are very very basic. _________________ WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum