IBM
C2090-320 · Question #19
Why would an SQL statement receive an SQLCODE of +100? (Choose two.)
The correct answer is A. The result of a SELECT INTO statement was an empty table B. A rowset FETCH statement encountered one or more error conditions. See the full explanation below for the reasoning.
Question
Why would an SQL statement receive an SQLCODE of +100? (Choose two.)
Options
- AThe result of a SELECT INTO statement was an empty table
- BA rowset FETCH statement encountered one or more error conditions
- CThe statement references an object that is not defined in the DB2 subsystem
- DAn error occurred during the insertion of a row into an optional explanation table
- EA FETCH statement was executed when the cursor was positioned after the last row of the result
How the community answered
(21 responses)- A81% (17)
- C10% (2)
- D5% (1)
- E5% (1)
Community Discussion
No community discussion yet for this question.