Multiple choice technology mainframe

SQL Return code -501

  1. With Hold option missing

  2. Cursor not open

  3. Cursor not close

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

SQL code -501 in DB2 indicates that an attempt was made to FETCH or CLOSE a cursor that is not currently open in the application process. Distractors like having a missing WITH HOLD option or attempting to close an already closed cursor do not generate this specific SQL error code.

Keep practicing — related questions