just a random pick

SQL Code : +162

TABLESPACE database-name.tablespace-name HAS BEEN PLACED IN CHECK PENDING

Explanation :

The indicated table space is in checkpending status because the ALTER TABLE statementwas used to specify either of the following:

  • A referential constraint
  • A check constraint, when the CURRENT RULESspecial register is set to 'DB2'

SQL STATE : 01514

When DB2 executes an SQL statement, it returns information about the statement execution which includes the SQL return code (SQLCODE) and the SQLSTATE, which indicate whether statement execution was successful.

Regardless of whether the application program provides an SQLCA or a stand-alone variable, SQLCODE is set by DB2 after each SQL statement is executed. DB2 conforms to the ISO/ANSI SQL standard as follows:

  • If SQLCODE = 0, execution was successful.
  • If SQLCODE > 0, execution was successful with a warning.
  • If SQLCODE < execution was not successful.

Suggestion / Complaint / Feedback