Multiple choice technology mainframe

SQL STATE 2000 is the same as

  1. SQL CODE 100

  2. SQL CODE -911

  3. SCLCODE -811

  4. SQLCODE -305
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

SQLSTATE 20000-29999 range indicates execution warnings. SQLSTATE 02000 specifically means 'No data found' which corresponds to SQLCODE 100 in DB2 and other databases - this is returned when a SELECT retrieves no rows or cursor reaches end of data.

Keep practicing — related questions