DB2 Version 9.7 for Linux, UNIX, and Windows

SYSCAT.CONDITIONS catalog view

Each row represents a condition defined in a module.

Table 1. SYSCAT.CONDITIONS Catalog View
Column Name Data Type Nullable Description
CONDSCHEMA VARCHAR (128)   Schema name of the condition.
CONDMODULENAME VARCHAR (128) Y Unqualified name of the module to which the condition belongs.
CONDNAME VARCHAR (128)   Unqualified name of the condition.
CONDID INTEGER   Identifier for the condition.
CONDMODULEID INTEGER Y Identifier of the module to which the condition belongs.
SQLSTATE CHAR(5) Y SQLSTATE value associated with the condition.
OWNER VARCHAR (128)   Authorization ID of the owner of the condition.
OWNERTYPE CHAR (1)  
  • S = The owner is the system
  • U = The owner is an individual user
CREATE_TIME TIMESTAMP   Time at which the condition was created.
REMARKS VARCHAR (254)   User-provided comments, or the null value.