ALLBASE/SQL Reference Manual (36216-90216)

Index
Index 687
and dropping authorization
groups
, 397
creating objects
, 77
how it is assigned
, 77
of objects
, 77
transferring
, 77, 576
P
page buffers
flushing
, 316
page level locking
, 177
pages
deadlocks
, 195
in DBEFiles
, 327
in TempSpaces
, 365
PARALLEL FILL option
setting in BEGIN WORK
, 312
parameter
in procedures
, 149
naming rules
, 205
using in procedures
, 146
partition
creating
, 91, 337
dropping
, 403
instance
, 91
setting with ALTER TABLE
,
301
understanding
, 91
Pascal preprocessor
defined
, 42
pattern matching
in LIKE predicate
, 272
performance
in procedures and rules
, 165
precision
defined
, 208
in DECIMAL operations
, 216
predicates
BETWEEN
, 264
COMPARISON
, 265
compatible data types in
, 263
definition of
, 262
EXISTS predicate
, 124, 267
IN predicate
, 123, 268
in search condition
, 262
LIKE predicate
, 272
NULL predicates
, 275
null values in
, 263
order of evaluation of
, 263
quantified predicate
, 120, 278
PREPARE
statements that cannot be
prepared
, 468
syntax
, 466
preparing statements
interactively and
programmatically
, 466
preprocessor
defined
, 42
tasks
, 93
preserving authorization
and DROP MODULE
, 401
primary
in an expression
, 228
pages
, 356
PRIMARY KEY
in ALTER TABLE
, 301
in CREATE TABLE
, 354
PRINT
in procedures
, 471
priority
settinginSETTRANSACTION
,
542
private
locking
, 183
PRIVATE tables
in CREATE TABLE
, 354
locking mode
, 64
privilege
defined
, 45
grantable
, 76
procedure
and transaction management
,
147
BEGIN
, 309
built-in variables in
, 151
caller recommended practices
,
156
checkpoint host variable
, 316
coding practices
, 156
comments within
, 156
control flow statements in
, 149
control language
, 442, 597
creating
, 146, 339
defined
, 137
executing
, 147
explained
, 145
local variables in
, 150
parameters in
, 149
PRINT statement
, 155, 471
queries in
, 151
RAISE ERROR
, 474
recommended practices
, 156
result set
, 342
RETURN
, 487
rule and non-rule invocation
,
163
runtime errors
, 155
SELECT in
, 152
specifying in DECLARE
CURSOR
, 373
using DECLARE
%%Variable%% in
, 376
using with rules
, 159
validating
, 592
with single format multiple row
sets
, 342
procedure cursor
defined
, 151, 342, 372
in ISQL
, 153
parameters in
, 149
query types
, 151
procedure names
in GRANT
, 437
procedures and rules
chains of
, 159
using
, 145, 157
programmatic database access
defined
, 42
programs
effect of DBEnvironment
changes on
, 94
PUBLIC
special name
, 206
PUBLIC tables
in CREATE TABLE
, 354
in GRANT
, 437
locking mode
, 64
PUBLICREAD tables
in CREATE TABLE
, 354
locking mode
, 64
PUBLICROW tables
in CREATE TABLE
, 354
locking mode
, 65
purging DBEFiles
using DROP DBEFILE
, 393
Q
quantified predicate
explained
, 120
syntax
, 278
queries
available with a procedure
cursor
, 151
defined
, 49
displaying access plan
, 133, 429
in procedures
, 151
range of complex types
, 116
simple types
, 112
updatable
, 136
query
block in SELECT
, 499
blocks in expression
, 116
complex
, 116
expression
, 116
expression in SELECT
, 499
file space used
, 511
modifying access plan
, 531
processor defined
, 42
result defined
, 110
results
, 499