Multiple choice technology mainframe

Any DB2 select query which is not part of the JOB INPUT SQL statement should be used as a cursor

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

DB2 SELECT queries return result sets that must be processed row by row. Using a cursor (DECLARE, OPEN, FETCH, CLOSE) is the standard method for handling query results. This is especially important for queries embedded in application programs where the result set needs to be processed sequentially.

Keep practicing — related questions