SYSFIELDS

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

Start of change The column attributes in SYSFIELDS describe the internal column attributes defined by the field procedure. End of change 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 XML XML 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 The integral part of ((p+1)/2)+7 where p is the precision of the timestamp TIMESTAMP Maximum length of datalink URL and comment DATALINK 40 bytes ROWID 2147483647 bytes XML Same value as the source type DISTINCT
CHARACTER_MAXIMUM_LENGTH	CHARLEN	INTEGER Nullable	Maximum 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.
CHARACTER_OCTET_LENGTH	CHARBYTE	INTEGER Nullable	Number of bytes for binary, character, and graphic string and XML data types. Contains the null value if the column is not a string.
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	The 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.
DATETIME_PRECISION	DATPRC	INTEGER Nullable	The fractional part of a date, time, or timestamp. 0 For DATE and TIME data types 0-12 For TIMESTAMP data types (number of fractional seconds). 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