DB2 for z/OS: Ability to Retrieve Output SP Parameters Into Global Variables in Dynamic CALL

You are correct, and the status is back to Under Review. I have asked the SME to continue their review.

Please change the status of this RFE. The current status does not reflect your intentions and is misleading.

I see, ok. I've notified the SME for this idea and asked for continued review.

The "calling application" in this case is just a (JDBC based) tool that can run SQL scripts.

It works but it is unrelated to the submitted idea.

The idea is to be able to use the similar functionality WITHOUT creating additional DB2 objects (such as a wrapper stored procedure).

Hello Michael, Here is the update from our Db2 for z/OS team, they confirmed the following works:

- Create a Global Var CREATE VARIABLE GRC INTEGER DEFAULT 100;

- Create a stored procedure with an INOUT parameter CREATE PROCEDURE WLMSP1 (INTEGER INOUT)

- In the calling application, call the stored procedure hvsp = 'WLMSP1'; EXEC SQL call :hvsp (GRC);

- In the stored procedure, check the Global Var and then set it to a different value EXEC SQL SELECT GRC INTO :IN_PARM FROM SYSIBM.SYSDUMMY1; --> shows 100 EXEC SQL SET GRC = 9999;

- In the calling application, check the Global Var after the stored procedure call EXEC SQL SELECT GRC INTO :parm1 FROM SYSIBM.SYSDUMMY1; --> shows 9999 (the new value set in the SP)

Having said this, is there anything further you need for this idea?

Sincerely,

Db2 for z/OS team

Hello Michael, Thank you for submitting this enhancement request. The idea is under review now with the Db2 for z/OS team, so more time is needed for their assessment. We will update you as soon as their assessment has completed.

Sincerely,

The Db2 for z/OS team

Expectedly, it would work like following:

CREATE VARIABLE RC INTEGER DEFAULT 13;

CREATE VARIABLE MSG VARCHAR(120) DEFAULT 'DEFAULT';

CALL SYSPROC.WLM_REFRESH('DB2XWLM', 'DX11', MSG, RC);

SELECT MSG, RC FROM SYSIBM.SYSDUMMY1;