Sql Codes

 

 

 

 

 

SQL CODES

CODE          CAUSE

 

  • +100            No rows fetched.
     
  • -102             String constant is too long
     
  • -117             The number of values you are trying to INSERT does not match the number of columns.
     
  • -180/-181     Bad data in Date/Time/Timestamp
     
  • -199              Illegal use of specified keyword
     
  • -204              Object not defined in DB2
     
  • -205/-206     Column Specified does not exist
     
  • +304             Value can not be assigned to the host variable because it is out of range.
     
  • -305              Null indicator missing
     
  • -311              VARCHAR Insert or update failed (-LEN field was not set right with the data length.
     
  • -501              Cursor not opened for FETCH
     
  • -502              Trying to open an already opened cursor
     
  • -503              Updating column which needs to be specified in FOR UPDATE OF
     
  • -530              Referential integrity prevents the INSERT/UPDATE
     
  • -532/-536     Referential integrity (DELETE RESTRICT rule) prevents the DELETE
     
  • -545              Check constraint prevents the INSERT/UPDATE
     
  • +802             null indicator was set to -2 because an arithmetic statement didn't work
     
  • -803              Duplicate key on insert or update
     
  • -805              DBRM or package not found in plan
     
  • -811              More than one row retrieved in Select statement
     
  • -904              Resource is Unavailable.
     
  • -911              Deadlock occurred. Rollback has been done
     
  • -913              Deadlock. No Rollback
     
  • -922              Authorization Failure