DB2 Version 9.7 for Linux, UNIX, and Windows

SYSCAT.INVALIDOBJECTS catalog view

Each row represents an invalid object.

Table 1. SYSCAT.INVALIDOBJECTS Catalog View
Column Name Data Type Nullable Description
OBJECTSCHEMA VARCHAR (128)   Schema name of the object being created or revalidated.
OBJECTMODULENAME VARCHAR (128) Y Unqualified name of the module to which the object being created or revalidated belongs. The null value if the object does not belong to a module.
OBJECTNAME VARCHAR (128)   Unqualified name of the object being created or revalidated. For routines (OBJECTTYPE = 'F'), this is the specific name.
ROUTINENAME VARCHAR (128) Y Unqualified name of the routine.
OBJECTTYPE CHAR (1)   Type of the object being created or revalidated. Possible values are:
  • B = Trigger
  • F = Routine
  • R = User-defined data type
  • V = View
  • v = Global variable
SQLCODE INTEGER Y SQLCODE returned in CREATE with errors or revalidation. The null value if the object has never been revalidated.
SQLSTATE CHAR (5) Y SQLSTATE returned in CREATE with errors or revalidation. The null value if the object has never been revalidated.
ERRORMESSAGE VARCHAR (4000) Y Short text for the message associated with SQLCODE. The null value if the object has never been revalidated.
LINENUMBER INTEGER Y Line number where the error occurred in compiled objects. The null value if the object is not a compiled object.
INVALIDATE_TIME TIMESTAMP   Time at which the object was last invalidated.
LAST_REGEN_TIME TIMESTAMP Y Time at which the object was last revalidated. The null value if the object has never been revalidated.