SYSIBM.SYSFIELDS table

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

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 columns 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 columns 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 columns 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 columns might contain statistical values from a prior release.) G
IBMREQD
CHAR(1)
NOT NULL
 A value of Y indicates that the row came from the basic machine-readable material (MRM) tape. 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 columns 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 columns 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 columns might contain statistical values from a prior release.) G