ALLBASE/SQL Reference Manual (36216-90216)
Index
Index 691
syntax, 563
starting a DBE session
using CONNECT
, 325
using START DBE
, 552
startup parameters
defined in START DBE NEW
,
560
in START DBE NEW
, 60
statement level
constraint error checking
, 521
DML atomicity
, 526
error enforcement explained
,
144
STOP DBE
syntax
, 571
stopping
ALLBASE/SQL using STOP
DBE
, 571
session using DISCONNECT
,
391
storage allocation
defined
, 45
storage audit element
in START DBE NEW
, 555
in START DBE NEWLOG
, 563
Storage Manager
defined
, 42
storage requirements
for specific data types
, 210
stored modules
and DROP MODULE
, 401
STOREDSECT
owner of system section tables
,
206
Structured Query Language
defined
, 41
subquery
as part of a predicate
, 116
correlated
, 126
defined
, 120
in a quantified predicate
, 122
in an EXISTS predicate
, 124
in an IN predicate
, 124
switching transactions
and MULTITRANSACTION
,
529
symmetric outer join
and UNION
, 130
defined
, 127
using UNION operator
, 131
SYSTEM
as owner
, 77
owner of system views
, 206
table locking
, 181
view names in UPDATE
STATISTICS
, 585
system catalog
contents
, 61, 105
defined
, 47
system tables
, 61
system views
, 61
table of system views
, 106
updating statistics
, 585
system DBEFileset
defined
, 47
system views
summary of
, 106
SYSTEM.ACCOUNT
resetting
, 486
SYSTEM.COLUMN
updating statistics for
, 585
SYSTEM.COUNTER
resetting
, 486
SYSTEM.DBEFILE
updating statistics for
, 585
SYSTEM.DBEFILESET
updating statistics for
, 585
SYSTEM.INDEX
updating statistics for
, 585
SYSTEM.SECTION
validating modules
, 594
SYSTEM.TABLE
monitoring for table size
, 178
updating statistics for
, 585
T
table
adding constraint to
, 301
allocating storage for
, 360
and check constraints
, 139
changing locking
, 301
creating
, 354
defined
, 44, 64
defining default columns in
,
301, 357
deleting all rows from
, 578
dropping
, 393, 406
dropping constraint from
, 301
explicit locking
, 460
granting authorities
, 436
implicit locking
, 354
inserting rows into
, 445
locking
, 183
locking explained
, 177
referenced
, 138
referencing
, 139
revoking authorities
, 489
updating statistics
, 585
TABLE DBEFiles
, 327
table names
in ALTER TABLE
, 301
in CREATE INDEX
, 334
in CREATE TABLE
, 354
in DELETE
, 378
in DELETE WHERE
CURRENT
, 381
in DROP INDEX
, 399
in DROP TABLE
, 406
in GRANT
, 437
in INSERT
, 445
in LOCK TABLE
, 460
in REVOKE
, 489
in TRANSFER OWNERSHIP
,
576
in TRUNCATE TABLE
, 578
in UPDATE statements
, 580
in UPDATE STATISTICS
, 585
in UPDATE WHERE
CURRENT
, 587
rules for
, 201
TableSpec
in SELECT
, 500
TEMP
and modules not stored
, 468
owner of modules
, 206
temporary section
validating
, 592
TempSpace
defined
, 63
dropping
, 408
names in CREATE
TEMPSPACE
, 365
names in DROP TEMPSPACE
,
408
using
, 365
TERMINATE QUERY
syntax
, 572
TERMINATE TRANSACTION
syntax
, 573
TERMINATE USER
syntax
, 574
terminating
a DBE session
, 62, 391, 479,
572, 574
transactions
, 495, 573
TERMINATION LEVEL
setting with SET
TRANSACTION
, 542
THEN
in procedures
, 442
TIME
conversions rules
, 504
defined
, 209
operations with values
, 217
storage requirements
, 210
valuesinarithmetic expression
,
218
timeout
and BEGIN WORK
, 314
and lock waits
, 194