TMF Application Programmer's Guide (G06.26+)

TMF ARLIB2 Audit-Reading Procedures
HP NonStop TMF Application Programmer’s Guide—522419-005
5-68
ARGETMXCOLUMNINFO
02 NULLINDLENGTH type binary 32,0
Length in bytes of this column's NULL indicator. Value is 0 if the
column is not nullable. Otherwise, the NULL indicator will occupy
NULLINDLENGTH bytes, starting at offset NULLINDOFFSET.
Note that the NULL indicator may or may not be adjacent
to the data portion of the column. This value could be 0, 2, 4, or 8.
02 VARCHARLENOFFSET type binary 32,0
Similar to the NULL indicator, this describes the offset of the
length indicator for varchars (and maybe other variable-length
columns in the future). This value is undefined if the column
does not have a variable length indicator.
02 VARCHARLENLENGTH type binary 32,0 ! Zero if column not varchar.
Size (length) in bytes of the variable length indicator. This value
could be 0, 2, 4, or 8. A value of 0 indicates that the column does
not have a variable length indicator.
02 DATETIME-INTCODE type binary 32,0
Detailed information on datetime or interval ANSI datatypes.
See Tables 19 and 20 in the ANSI SQL92 standard or see the
SQLDTCODE_ and SQLINTCODE_ constants defined in file sqlcli.h.
02 DATETIME-FSCODE type binary 32,0
A more detailed description if COLUMN-FS-TYPE has the value 192
(_SQLDT_DATETIME). This value is sometimes also returned as
"precision" of a datetime value. See the SQLDTCODE_* constants
defined in file sqlcli.h for the values returned. This value is
undefined if COLUMN-FS-TYPE is not _SQLDT_DATETIME.
02 LEADING-PRECISION type binary 32,0
This value is only set for interval data types and indicates the
precision of the leading part of the interval (years, months, etc.).
02 PRECISION type binary 32,0
The precision (number of significant decimal digits)
for numeric values.
02 SCALE type binary 32,0
The scale (decimal digits after the decimal point) for numeric values.
For interval, time and timestamp columns, this is the "fraction
precision", the precision of fractional seconds (a value between 0
for whole seconds and 6 for microsecond resolution).