ALLBASE/SQL Reference Manual (36216-90216)

686 Index
Index
hash key size, 361
host variable names
, 416
host variables
, 465
items for DISTINCT option
, 505
length of index key
, 361
log file size
, 567
number of partitions
, 555, 557,
565
PrimaryPages
, 356
tables per query
, 506
TempSpace
, 365
timeout
, 553, 564, 568
maxpartitions
in START DBE NEW
, 555
in START DBE NEWLOG
, 563
MaxTransactions
, 553
message
buffer in procedures
, 155
catalog
, 550
error number
, 474
for PRINT statements
, 472
number 5000
, 472
MICROFOCUS
COBOL preprocessor
, 42
minimum
PrimaryPages
, 356
mixed DBEFiles
, 327
module names
in DROP MODULE
, 401
in PREPARE
, 466
rules for
, 201
modules
access plan for validation
, 532
created by preprocessor
, 93
dropping
, 401
effect of DBEnvironment
changes on
, 94
extracting
, 532
owner of
, 468
validating
, 592
MONITOR
authority
, 199
multiple
connections example
, 97
connections using
, 95
DBEnvironments
, 95
multitable operations
SELECT
, 499
using
, 112
multi-transaction mode
explained
, 100
undetectable deadlocks
, 97
use with one DBE
, 101
multitransaction mode
inSETMULTITRANSACTION
,
529
multiuser mode
defined
, 48
in a DBE session
, 62
N
names
basic
, 201
used in ALLBASE/SQL
, 201
naming
database objects
, 201
DBEConfile
, 205
DBEnvironment
, 205
DBEUserID
, 203
host variables
, 205
owners
, 203
system files
, 205
with native language objects
,
203
NATIVE CHAR
conversions rules
, 504
native language
ALLBASE/SQL object names
,
203
character data
, 226
current language
, 57
defaults
, 57
in columns and tables
, 67
in creating a DBEnvironment
,
60
setting and resetting
, 58
support overview
, 58
tables in ALTER TABLE
, 301
tables in CREATE TABLE
, 354
NATIVE VARCHAR
conversions rules
, 504
NATURAL
in SELECT
, 510
natural inner join
defined
, 116, 126
NATURAL JOIN
in SELECT
, 512, 513
n-computer
and double quotes
, 67
defined
, 57
NOT NULL
in CREATE TABLE
, 360
in defining a column
, 66
NULL predicate
in search condition
, 262
syntax
, 275
null values
and altering tables
, 301
and FETCH
, 424
and INSERT
, 446
and UPDATE
, 580
and UPDATE WHERE
CURRENT
, 587
as index keys
, 335
behavior in Cartesian product
,
514
behavior in joins
, 514
defined
, 215
in an expression
, 232
in Cartesian product
, 114
in joins
, 114
in search conditions
, 263
O
objects
defined
, 48
native language names in
, 203
owner of
, 77
OPEN
syntax
, 464
operators
arithmetic
, 228
comparison
, 265
logical
, 262
optimizer
displaying access plan
, 133, 429
modifying plan with SETOPT
,
531
ORDER BY
in simple queries
, 111
specifying result columns
, 512
order of evaluation
of elements in an expression
,
232
orphaned log files
wrapperDBE
, 92
outer join
defined
, 126
syntax
, 509
using UNION operator
, 130
overflow
in expression
, 232
of data
, 212
owner
authorization group
, 44
changing
, 576
class
, 44
how to become one
, 77
individuals
, 44
of modules
, 468
of system section tables
, 206
of system tables
, 206
privileges
, 79
use of name
, 77
who can be one
, 77
owner names
origin of
, 77
rules governing
, 203
specification of
, 45
use of
, 77
ownership