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

TMF ARLIB2 Audit-Reading Procedures
HP NonStop TMF Application Programmer’s Guide—522419-004
5-66
ARGETMXCOLUMNINFO
The definitions of IMAGEINFO and COLUMNINFO are shown below. They are
declared in the ARDDL2 file (and the related AR* files). The values returned in all the
length and offset fields in these structures are in bytes. The order of the columns
reflects the order they were declared in, not their order in the on-disk record, which can
differ from the declared order for SQL/MX objects.
definition IMAGEINFO.
02 COLUMN-COUNT type binary 32,0
02 ENCODEDKEYLENGTH type binary 32,0
02 filler type pic x (120)
02 COLUMNINFO-ARRAY type COLUMNINFO occurs 1 to
MAXMXCOLUMNS times depending on COLUMN-COUNT.
end ! of definition IMAGEINFO
definition COLUMNINFO.
02 COLUMN-NUM type binary 32,0
Column number (same as in SQL/MX metadata tables).
Column number zero is the system key.
02 COLUMN-ANSI-TYPE type binary 32,0
ANSI type code for the data type of the column.
See table 18 in the ANSI SQL92 standard.
02 COLUMN-FS-TYPE type binary 32,0
FS data type of the column. See file sqlcli.h for the _SQLDT_*
defines that describe the codes returned here
02 KEYFLAG type binary 32,0
Set to -1 if this column is not part of the clustering key, set to
the key column position otherwise (first column is column #0).
02 DATAOFFSET type binary 32,0 ! Offset into the Image Record.
Offset in bytes of the data portion of this column. Note that the data
portion does not include the null indicator or the varchar length.
02 DATALENGTH type binary 32,0
Length in bytes of the data portion of this column. The data portion
will occupy DATALENGTH bytes, starting at offset DATAOFFSET.
02 NULLINDOFFSET type binary 32,0
Offset of the NULL indicator of this column in bytes. This value
is undefined if the column is not nullable.