Home > DeveloperSection > Interviews > What happens when you say OPEN CURSOR?

Posted on    March-28-2011 5:51 AM

 DB2 DB2 
 1 Answer(s)
  1104  View(s)
Rate this:

Varun Agrawal
Varun Agrawal

Total Post:159

Posted on    March-28-2011 12:00 AM

If there is an ORDER BY clause, rows are fetched, sorted and made available for the FETCH statement. Other wise simply the cursor is placed on the first row.

Don't want to miss updates? Please click the below button!

Follow MindStick