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

TMF ARLIB2 Audit-Reading Procedures
HP NonStop TMF Application Programmer’s Guide—522419-005
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
is the maximum number of bytes to copy into before-image. This value must be
supplied if before-image is present.
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
Errors (<0) Table 5-3 (later in this section) 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.