To use a FETCH staement with a cursor you always have to supply an explicit direction such next or prior.

Keep practicing — related questions

• When do you open cursor before Fetching i) Cursor should always be Opened before Fetching ii) Fetch Operati...
• Which one of the below is not related to Cursor
• If all the values from a cursor have been fetched and another fetch is issued,what the output will be?
• If all the values from a cursor have been fetched and another fetch is issued, the output will be :
• "Even for a single fetch from DB2 table, cursor is required in an easytrieve program.". Is the statement true?
• ___________ is used to move the cursor at the beginning of a line.
• The life cycle of the explicit cursor goes through __________stages:
• List the correct sequence of commands to process a set of records when using explicit cursors