SYSFIELDS catalog table

The SYSFIELDS table contains one row for every column that has a field procedure. The schema is SYSIBM.

Table 1. SYSIBM.SYSFIELDS table column descriptions
Column name Data type Description Use
TBCREATOR
VARCHAR(128)
NOT NULL
 Schema or qualifier of the table that contains the column. G
TBNAME
VARCHAR(128)
NOT NULL
 Name of the table that contains the column. G
COLNO
SMALLINT
NOT NULL
 Numeric place of this column in the table. G
NAME
VARCHAR(128)
NOT NULL
 Name of the column. G
FLDTYPE
VARCHAR(24)
NOT NULL
 Data type of the encoded values in the field (This column might contain statistical values from a prior release.):
INTEGER
Large integer
SMALLINT
Small integer
FLOAT
Floating-point
CHAR
Fixed-length character string
VARCHAR
Varying-length character string
DECIMAL
Decimal
GRAPHIC
Fixed-length graphic string
VARG
Varying-length graphic string
 G
LENGTH
SMALLINT
NOT NULL
 The length attribute of the field; or, for a decimal field, its precision.(This column might contain statistical values from a prior release.) The number does not include the internal prefixes that can be used to record actual length and null state.
INTEGER
4
SMALLINT
2
FLOAT
8
CHAR
Length of string
VARCHAR
Maximum length of string
DECIMAL
Precision of number
GRAPHIC
Number of DBCS characters
VARG
Maximum number of DBCS characters
 G
SCALE
SMALLINT
NOT NULL
 Scale if FLDTYPE is DECIMAL; otherwise, the value is 0. G
FLDPROC
VARCHAR(24)
NOT NULL
 For a row describing a field procedure, the name of the procedure. (This column might contain statistical values from a prior release.) G
WORKAREA
SMALLINT
NOT NULL
 For a row describing a field procedure, the size, in bytes, of the work area required for the encoding and decoding of the procedure. (This column might contain statistical values from a prior release.) G
IBMREQD
CHAR(1)
NOT NULL
 A value of Y indicates that the row was provided with the Db2 product code. For all other values, see Release dependency indicators.

The value in this field is not a reliable indicator of release dependencies.

 G
EXITPARML
SMALLINT
NOT NULL
For a row describing a field procedure, the length of the field procedure parameter value block. (This column might contain statistical values from a prior release.) G
PARMLIST
VARCHAR(735)
NOT NULL
 For a row describing a field procedure, the parameter list following FIELDPROC in the statement that created the column, with insignificant blanks removed. (This column might contain statistical values from a prior release.) G
EXITPARM
VARCHAR(1530)
NOT NULL
FOR BIT DATA
 For a row describing a field procedure, the parameter value block of the field procedure (the control block passed to the field procedure when it is invoked). (This column might contain statistical values from a prior release.) G