just a random pick

SQL Code : +653

TABLE table-name IN PARTITIONED TABLESPACE tspace-name IS NOT AVAILABLE BECAUSE ITS PARTITIONED INDEX HAS NOT BEEN CREATED

Explanation :

An attempt has been made to insert ormanipulate data in or create a view on a partitionedtable

A table residing in a partitioned table space cannot bereferenced in any SQL manipulative statement or aCREATE VIEW statement before the partitioned indexfor that table has been created.

SQL STATE : 01551

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