SYSFIELDS
The SYSFIELDS view contains one row for every column that has a field procedure.
The column attributes in SYSFIELDS describe the internal column attributes defined by the field procedure. The following table describes the columns in the 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:
|
LENGTH | LENGTH | INTEGER | The length attribute of the column;
or, in the case of a decimal, numeric, or nonzero precision binary
column, its precision:
|
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
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.
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 |