To use the Cursor in Sub Program, Declaration needed or not

shammiullah · New User Joined: 13 Jun 2005 Posts: 24

hi,
i've declared a cursor c1 in main pgm without WITH HOLD option.so, to do certain operations in sub pgm do i have to declare c1 cursor again or else i have to declare it with new name.
warm regards,
shammi.

khamarutheen · Active Member Joined: 23 Aug 2005 Posts: 677 Location: NJ

Hi frnd,
use WITH HOLD option it is usefull in ur case. but if u don't want that. then u need to declar again in the sub program only.

Suryanarayana.tadala · New User Joined: 03 Nov 2005 Posts: 43 Location: St.Louis

Frend's i feel that u need to declare the cursor once again in the subprog as u will be accessing the data in the subprog too... the with hold option helps you to retain the cursor state in the trxn flow.

correct me if i am wrong..