interview

home / developersection / interviews / what happens when you say open cursor?

Ask Question

What happens when you say OPEN CURSOR?

Varun Agrawal 2290 28-Mar-2011
db2 db2 
Updated on 18-Sep-2020
Varun Agrawal

Other

Message
Can you answer this question?
Answer

1 Answers

Varun Agrawal

Varun Agrawal

28-Mar-2011
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.
MindStick Training
MindStick Training

Liked By

We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy