-736 INVALID OBID obid SPECIFIED

Explanation

Start of changeAn invalid OBID value was given or encountered. The OBID is invalid for one of the following reasons:
  • The specified OBID for the CREATE TABLE statement does not fall within the acceptable range for OBIDs, which is 2 to 32767.
  • The specified OBID for the CREATE TABLE statement is already in use for the given database.
  • The ALTER statement encountered an existing object with an OBID that does not fall within the acceptable range for OBIDs, which is 2 to 32767.
End of change

System action

The statement cannot be processed.

Programmer response

For the CREATE TABLE statement, verify that the given OBID is a valid value for an OBID. If so, ensure that the OBID is correct for the object to be created, then query the catalog to find the object that is already defined as having the same OBID in the database. If an invalid OBID was given for the object to be created, correct the statement and execute it again. If the existing object is in error, then DROP and CREATE that object using the correct OBID value.

Start of changeFor the ALTER statement, query the catalog to find the object that is already defined as having the same OBID in the database. DROP and CREATE that object using a valid OBID value.End of change

It is possible that the OBID “in use” is the OBID for an object that had been previously dropped. If that is the case, and the CREATE was issued for a table in a non-ROSHARE READ database, then select a different OBID for use in the OBID clause. If the object had been previously dropped and the CREATE was issued for a table in a ROSHARE READ database, COMMIT and re-submit the CREATE TABLE request.

SQLSTATE

53014