When you open a cursor, DB2 will always get all rows that meet the selection criteria and create a result set?
Reveal answer
Fill a bubble to check yourself
Keep practicing — related questions
- "Even for a single fetch from DB2 table, cursor is required in an easytrieve program.". Is the statement true?
- Any DB2 select query which is not part of the JOB INPUT SQL statement should be used as a cursor
- When do you open cursor before Fetching i) Cursor should always be Opened before Fetching ii) Fetch Operati...
- Oracle engine creates Cursors for every SELECT statements.
- ___________ provide a way for your program to select multiple rows of data from the database and then proce...
- Which of the following operations in SQL retrieves the rows from the active set, one row at a time?
- Explicit cursors are used to process multiple row SELECT statements
- DB2 Cursor Stablity i) Cursor Stablity Leads to Higher concurency ii) Repeatable Read Leads to Higher consi...