ALLBASE/SQL Reference Manual (36216-90216)
692 Index
Index
SET TRANSACTION
statement
, 542
SET USER TIMEOUT
statement
, 548
START DBE NEWLOG
, 568
value setting
, 97
values in DBECon file
, 552
transaction attributes
setting in BEGIN WORK
, 312
settinginSETTRANSACTION
,
542
transaction level constraint
checking
errors
, 521
transactions
aborted
, 571
and data consistency
, 48
and multiple connections
, 95
and recovery
, 48
and timeouts
, 95
automatic rollback of
, 495
committing
, 82
defined
, 48, 82
effect of terminating
, 323
implicit vs. explicit
, 313
in a procedure
, 147
inaprocedureinvokedbya rule
,
163
in START DBE NEW
, 556
locks released
, 313
management
, 82
maximum in START DBE
, 552
maximum in START DBE
NEWLOG
, 564
mode setting
, 99
priority
, 195
SET USER TIMEOUT
, 548
simultaneous with BEGIN
WORK
, 313
statements that must be in the
same
, 313
terminating
, 313, 323, 495
TRANSFER OWNERSHIP
syntax
, 576
transferring ownership
, 576
when dropping authorization
group
, 397
TRUNCATE TABLE
syntax
, 578
truncation
and native language data
, 226
in expressions
, 232
of data
, 212
tuple
defined
, 44
type conversion
and overflow
, 212
and truncation
, 212
defined
, 213
in expressions
, 232
in search conditions
, 263
U
underflow
defined
, 212
in expression
, 232
undetectable deadlock
in multi-transaction mode
, 97
UNION
and outer join
, 130
character constants with
, 119
in outer joins
, 130
in queries
, 117
in SELECT
, 503
UNION ALL form
, 117
unique
indexes
, 334
rows
, 505
unique constraint
defined
, 138
in ALTER TABLE
, 301
in CREATE TABLE
, 354
updatability
of cursors
, 372
rules
, 136
UPDATE
displaying access plan
, 133, 429
statement type in rules
, 581,
588
syntax
, 580
UPDATE STATISTICS
syntax
, 585
UPDATE WHERE CURRENT
syntax
, 587
updating
data
, 82
system catalog statistics
, 585
USER expression value
expressions
, 269
IN predicate
, 269
user mode
defined
, 48
in CONNECT
, 325
user table locking
explained
, 181
user timeout value
in SET TRANSACTION
, 542
in START DBE
, 552
in START DBE NEW
, 555
in START DBE NEWLOG
, 563
using ALLBASE/SQL
ad hoc queries
, 51
application programming
, 51
database administration
, 51
using SQL
summarized
, 60
V
VALIDATE
syntax
, 592
validity checking
of data
, 68
of databases
, 137
value
comparisons
, 211
extensions in search conditions
,
263
VARBINARY
conversions rules
, 504
long data type defined
, 208
storage requirements
, 210
VARCHAR
conversions rules
, 504
defined
, 208
storage requirements
, 210
variable-length strings
defined
, 208
variables
BEGIN DECLARE SECTION
,
311
END DECLARE SECTION
, 414
indicator
, 94
input
, 94
output
, 94
verb
defined
, 52
view names
in CREATE VIEW
, 367
in DELETE
, 378
in DELETE WHERE
CURRENT
, 381
in DROP TABLE
, 406
in DROP VIEW
, 409
in INSERT
, 445
in REVOKE
, 489
in TRANSFER OWNERSHIP
,
576
in UPDATE
, 580
in UPDATE WHERE
CURRENT
, 587
rules for
, 201
views
and check constraints
, 141
base tables
, 67
creating
, 67, 367
defined
, 44, 67
dropping
, 406, 409
granting authorities
, 436
inserting data
, 446
restrictions in using
, 67, 368
revoking authorities
, 489