How to select a varible (in a resultset)

iskander · #1 (**permalink**) 11-02-07, 07:02

How can I select a variable into a resultset?
Something like:

BEGIN
DECLARE myVar varchar(100);
SELECT myVar;
END;

iskander · #2 (**permalink**) 11-02-07, 07:32

I found something that seems to work, which is select varibale from sysibm.sysdummy1
Is this a good practice?

stolze · #3 (**permalink**) 11-02-07, 07:36

"SELECT var;" is not SQL - hence, DB2 does not support it. At least that is good practice.

The purpose of SYSIBM.SYSDUMMY1 is exactly to do what you have in mind. Alternatively, you can do this:

Code:

SET ... = myVar;

Or this:

Code:

VALUES ( myVar );

The latter works on DB2 LUW but not on DB2 z/OS V8 and earlier.

iskander · #4 (**permalink**) 11-02-07, 08:20

Fantastic!

Thanks