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

TMF ARLIB2 Audit-Reading Procedures
HP NonStop TMF Application Programmer’s Guide—522419-005
5-60
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:ref
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
Errors (<0) Table 5-3 (later in this section) 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
130 Signed 16-bit integer ARVALUE-SMALLINT-S
131 Unsigned 16-bit integer ARVALUE-SMALLINT-U