SYSCAT.MODULEOBJECTS catalog view

Each row represents a function, procedure, global variable, condition, or user-defined type that belongs to a module.

Table 1. SYSCAT.MODULEOBJECTS Catalog View
Column Name	Data Type	Nullable	Description
OBJECTSCHEMA	VARCHAR (128)	N	Schema name of the module.
OBJECTMODULENAME	VARCHAR (128)	N	Unqualified name of the module to which the object belongs.
OBJECTNAME	VARCHAR (128)	N	Unqualified name of the object.
OBJECTTYPE	VARCHAR (9)	N	CONDITION = The object is a condition FUNCTION = The object is a function PROCEDURE = The object is a procedure TYPE = The object is a data type VARIABLE = The object is a variable
PUBLISHED	CHAR (1)	N	Indicates whether the object can be referenced outside its module. N = The object is not published Y = The object is published
SPECIFICNAME	VARCHAR (128)	N	Routine specific name if OBJECTTYPE is 'FUNCTION', 'METHOD' or 'PROCEDURE'; the null value otherwise.
USERDEFINED	CHAR (1)	N	Indicates whether the object is generated by the system or defined by a user. N = The object is system generated Y = The object is defined by a user