ALLBASE/SQL Reference Manual (36216-90216)
Index
Index 681
explained, 126
CREATE DBEFILE
syntax
, 327
CREATE DBEFILESET
syntax
, 330
CREATE GROUP
syntax
, 332
CREATE INDEX
syntax
, 334
CREATE PARTITION
syntax
, 337
CREATE PROCEDURE
explained
, 146
syntax
, 339
CREATE RULE
invoking a procedure through
,
147
syntax
, 346
using
, 158
CREATE SCHEMA
syntax
, 351
CREATE TABLE
LANG = clause
, 67
syntax
, 354
CREATE TEMPSPACE
syntax
, 365
CREATE VIEW
syntax
, 367
creating
audit DBE
, 91
authorization groups
, 332
constraints
, 354
databases
, 60
DBEFile
, 327
DBEFileSets
, 330
DBEnvironments
, 60, 555
indexes
, 334
partition
, 91, 337
tables
, 354
TempSpace
, 365
views
, 367
CS isolation level
explained
, 175
in SET SESSION
, 537
in SET TRANSACTION
, 543
current
function in an expression
, 228
language defined
, 57
row in FETCH
, 424
row in REFETCH
, 476
timeout value in
multi-transaction
, 99
current connection
in CONNECT
, 325
none after DISCONNECT
CURRENT
, 104
setting
, 96
cursor names
in CLOSE
, 319
in DECLARE CURSOR
, 371
in DELETE WHERE
CURRENT
, 381
in FETCH
, 424
in OPEN
, 464
in UPDATE WHERE
CURRENT statement
, 587
rules for
, 201
cursor stability (CS)
explained
, 175
cursor stability isolation level
in SET SESSION
, 536
in SET TRANSACTION
, 542
cursors
active set
, 424, 476
advancing
, 297
closed
, 571
closing
, 319, 479, 495
current row
, 424, 476
declaring
, 371
deleting rows with
, 372, 381
in procedures
, 153
opening
, 464
procedurecursorparametersin
,
149
retrieving rows with
, 372, 424,
476
updatability of
, 372
updating data with
, 371, 372
use of
, 95, 371
using in procedures
, 160
using multiple
, 464
cycle
in chain of grants
, 76
D
data
access
, 48, 75
in native languages
, 226
manipulation
, 109
data audit element
in START DBE NEW
, 555
in START DBE NEWLOG
, 563
data buffer pages
in START DBE
, 552
in START DBE NEW
, 555
in START DBE NEWLOG
, 563
data definition statements
in procedures
, 164
data types
comparisons between
, 211
conversion
, 213
effect of
, 207
of column added to existing
table
, 301
of columns in joins
, 512
rules governing
, 207
table of
, 208
valid combinations
, 213
database
administration activities
, 105
administrator defined
, 51
control of access to
, 75
creation
, 60
creation (CREATE SCHEMA)
,
351
logical definition
, 44
physical definition
, 45
statistics
, 106
DATE
conversions rules
, 504
defined
, 209
operations with values
, 217
storage requirements
, 210
valuesinarithmetic expression
,
218
date/time conversion functions
in an expression
, 228
DATETIME
conversions rules
, 504
defined
, 209
operations with values
, 217
storage requirements
, 210
values in arithmetic
expressions
, 218
DBA
automatic grant of authority
, 76
defined
, 51
statements authorized to use
,
76
DBE sessions
and autostart mode
, 62
defined
, 48
multiuser
, 62
setting the current connection
,
519
single-user
, 62
starting
, 62, 325, 552
terminating
, 62, 479, 572, 574
DBECon file
creation
, 555
defined
, 47
naming conventions
, 205
overriding parameters
, 552
parameters
, 560
DBECreator
authorization
, 76
defined
, 61
statements authorized to use
,
76
DBEFile names
in ADD DBEFile
, 293