Multiple choice technology mainframe

SQL Return Code -502

  1. Cursor not closed

  2. Cursor not opened

  3. Cursor already open

  4. ALL the ABOVE

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

SQL return code -502 indicates that the application attempted to open a cursor that is already open. A cursor must be closed before it can be opened again - each cursor declaration requires a corresponding CLOSE before reopening.