ALLBASE/SQL Reference Manual (36216-90216)
684 Index
Index
defined, 208
storage requirements
, 210
FORCE
VALIDATE parameter
, 592
FOREIGN KEY
in CREATE TABLE
, 354
formal parameter
using in procedures
, 149
Fortran preprocessor
defined
, 42
free log space
checkpoint host variable
, 316
FROM
in simple queries
, 111
fully qualified name
, 204
G
generating
log comment
, 462
GENPLAN
explained
, 133
syntax
, 429
with SYSTEM and CATALOG
views
, 433, 435
GRANT
MONITOR authority
, 199
syntax
, 436
WITH GRANT OPTION
explained
, 76
GRANT ON DBEFILESET
syntax
, 439
grantable privileges
explained
, 76
revoking
, 77
grants
automatic
, 354
explicit (GRANT)
, 437
grantable privileges
, 76
implicit (CREATE TABLE)
, 354
issuing
, 436
issuing for DBEFileSet
, 439
revoking
, 489
which authorities can be
granted
, 76
who can issue them
, 76
granularity
of locking
, 179
GROUP BY
in simple queries
, 111
group names
in ADD TO GROUP
, 295
in CREATE GROUP
, 332
in REMOVE FROM GROUP
,
482
in REVOKE
, 489, 491
in TRANSFER OWNERSHIP
,
576
rules for
, 201
grouping rows
in SELECT
, 511
groups
adding members to
, 295
creating
, 332
dropping
, 397
in query result
, 511
removing members from
, 482
H
hash
in CREATE TABLE
, 354
specifying with SETOPT
, 531
HAVING
in SELECT
, 507
in simple queries
, 111
host variables
declaration of
, 311, 414
differences from local variables
,
150
free log space
, 316
in an expression
, 228
in CONNECT
, 325
in EXECUTE IMMEDIATE
,
420
in FETCH
, 424
in INSERT
, 446, 456
in LIKE predicates
, 272
in PREPARE
, 468
in ROLLBACK WORK
, 495
in SAVEPOINT
, 497
in SET CONNECTION
, 519
in SQLEXPLAIN
, 550
in UPDATE
, 580
in UPDATE WHERE
CURRENT
, 587
input
, 94
naming rules
, 205
output
, 94
procedure parameter
, 316
procedure value
, 316
use of
, 94
HPODBSS
reserved owner name
, 206
HPRDBSS
owner of system tables
, 206
hyphen
as comment initiator
, 53
I
IF
in procedures
, 442
syntax
, 442
IN predicate
explained
, 123
syntax
, 268
USER expression value
, 269
INCLUDE
syntax
, 444
incrementing
DBEFile size
, 327
index
allocating storage for
, 360
creating
, 71, 334
defined
, 71
dropping
, 393, 399, 406
duplicate keys
, 335
locking explained
, 181
name in CREATE INDEX
, 334
name in DROP INDEX
, 399
name rules for
, 201
null values in
, 335
number of keys in
, 334
order of entries
, 335
restrictions in using
, 71
specifying with SETOPT
, 531
uses for
, 71
INDEX DBEFiles
, 327
indicator variables
example in predicates
, 270
in expressions
, 228, 232
use of
, 94
INNER
in SELECT
, 510
inner join
defined
, 116, 126
syntax
, 509
INSERT
statement type in rules
, 451,
454, 455
syntax
, 445, 453
use of
, 81
inserting
rows in a table
, 81
rows in INSERT
, 445
values in constraint columns
,
143
instance of partition
, 91
INTEGER
conversions rules
, 504
defined
, 208
storage requirements
, 210
integrity constraint
defined
, 68, 137
example
, 141
intention
exclusive lock
, 179
share lock
, 179
interactive database access
defined
, 42
INTERVAL
conversions rules
, 504
defined
, 209