TMF Application Programmer's Guide (H06.06+, J06.03+)
TMF ARLIB2 Audit-Reading Procedures
HP NonStop TMF Application Programmer’s Guide—540139-009
5-42
ARFETCHFIELDVALUE
ARFETCHFIELDVALUE
This procedure retrieves both the before-image and after-image from a field-
compressed update (UPDATE FIELDCOMP) record. These are SQL-only records. This
procedure cannot be used with audit records for SQL/MX objects. 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 whose
before-image and/or after-image is to be retrieved. This value can be found in the
NonStop SQL/MP catalog (the COLNUMBER field of the COLUMNS table).
before-image output, optional
INT .EXT:ref:*
is a buffer in the application process in which the before-image of the field is
returned.
max-before-copy-len input, optional
INT:value
CALL ARFETCHFIELDVALUE ( return-code ! o
, field-number ! i
, [ before-image ] ) ! o
, [ max-before-copy-len ] ) ! i
, [ actual-before-len ] ) ! o
, [ after-image ] ) ! o
, [ max-after-copy-len ] ) ! i
, [ actual-after-len ] ! o
, [ next-field ] ! o
, [ sub-system ] ! o
, [ ar-error ] ); ! o
Errors (<0) Table 5-3 describes the error codes.
Warnings (>0) Bit 14, when set, indicates that the before image is longer than
max-before-copy-len. At least one byte was truncated from
the end.
Bit 15, when set, indicates that the after image is longer than
max-after-copy-len. At least one byte was truncated from
the end.










