Re: Regarding CURSOR

[Buck Calabro/commsoft<mcalabro@xxxxxxxxxxxx>]

On 02/24/99 08:00:31 PM Vikas Taskar  wrote:

>I would like to know what is the exact significance of declaring a cursor,
>in an RPG-SQL Program(RPG Program with embedded SQL).
>Is it for fetching multiple records/multiple field values of the same
>table?
>And why do we need to open and close the cursor?

Here's the analogy I use... but then I'm sort of green in this area too:
Declare cursor = F spec
Open Cursor = Open file. 
Fetch Next = READ
Close cursor = Close file

The open/close files happen implicitly for many RPG programmers, but the 
basic reason to go through an open is to apply overrides, set up I/O 
buffers, initialise internal pointers, lock the file member and the like. 
Close releases that memory back to the "free" pool and releases the locks.

Buck Calabro
CommSoft, Albany, NY
mailto:mcalabro@commsoft.net
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---