declaring working storage variable in cursor



Support for OS/VS COBOL, VS COBOL II, COBOL for OS/390 & VM and Enterprise COBOL for z/OS

declaring working storage variable in cursor

Postby daniel1234 » 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
daniel1234
 
Posts: 1
Joined: Mon Dec 13, 2010 12:41 pm
Has thanked: 0 time
Been thanked: 0 time

Re: declaring working storage variable in cursor

Postby GuyC » Mon Dec 13, 2010 2:11 pm

yes
GuyC
 
Posts: 315
Joined: Tue Aug 11, 2009 3:23 pm
Has thanked: 1 time
Been thanked: 4 times

Re: declaring working storage variable in cursor

Postby NicC » Mon Dec 13, 2010 2:15 pm

Suggest you read DECLARE CURSOR in the SQL Reference manual where it sepcifically answers your question in plain English.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times


Return to IBM Cobol

 


  • Related topics
    Replies
    Views
    Last post