A description of the fields in QREPORT 001 follows:
COLUMN NAME The name of the column included in the schema table.
SCHEMA NAME / TABLE NAME The schema and table name associated with the column.
DATATYPE / NULL ATTR. The data type of the named column, and an indicator to specify whether the column can or cannot contain null values.
PREC. The number of digits in a numeric value.
SCALE The number of digits to the right of the decimal point in a numeric value.
COLUMN / OFFSET The offset within a row to the data for the named column and the offset within a row to the null indicator value for the column. Offsets are relative to zero.
NULL INTERNAL LENGTH The internal length of the data for the named column and the internal length of the null indicator value for the column.
DEFAULT VALUE Indicates whether the WITH DEFAULT clause was specified for the column.
COL NUM IN TABLE The relative position of the column in the table.
|
Copyright © 2013 CA.
All rights reserved.
|
|