SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
A-74
AUDIT File Attribute
AUDIT File Attribute
AUDIT is a Guardian file attribute that determines whether or not a table is audited by
TMF. AUDIT applies to key-sequenced, relative, and entry-sequenced tables.
Audited tables are protected by TMF, but you must perform all input and output on an
audited table (except for queries with BROWSE access) within a TMF transaction.
Nonaudited tables can be accessed without a transaction in progress but are not
protected by TMF. If you turn off AUDIT, TMF online dumps become invalid and cannot
be used for subsequent recovery operations.
For more information, see TMF Transactions on page T-6.
Considerations—AUDIT

An index always has the same AUDIT attribute as its underlying table. If you
change the AUDIT attribute for a table, SQL automatically changes the AUDIT
attribute for its indexes.

A protection view has the same AUDIT value as the underlying table.
For a shorthand view, the AUDIT value is:

AUDIT if all referenced tables and views are audited.

NO AUDIT if all referenced tables and views are nonaudited.

Mixed if any of the referenced views are mixed or if at least one of the
referenced tables or views is audited and at least one is nonaudited.
y 074400 000171 79 121 Lowercase y 122
z 075000 000172 7A 122 Lowercase z 123
{ 075400 000173 7B 123 Opening brace 124
| 076000 000174 7C 124 Vertical line 125
} 076400 000175 7D 125 Closing brace 126
~ 077000 000176 7E 126 Tilde 127
DEL 077400 000177 7F 127 Delete 128
** The “grave” accent character is not printable
{ AUDIT | NO AUDIT }
The table default is AUDIT.
Table A-6. ASCII Character Set (page 5 of 5)
Octal
Char Left Right Hex Dec Meaning Ordinal