ALLBASE/SQL Reference Manual (36216-90216)

682 Index
Index
in ALTER DBEFile, 299
in CREATE DBEFILE
, 327
in DROP DBEFILE
, 393
in REMOVE DBEFile
, 480
rules for
, 201
DBEFile type
in ALTER DBEFile
, 299
in CREATE DBEFILE
, 327
DBEFile0
defined
, 47
naming
, 559
DBEFiles
adding
, 293
altering type of
, 299
creating
, 327
defined
, 45
dropping
, 393, 480
for data
, 45
for indexes
, 45
incrementing size
, 327
purging
, 393
relation to DBEFileset
, 45
removing from DBEFileSet
,
393, 395, 480
size range
, 327
type
, 327
using
, 327
DBEFileSet
authorization in CREATE
PROCEDURE
, 344, 354,
373
authorization in CREATE
VIEW
, 369
authorization in PREPARE
, 468
authorization in REVOKE
, 493
creating
, 330
defined
, 45
dropping
, 395
dropping default
, 395
dynamic section
, 468
dynamic statement
, 468
for a check constraint
, 354
for a long column
, 354
for a table
, 354
in DECLARE CURSOR
, 371
relation to DBEFiles
, 45
setting a default
, 524
specifying for a cursor
, 371
specifying for a view
, 367
DBEFileSet names
in ADD DBEFile
, 293
in CREATE TABLE
, 360
in REMOVE DBEFile
, 480
rules for
, 201
DBELog1
defined
, 47
DBELog2
defined
, 47
DBEnvironment
components
, 47
configuration
, 60, 555
connecting to
, 96
creating
, 60
creating audit
, 91
defined
, 47
disconnecting from
, 103
initial privileges
, 61
naming conventions
, 205
obtaining information on
, 106
startup parameters
, 60
statistics
, 106
DBEnvironment name
in CONNECT
, 325, 519
in DISCONNECT
, 391
in START DBE
, 552
in START DBE NEW
, 555
in START DBE NEWLOG
, 563
DBEUserID
defined
, 203
in ADD TO GROUP
, 295
in GRANT
, 437
in REMOVE FROM GROUP
,
482
in RESET
, 486
in REVOKE
, 489, 491
in TERMINATE QUERY
, 572
in TERMINATE USER
, 574
rules governing
, 203
DDL Enabled flag
defined
, 561
deadlock
avoidance of
, 197
definition
, 195
detection/resolution
, 195
example
, 195
in multi-transaction mode
, 97
DECIMAL
conversions rules
, 504
defined
, 208
in operations
, 216
storage requirements
, 210
DECLARE
and local variables in a
procedure
, 150
DECLARE %%Variable%%
syntax
, 376
DECLARE CURSOR
syntax
, 371
declaring
cursors
, 371
host variables
, 311, 414
local variables in a procedure
,
376
default
columns in tables
, 301
ownership discussed
, 78
default DBEFileSet
dropping
, 395
setting
, 524
default partition
in START DBE NEW
, 555
in START DBE NEWLOG
, 563
deferred error checking
constraint (SET
CONSTRAINTS)
, 521
explained
, 144
referential constraint
, 144
defining objects
authorization groups
, 332
DBEFile
, 327
DBEFileSets
, 330
DBEnvironments
, 555
default columns in tables
, 301
tables
, 354
TempSpace
, 365
views
, 367
definition
of a column
, 355
of audit functionality
, 91
procedure cursor
, 151
select cursor
, 151
wrapperDBE
, 92
definition audit element
in START DBE NEW
, 555
in START DBE NEWLOG
, 563
DELETE
displaying access plan
, 133, 429
statement type in rules
, 379,
382
syntax
, 378
DELETE WHERE CURRENT
syntax
, 381
deleting
all rows from tables
, 578
authorization groups
, 397
data
, 82
DBEFiles
, 393
DBEFileSets
, 395
indexes
, 399, 406
modules
, 401
rows
, 82, 378
rows using a cursor
, 381
tables
, 406
TempSpaces
, 408
views
, 406, 409
DESCRIBE
syntax
, 384
describing
dynamic statements
, 384
DISABLE AUDIT LOGGING
syntax
, 389