Multiple choice technology mainframe

Sql Return Code 100

  1. Colum not found

  2. Rows found

  3. No Row found

  4. Both A and B
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

SQL return code +100 means no row was found or the cursor is positioned after the last row of the result set. This is the expected outcome when a SELECT INTO or FETCH finds no matching data. Option A describes a different error (column not found would be -206), and option B is incorrect because +100 specifically indicates the absence of rows.

Keep practicing — related questions