declaring working storage variable in cursor
Posted: Mon Dec 13, 2010 12:52 pm
Hi,
is it possible to declare cursor using directly the Working storage Variable.
Ex.
EXEC SQL
DECLARE CR1 CURSOR WITH HOLD FOR
SELECT * FROM Table1
WHERE VAL1 = :WS-VAL1
is it possible to declare cursor using directly the Working storage Variable.
Ex.
EXEC SQL
DECLARE CR1 CURSOR WITH HOLD FOR
SELECT * FROM Table1
WHERE VAL1 = :WS-VAL1