IBM Mainframe Forum

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

yes

Suggest you read DECLARE CURSOR in the SQL Reference manual where it sepcifically answers your question in plain English.