| Nome da coluna |
Tipo do dado |
Descrição |
Uso |
| NAME |
VARCHAR(18) NOT NULL |
Name of the column. |
G |
| TBNAME |
VARCHAR(18) NOT NULL |
Name of the table or view that contains the column. |
G |
| TBCREATOR |
CHAR(8) NOT NULL |
Authorization ID of the owner of the table or view that contains the column. |
G |
| COLNO |
SMALLINT NOT NULL |
Numeric place of the column in the table or view. For example 4 (out of 10). |
G |
| COLTYPE |
CHAR(8) NOT NULL |
The type of the column specified in the definition of the column:
INTEGER Large integer
SMALLINT Small integer
FLOAT Floating-point
CHAR Fixed-length character
string
VARCHAR Varying-length
character string
LONGVAR Varying-length
character string
DECIMAL Decimal
GRAPHIC Fixed-length graphic
string
VARG Varying-length graphic
string
LONGVARG Varying-length graphic
string
DATE Date
TIME Time
TIMESTMP Timestamp
BLOB Binary large object
CLOB Character large object
DBCLOB Double-byte character
large object
ROWID Row ID data type
DISTINCT Distinct type
Whether a column described as VARCHAR, LONGVAR, CLOB, VARG, LONGVARG, DBCLOB or
BLOB is a long string column depends on its length attribute.
|
G |
| LENGTH |
SMALLINT NOT NULL |
Length attribute of the column or, in the case of a decimal column, its precision. The number
does not include the internal prefixes that are used to record the actual length and null state,
where applicable.
INTEGER 4
SMALLINT 2
FLOAT 4 or 8
CHAR Length of string
VARCHAR Maximum length of
string
LONGVAR Maximum length of
string
DECIMAL Precision of number
GRAPHIC Number of DBCS
characters
VARG Maximum number of DBCS
characters
LONGVARG Maximum number of DBCS
characters
DATE 4
TIME 3
TIMESTMP 10
BLOB 4 - The length of the field that is stored in the base table.
The maximum length of the LOB column is found in LENGTH2.
CLOB 4 - The length of the field that is stored in the base table.
The maximum length of the CLOB
|
G |
| LENGTH2 |
INTEGER NOT NULL |
Maximum length of the data retrieved from the column. Possible values are:
0 Not a LOB or ROWID column
40 For a ROWID column, the length of the returned value
1 to 2 147 483 647 bytes For a LOB column, the maximum length
|
G |
| NULLS |
CHAR(1) NOT NULL |
Whether the column can contain null values:
N No
Y Yes
|
G |
| HIGH2KEY |
CHAR(8) NOT NULL
FOR BIT DATA |
Second highest value of the column. Blank if statistics have not been gathered, or the column
is an indicator column or a column of an auxiliary table. If the column has a non-character data
type, the data might not be printable. |
S |
| |
|
|
S |
| LOW2KEY |
CHAR(8) NOT NULL
FOR BIT DATA |
Second lowest value of the column. Blank if statistics have not been gathered, or the column is
an indicator column or a column of an auxiliary table. If the column has a non-character data
type, the data might not be printable. |
G |
| STATSTIME |
TIMESTAMP NOT NULL |
If RUNSTATS updated the statistics, the date and time when the last invocation of RUNSTATS
updated the statistics. The default value is '0001-01-01-00.00.00.000000'. If the value is
'0001-01-02-00.00.00.000000', which indicates that an ALTER TABLE statement was
executed to change the length of a VARCHAR column, RUNSTATS should be run to update the
statistics before they are used. |
G |
| COLCARDF |
FLOAT(8) NOT NULL
WITH DEFAULT -1 |
Estimated number of distinct values in the column. For an indicator column, this is the number
of LOBs that are not null and have a length greater than zero. The value is -1 if statistics have
not been gathered. The value is -2 for the first column of an index of an auxiliary table. |
S |
| IBMREQD |
CHAR(1) NOT NULL
DEFAULT 'N' |
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 in topic D.0. |
G |
