TMF Application Programmer's Guide (H06.06+, J06.03+)

TMF ARLIB2 Audit-Reading Procedures
HP NonStop TMF Application Programmer’s Guide—540139-009
5-66
ARGETFIELDINFO
ARGETFIELDINFO
This procedure returns information about the fields contained in a field-compressed
update audit record. This procedure works only with SQL records of type UPDATE
FIELDCOMP (15). This procedure cannot be used with audit records for SQL/MX
objects (see the ARGETMXCOLUMNINFO procedure). The object type can be
determined by checking the OBJECTTYPE field in the ARRECORD.
return-code output
INT .EXT:ref:1
is a returned value indicating the outcome of this procedure.
field-number input
INT:value
is the zero-based ordinal field number within the data record of the field about
which information is to be returned. This value can be found in the NonStop
SQL/MP catalog (the COLNUMBER field of the COLUMNS table).
field-type output, optional
INT .EXT:ref:1
is one of a set of constants that identify the SQL type of the field, as indicated
below. Note that these correspond to the field type values found in the
NonStop SQL/MP Catalog (in the FSDATATYPE field of the COLUMNS Table).
CALL ARGETFIELDINFO ( return-code ! o
, field-number ! i
, [ field-type ] ! o
, [ field-length ] ! o
, [ is-key-length ] ! o
, [ next-field ] ! o
, [ null-allowed ] ! o
, [ flags ] ! o
, [ collation-def ] ! o
, [sub-system ] ! o
, [ar-error ] ); ! o
Errors (<0) Table 5-3 describes the error codes.
Warnings (>0) None.
Value Field Type Literal Name
0 Fixed-length ASCII character ARVALUE-ASCII-F
1 Fixed-length upshifted ASCII ARVALUE-ASCII-F-U
64 Variable-length ASCII character ARVALUE-ASCII-V
65 Variable-length upshifted ASCII ARVALUE-ASCII-V-U