ALLBASE/SQL Reference Manual (36216-90216)

Index
Index 679
A
access plan
defined
, 429
modifying with SETOPT
, 531
access to databases
multiple connections
, 95
types
, 42
active connection
defined
, 103
active set
in DECLARE CURSOR
, 372
in FETCH
, 424
in OPEN
, 464
in REFETCH
, 476
actual parameter
using in procedures
, 149
ADD DBEFILE
syntax
, 293
ADD TO GROUP
syntax
, 295
ADD_MONTHS
in an expression
, 228
adding
ADD TO GROUP
, 295
column to table
, 301
constraint to table
, 301
DBEFiles
, 293
members to authorization
group
, 295
rows
, 81, 445
ADVANCE
syntax
, 297
aggregate functions
in an expression
, 228
in NULL predicates
, 275
ALL
in quantified predicate
, 278
in SELECT
, 505
all audit element
in START DBE NEW
, 555
in START DBE NEWLOG
, 563
ALLBASE/SQL
components
, 42
data types
, 207
definition
, 41
message catalog
, 550
names
, 201
users
, 51
allocating file space
in CREATE DBEFILESET
, 330
ALTER DBEFile
syntax
, 299
ALTER TABLE
syntax
, 301
to change table locking
, 301
to set audit partition
, 301
altering
DBEFile type
, 299
tables
, 301
ANY
in quantified predicate
, 278
application programming
and SQL statements
, 93
archive logging
wrapperDBE
, 92
archive mode
definition
, 560
use of BEGIN ARCHIVE
, 310
use of COMMIT ARCHIVE
, 322
archive record
use of COMMIT ARCHIVE
, 322
arithmetic operators
in an expression
, 228
asymmetric outer join
defined
, 127
atomicity
settinginSETTRANSACTION
,
542
audit
DBE understanding
, 91
disabling logging
, 389
elements default
, 91
elements understanding
, 91
functionality definition
, 91
information wrapperDBE
, 92
log record
, 91
partition with ALTER TABLE
,
301
tool
, 92
transactions with SQLAudit
, 92
audit logging
enabling
, 411
AUDIT NAME
in START DBE NEW
, 555
in START DBE NEWLOG
, 563
authorities
and program development
, 94
and program use
, 94
defined
, 45
granting
, 76, 436
granting on DBEFileSET
, 439
how to obtain
, 75
OWNER
, 75
REFERENCES
, 75
revoking
, 76, 489
RUN
, 75
summary of types
, 75
table and view
, 75
authorization
audit element in START DBE
NEWLOG
, 563
DBEFileSet in CREATE
PROCEDURE
, 344, 354,
373
DBEFileSet in CREATE VIEW
,
369
DBEFileSet in PREPARE
, 468
DBEFileSet in REVOKE
, 493
for a select cursor
, 373
in START DBE NEW
, 555
long column in ALTER TABLE
,
306, 307
long column in CREATE
TABLE
, 362
name
, 204
section in PREPARE
, 468
SECTIONSPACE in CREATE
RULE
, 349
authorization groups
adding members to
, 295
advantages of
, 79
creating
, 332
dropping
, 397
removing members from
, 482
use of
, 79
AUTOCOMMIT
DELETE parameter
, 378
VALIDATE parameter
, 592
automatic locking modes
in CREATE TABLE
, 64
autostart
and CONNECT
, 325
mode
, 560
B
base table
defined
, 67
basic names
objects having
, 201
rules governing
, 201
BEGIN
syntax
, 309
BEGIN ARCHIVE
syntax
, 310
BEGIN DECLARE SECTION
syntax
, 311
BEGIN WORK
and MULTITRANSACTION
,
529
in a procedure
, 147
read committed isolation level
,
312
read uncommitted isolation
level
, 312
repeatable read isolation level
,
312
syntax
, 312
BETWEEN predicate
in search condition
, 262
syntax
, 264
BINARY