DB2 Version 9.7 for Linux, UNIX, and Windows

SYSCAT.MODULES catalog view

Each row represents a module.

Table 1. SYSCAT.MODULES Catalog View
Column Name Data Type Nullable Description
MODULESCHEMA VARCHAR (128)   Schema name of the module.
MODULENAME VARCHAR (128)   Unqualified name of the module.
MODULEID INTEGER   Identifier for the module.
DIALECT VARCHAR(10) The source dialect of the SQL module. Possible values are:
  • DB2 SQL PL
  • PL/SQL
  • Blank = Not applicable for an alias
OWNER VARCHAR (128)   Authorization ID of the owner of the module.
OWNERTYPE CHAR (1)  
  • S = The owner is the system
  • U = The owner is an individual user
MODULETYPE CHAR (1)   Type of module.
  • A = Alias
  • M = Module
  • P = PL/SQL package
BASE_MODULESCHEMA VARCHAR (128) Y If MODULETYPE is 'A', contains the schema name of the module or alias that is referenced by this alias; the null value otherwise.
BASE_MODULENAME VARCHAR (128) Y If MODULETYPE is 'A', contains the unqualified name of the module or alias that is referenced by this alias; the null value otherwise.
CREATE_TIME TIMESTAMP   Time at which the module was created.
REMARKS VARCHAR (254) Y User-provided comments, or the null value.