Bind Variables not returning Output Parameters Data:

When I run a series of Stored Procs in DB2 such as:

CALL WO01DV.OCP079(‘XXX’, @SPNAME, @SQLSTATE_OUT, @SQLCODE_OUT);

I receive the Output Parameters Data as expected. (after answering/setting the values of the variables).

Executed Successfully. Output parameters data:
@SPNAME = “OCP079_050”,
@SQLSTATE = “00000”,
@SQLCODE = 0

When I add the above variables to the GlobalVariables dialog, the Output Parameters Data is missing.

Executed Successfully

It would be very helpful if this worked because it saves me from clicking on the OK button to approve the values of the variables. I would appreciate your analysis/solution.

I’m not sure what you’re asking for. Can you be more specific?

Also, what version of Toad for DB2 are you using?

The global variables are just that. Global and set for every call without prompting.

The variables above are session specific so you would not want to use global variables for that.

Understood. Being prompted for variables is the only way to see the return values from the called procedure?

The global variables work just fine. They send a set value for all occurrences of calls to procedures.

However, the "messages" tab won't show the return values.

Thank You,


Steve Nussbaum

4200 E. 5th Ave., Q2-01

Columbus, OH 43219

(614) 387-8696


On 3/19/2014 at 2:01 PM, bounce-Henrik_Johnson@toadworld.com wrote:

RE: Bind Variables not returning Output Parameters Data:

Reply by Henrik Johnson
The global variables are just that. Global and set for every call without prompting.

The variables above are session specific so you would not want to use global variables for that.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for IBM DB2 - General
notifications altogether.

Toad for IBM DB2 - Discussion Forum

Flag
this post as spam/abuse.


This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain private, confidential, and/or privileged information. Any unauthorized review, use, disclosure, or distribution
is prohibited. If you are not the intended recipient, employee, or agent responsible for delivering this message, please contact the sender by reply e-mail and destroy all copies of the original e-mail message.