Joined: 23 Nov 2006 Posts: 19270 Location: Inside the Matrix
Please post this in the DB2 forum. Your code may be COBOL, but this is a DB2 questions.
When you open the cursor, the set of matching rows will be retrieved/ordered. When you issue the fetch, one row at a time will be returned to your program.
If your program is only going to read rows, do NOT specify update. Systems that read rows for update when it is not needed often have performance problems. Tasks have to wait for locked rows that would have been available.