ALLBASE/SQL Reference Manual (36216-90216)
Index
Index 689
SAVEPOINT
in a procedure
, 147
setting
, 497
syntax
, 497
using
, 495
scale
defined
, 208
in DECIMAL operations
, 216
scoping
transaction and session
attributes
, 87
search condition
compatible predicates
, 263
defined
, 111
definition
, 261
in complex queries
, 116
in DELETE
, 378
subquery in
, 120
syntax
, 262
type conversion in
, 263
use for
, 261
value extensions in
, 263
SearchCondition
in CREATE TABLE
, 359
section
authorization in PREPARE
, 468
defined
, 93
invalidation by TRUNCATE
TABLE
, 578
invalidation through
procedures
, 164
semi-permanent
, 466
validating
, 592
section audit element
in START DBE NEW
, 555
in START DBE NEWLOG
, 563
SECTIONSPACE
authorization in CREATE
RULE
, 349
security
of database
, 75
SELECT
displaying access plan
, 133, 429
in CREATE VIEW
, 367
in DECLARE CURSOR
, 371
in procedures
, 152
syntax
, 499, 505
use of
, 109
with cursor in procedures
, 153
select cursor
authorization in CREATE
PROCEDURE
, 373
defined
, 151, 342, 372
within a procedure
, 151
select list
defined
, 110, 506
selecting data
discussed
, 109
grouping rows
, 511
maximum columns
, 507
SELECT
, 499
unique rows
, 505
semi-permanent section
creating with PREPARE
, 466
owner
, 206
SEMIPREM owner
, 206
serializable isolation level
in SET SESSION
, 537
in SET TRANSACTION
, 543
session
DBE
, 62
SET CONNECTION
syntax
, 519
set constraint type statement
explained
, 144
SET CONSTRAINTS
syntax
, 521
SET DEFAULT DBEFILESET
syntax
, 524
SET DML ATOMICITY
syntax
, 526
SET MULTITRANSACTION
explained
, 99
syntax
, 529
SET PRINTRULES
syntax
, 534, 536
SET PRINTRULES ON
to trace rule chaining
, 164
SET SESSION
CS isolation level
, 537
cursor stability isolation level
,
536
RC isolation level
, 537
read committed isolation level
,
537
read uncommitted isolation
level
, 537
repeatable read isolation level
,
536
RU isolation level
, 537
serializable isolation level
, 537
SET TRANSACTION
CS isolation level
, 543
cursor stability isolation level
,
542
RC isolation level
, 543
read committed isolation level
,
542
read uncommitted isolation
level
, 543
repeatable read isolation level
,
542
RR isolation level
, 543
RU isolation level
, 543
serializable isolation level
, 543
syntax
, 542
SET USER TIMEOUT
syntax
, 548
SETOPT
syntax
, 531
validating modules
, 592
setting
constraint checking with SET
TRANSACTION
, 542
constraints to deferred
, 521
current connection
, 96
default DBEFileSet
, 524
DML atomicity
, 526
multiple-transaction mode
, 100
options with BEGIN WORK
,
312
savepoints
, 497
the current connection
, 519
timeout values
, 97
transaction mode
, 99
setting DML ATOMICITY
with SET TRANSACTION
, 542
setting DML atomicity
, 144
setting transaction attributes
with SET TRANSACTION
, 542
share
intention exclusive lock
, 179
lock defined
, 179
SHARE mode
in LOCK TABLE
, 460
share mode
locking
, 182
SHARE UPDATE mode
in LOCK TABLE
, 460
simple names
defined
, 203
simultaneous transactions
with BEGIN WORK
, 313
single-transaction mode
explained
, 99
inSETMULTITRANSACTION
,
529
single-user mode
defined
, 48
in a DBE session
, 62
SIX (SHARE INTENT
EXCLUSIVE) locks
, 460
SIX lock
explained
, 179
SMALLINT
conversions rules
, 504
defined
, 208
storage requirements
, 210
SOME
in quantified predicate
, 278
sorting