ALLBASE/SQL Reference Manual (36216-90216)

Index
Index 683
DISABLE RULES
syntax
, 390
using
, 163
disabling
audit logging
, 389
DISCONNECT
syntax
, 391
DISCONNECT CURRENT
nocurrentconnection following
,
104
disconnecting
from DBEnvironments
, 103
displaying
access plan
, 133, 429
DISTINCT
in SELECT
, 499, 505
DML ATOMICITY
settinginSETTRANSACTION
,
542
DML atomicity
setting
, 526
DO
in procedures
, 597
DROP DBEFILE
syntax
, 393
DROP DBEFILESET
syntax
, 395
DROP GROUP
syntax
, 397
DROP INDEX
syntax
, 399
DROP MODULE
syntax
, 401
DROP PARTITION
syntax
, 403
DROP PROCEDURE
syntax
, 404
DROP RULE
syntax
, 405
DROP TABLE
syntax
, 406
DROP TEMPSPACE
syntax
, 408
DROP VIEW
syntax
, 409
dropping
authorization groups
, 397
constraint
, 301
DBEFiles
, 393, 480
DBEFileSets
, 395
indexes
, 399, 406
modules
, 401
partition
, 403
procedures
, 404
rules
, 405
tables
, 406
TempSpaces
, 408
views
, 406, 409
dual logging
, 555
dynamic parameters
example of usage
, 232
example with INSERT
, 456
in DECLARE CURSOR
specifying
, 373
in EXECUTE PROCEDURE
,
421
syntax
, 452
dynamic preprocessing
defined
, 93
DESCRIBE
, 384
EXECUTE
, 415
EXECUTE IMMEDIATE
, 420
EXECUTE PROCEDURE
, 421
PREPARE
, 466
E
ELSE
in procedures
, 442
ELSEIF
in procedures
, 442
embedding SQL statements
explained
, 93
ENABLE AUDIT LOGGING
syntax
, 411
ENABLE RULES
syntax
, 413
using
, 163
enabling
audit logging
, 411
END DECLARE SECTION
syntax
, 414
ENDIF
in procedures
, 442
ENDWHILE
in procedures
, 597
error checking
explained
, 56
setting atomicity
, 526
transaction and statement level
constraints
, 521
using constraints
, 144
error handling
4008,4009,or-14024or greater
,
527
built-in variables
, 471
error number and text
, 474
in procedures invoked by rules
,
161
in procedures not invoked by
rules
, 154
RAISE ERROR
, 474
exclusive lock
defined
, 179
EXCLUSIVE mode
in LOCK TABLE
, 460
EXECUTE
syntax
, 415
EXECUTE authority
granting
, 437
EXECUTE IMMEDIATE
statements that cannot be used
with
, 420
syntax
, 420
EXECUTE PROCEDURE
in ISQL
, 153
syntax
, 421
using
, 147
executing
a procedure
, 421
dynamic statements
, 415, 420
EXISTS predicate
explained
, 124
syntax
, 267
explicit locking
, 460
expression
and null values
, 232
defined
, 227
in BETWEEN predicate
, 264
in COMPARISON predicate
,
265
in EXISTS predicate
, 267
in IN predicate
, 268
in LIKE predicate
, 272
in NULL predicates
, 275
order of evaluation of elements
in
, 232
overflow
, 232
syntax
, 228
truncation
, 232
type conversion
, 232
underflow
, 232
use
, 227
use of parentheses
, 232
USER expression value
, 269
extended characters
comparison prediate
, 266
F
FETCH
syntax
, 424
fetching rows
, 424
file names
explained
, 205
file space management
for tables and indexes
, 63
FILL option
setting in BEGIN WORK
, 312
fixed-length strings
defined
, 208
FLOAT
conversions rules
, 504