Start of change

SYSFIELDS

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

The following table describes the columns in the SYSFIELDS view:

Table 1. SYSFIELDS view
Column name System Column Name Data Type Description
TABLE_SCHEMA DBNAME VARCHAR(128) The name of the SQL schema containing the table.
TABLE_NAME TBNAME VARCHAR(128) Name of the table that contains the column. This will be the SQL table name if one exists; otherwise, it will be the system table name.
COLUMN_NAME NAME VARCHAR(128) Name of the column. This will be the SQL column name if one exists; otherwise, it will be the system column name.
ORDINAL_POSITION COLNO INTEGER Numeric place of the column in the table, ordered from left to right.
DATA_TYPE COLTYPE VARCHAR(8) Type of column:
BIGINT
Big number
INTEGER
Large number
SMALLINT
Small number
DECIMAL
Packed decimal
NUMERIC
Zoned decimal
FLOAT
Floating point; FLOAT, REAL, or DOUBLE PRECISION
DECFLOAT
Decimal floating-point
CHAR
Fixed-length character string
VARCHAR
Varying-length character string
CLOB
Character large object string
GRAPHIC
Fixed-length graphic string
VARG
Varying-length graphic string
DBCLOB
Double-byte character large object string
BINARY
Fixed-length binary string
VARBIN
Varying-length binary string
BLOB
Binary large object string
DATE
Date
TIME
Time
TIMESTMP
Timestamp
DATALINK
Datalink
ROWID
Row ID
Start of changeXMLEnd of change
Start of changeXMLEnd of change
DISTINCT
Distinct type
LENGTH LENGTH INTEGER The length attribute of the column; or, in the case of a decimal, numeric, or nonzero precision binary column, its precision:
8 bytes
BIGINT
4 bytes
INTEGER
2 bytes
SMALLINT
Precision of number
DECIMAL
Precision of number
NUMERIC
8 bytes
FLOAT, FLOAT(n) where n = 25 to 53, or DOUBLE PRECISION
4 bytes
FLOAT(n) where n = 1 to 24, or REAL
8 bytes
DECFLOAT(16)
16 bytes
DECFLOAT(34)
Length of string
CHAR
Maximum length of string
VARCHAR or CLOB
Length of graphic string
GRAPHIC
Maximum length of graphic string
VARGRAPHIC or DBCLOB
Length of string
BINARY
Maximum length of binary string
VARBIN or BLOB
4 bytes
DATE
3 bytes
TIME
10 bytes
TIMESTAMP
Maximum length of datalink URL and comment
DATALINK
40 bytes
ROWID
Start of change2147483647 bytesEnd of change
Start of changeXMLEnd of change
Same value as the source type
DISTINCT
CHARACTER_MAXIMUM_LENGTH CHARLEN INTEGER

Nullable

Start of changeMaximum length of the string for binary, character, and graphic string and XML data types.

Contains the null value if the column is not a string.

End of change
CHARACTER_OCTET_LENGTH CHARBYTE INTEGER

Nullable

Start of changeNumber of bytes for binary, character, and graphic string and XML data types.

Contains the null value if the column is not a string.

End of change
NUMERIC_SCALE SCALE

INTEGER

Nullable

Scale of numeric data.

Contains the null value if the column is not decimal, numeric, or binary.

NUMERIC_PRECISION PRECISION INTEGER

Nullable

The precision of all numeric columns.
Note: This column supplies the precision of all numeric data types, including decimal floating-point and single-and double-precision floating point. The NUMERIC_PRECISION_RADIX column indicates if the value in this column is in binary or decimal digits.

Contains the null value if the column is not numeric.

NUMERIC_PRECISION_RADIX RADIX INTEGER

Nullable

Indicates if the precision specified in column NUMERIC_PRECISION is specified as a number of binary or decimal digits
2
Binary; floating-point precision is specified in binary digits.
10
Decimal; all other numeric types are specified in decimal digits.

Contains the null value if the column is not numeric.

CCSID CCSID INTEGER

Nullable

Start of changeThe CCSID value for CHAR, VARCHAR, CLOB, DATE, TIME, TIMESTAMP, GRAPHIC, VARGRAPHIC, DBCLOB, XML, and DATALINK columns.

Contains 65535 if the column is a BINARY, VARBIN, BLOB, or ROWID.

Contains the null value if the column is a numeric data type.

End of change
DATETIME_PRECISION DATPRC INTEGER

Nullable

The fractional part of a date, time, or timestamp.
0
For DATE and TIME data types
6
For TIMESTAMP data types (number of microseconds).

Contains the null value if the column is not a date, time, or timestamp.

FIELD_PROC FLDPROC VARCHAR(279)

Nullable

The name of the procedure.
PARMLIST PARMLIST DBCLOB(1M)

CCSID 1200
Nullable

The parameter list following FIELDPROC in the statement that defined the field procedure with insignificant blanks removed.
EXITPARM EXITPARM BLOB(1M)

Nullable

The parameter value block of the field procedure. This is the control block passed to the field procedure when it is invoked.
SYSTEM_COLUMN_NAME SYS_CNAME CHAR(10) The system name of the column
SYSTEM_TABLE_NAME SYS_TNAME CHAR(10) The system name of the table
SYSTEM_TABLE_SCHEMA SYS_DNAME CHAR(10) The system name of the schema
End of change