SQL/MP Reference Manual

Index
HP NonStop SQL/MP Reference Manual—523352-013
Index-3
B
AS clause (continued)
report writer option R-10
AS DATE/TIME clause
description of A-67
report writer option R-10
ASCII character set A-70, C-18
Associativity and UNION ALL S-27
Asterisk, in subtotal label S-88
Atomicity, statement S-68
Attributes
See File Attributes
AUDIT
in FILES table F-27
in VIEWS table V-10
AUDIT file attribute
and BUFFERED attribute A-75
description of A-74
set by DUP D-78
turning off for loading data L-18, L-34
views and C A-74, C-170
Audit fix-up phase W-6
Audit trails A-75, W-5, W-6
AUDITCOMPRESS file attribute
ALTER INDEX statement A-15
ALTER TABLE statement A-32
CREATE INDEX statement C-146
CREATE TABLE statement C-160
description of A-75
turned off for WITH SHARED
ACCESS W-6
AUDITCOMPRESS, in FILES table F-28
Audited files C-56
Audited objects
BUFFERED file attribute B-11
description of A-76
FREE RESOURCES statement F-30
lock holder L-50
lock release summary L-48
NO SERIALWRITES file attribute S-32
processing rules T-7
Audited objects (continued)
rollback work R-21
Audited tables A-76
Authorization
description of S-11
requirements summary S-15
AUTOCOMPILE, in PROGRAMS
table P-31
AUTOWORK option
SET SESSION command S-39
TMF transactions T-8
AVG function A-76
B
BACKUP utility B-1, U-17
Base tables
creating C-154
description of T-1
BASETABS catalog table B-1
BEGIN DECLARE SECTION directive B-2
Begin TMF transaction B-3
BEGIN WORK statement B-3
BETWEEN predicate B-4
BIND NAMES option, CONTROL QUERY
directive C-74
Blanks, breaking at A-61
Block buffering
See Virtual sequential block buffering
Block size
limit L-6
of index F-17
recommendation B-5
BLOCKIN option, LOAD command L-24
BLOCKOUT option, COPY
command C-118
BLOCKSIZE file attribute B-5
BLOCKSIZE, in FILES table F-27
BLOCK, parameter for FastSort Z-4
Boolean operators S-5
Break column, subtotaling S-86