ALLBASE/SQL Reference Manual (36216-90216)

680 Index
Index
conversions rules, 504
long data type defined
, 208
storage requirements
, 210
built-in variable
differences from local variables
,
151
similar to SQLCA elements
, 151
using in procedures
, 151
BULK operations
FETCH
, 424
INSERT
, 445
SELECT
, 499
use of
, 95
C
C preprocessor
defined
, 42
caller of a procedure
recommended practices for
, 156
Cartesian product
defined
, 114
CASCADE
explained
, 77
case sensitive
comparison predicate
, 266
comparisons
, 211
CATALOG
owner of catalog views
, 206
catalog views
explained
, 105
chain
of grants
, 76
of rules
, 159, 164
changing
connections
, 529
data
, 82
DBEFile type
, 299
table locking
, 301
CHAR
conversions rules
, 504
defined
, 208
native language data
, 226
storage requirements
, 210
check constraint
defined
, 68, 139
in a view
, 141
in ALTER TABLE
, 301
in CREATE TABLE
, 354, 359
search condition
, 140
CHECKPOINT
record
, 316
syntax
, 316
use of
, 316
checkpoint for STOP DBE
, 571
class names
in REVOKE
, 489, 491
rules for
, 201
classes
creating
, 80
use of
, 80
clause
defined
, 52
CLOSE
syntax
, 319
closing cursors
, 319
clustered indexes
, 334
COBOL preprocessor
defined
, 42
MICROFOCUS
, 42
coding practices
for procedures
, 156
column names
in ALTER TABLE
, 301
in an expression
, 228
in CREATE INDEX
, 334
in CREATE TABLE
, 357
in CREATE VIEW
, 367
in INSERT
, 445
in null predicates
, 275
rules for
, 201
columns
adding to tables
, 301
and Cartesian product
, 513
common columns in join
, 512
defined
, 44
defining
, 355
definition
, 65
maximum allowed in tables
, 357
maximum allowed in views
, 367
order of display
, 512
comment audit element
in START DBE NEW
, 555
in START DBE NEWLOG
, 563
comment initiator
within SQL statements
, 53
comment partition
in START DBE NEW
, 555
in START DBE NEWLOG
, 563
COMMIT ARCHIVE
syntax
, 322
COMMIT WORK
in a procedure
, 147
syntax
, 323
common columns
in SELECT
, 512
COMPARISON predicate
character collation sequence
,
266
in search condition
, 262
operators
, 265
syntax
, 265
complex queries
defined
, 116
range of types
, 116
compound identifiers
in names
, 203
concatenate
data types
, 231
strings
, 230
concurrency
and table size
, 178
control
, 167
configuring a DBEnvironment
in START DBE NEW
, 555
summarized
, 60
CONNECT
syntax
, 325
connection
and SET CONNECTION
, 519
changing
, 529
disconnecting
, 391
initiating
, 325
terminating
, 103
to DBEnvironments
, 96
use with timeouts
, 95
connection name
in CONNECT
, 325
in SET CONNECTION
, 519
in START DBE
, 552
in START DBE NEWLOG
, 563
constant
in an expression
, 228
in NULL predicates
, 275
constraint
check constraint
, 68, 137
defined
, 137
defining
, 354
error checking and SET
statement
, 521
error checking in SET
TRANSACTION
, 542
example
, 141
constraint checking
settinginSETTRANSACTION
,
542
control block
in START DBE
, 552
in START DBE NEW
, 555
in START DBE NEWLOG
, 563
control flow statements
in procedures
, 149
RETURN
, 487
control language
in procedures
, 442, 597
controlling
error checking level
, 526
conversion rules
data in query expressions
, 504
copying rows
to tables and views
, 82
correlated subquery