| Nome da coluna |
Tipo de dados |
Descrição |
Uso |
| TBCREATOR |
CHAR(8) NOT NULL |
Authorization ID of the owner of he table that contains the column. |
G |
| TBNAME |
VARCHAR(18) 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(18) NOT NULL |
Name of the column. |
G |
| FLDTYPE |
CHAR(8) NOT NULL |
Data type of the encoded values in the field (36).
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 (36).
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, 0. |
G |
| FLDPROC |
CHAR(8) NOT NULL |
For a row describing a field procedure, the name of the procedure (36). |
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 (36). |
G |
| IBMREQD |
CHAR(1) NOT NULL |
Whether the row came from the basic machine-readable material (MRM)
tape:
N No
Y Yes |
G |
| EXITPARML |
SMALLINT NOT NULL |
For a row describing a field procedure, the length of the field procedure
parameter value block (36). |
G |
| PARMLIST |
VARCHAR(254) 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 (36). |
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) (36). |
G |
