ALLBASE/SQL Reference Manual (36216-90216)

690 Index
Index
using TempSpace, 63
space management
for tables and indexes
, 63
in CREATE DBEFILESET
, 330
special
authorities revoking
, 491
names
, 206
special predicates
EXISTS predicate
, 267
IN predicate
, 268
quantified predicate
, 278
SQL
defined
, 41
language structure
, 52
naming rules
, 201
usage
, 41, 60
SQL statement
ADD DBEFile
, 293
ADD TO GROUP
, 295
ADVANCE
, 297
ALTER DBEFILE
, 299
ALTER TABLE
, 301
BEGIN
, 309
BEGIN ARCHIVE
, 310
BEGIN DECLARE SECTION
,
311
BEGIN WORK
, 312
BULK FETCH
, 424
BULK INSERT
, 445
BULK SELECT
, 499
CHECKPOINT
, 316
CLOSE
, 319
COMMIT ARCHIVE
, 322
COMMIT WORK
, 323
CONNECT
, 325
CREATE DBEFILE
, 327
CREATE DBEFILESET
, 330
CREATE GROUP
, 332
CREATE INDEX
, 334
CREATE PARTITION
, 337
CREATE PROCEDURE
, 339
CREATE RULE
, 346
CREATE SCHEMA
, 351
CREATE TABLE
, 354
CREATE TEMPSPACE
, 365
CREATE VIEW
, 367
DECLARE %%Variable%%
, 376
DECLARE CURSOR
, 371
DELETE
, 378
DELETE WHERE CURRENT
,
381
DESCRIBE
, 384
DISABLE AUDIT LOGGING
,
389
DISABLE RULES
, 390
DISCONNECT
, 391
DROP DBEFILE
, 393
DROP DBEFILESET
, 395
DROP GROUP
, 397
DROP INDEX
, 399
DROP MODULE
, 401
DROP PARTITION
, 403
DROP PROCEDURE
, 404
DROP RULE
, 405
DROP TABLE
, 406
DROP TEMPSPACE
, 408
DROP VIEW
, 409
ENABLE AUDIT LOGGING
,
411
ENABLE RULES
, 413
END DECLARE SECTION
, 414
EXECUTE
, 415
EXECUTE IMMEDIATE
, 420
EXECUTE PROCEDURE
, 421
FETCH
, 424
GENPLAN
, 429
GRANT
, 436
GRANT ON DBEFILESET
, 439
IF
, 442
INCLUDE
, 444
INSERT
, 445
Labeled Statement
, 458
length
, 283
LOCK TABLE
, 460
LOG COMMENT
, 462
OPEN
, 464
PREPARE
, 466
PRINT
, 471
RAISE ERROR
, 474
REFETCH
, 476
RELEASE
, 479
REMOVE DBEFILE
, 480
REMOVE FROM GROUP
, 482
RENAME COLUMN
, 484
RENAME TABLE
, 485
RESET
, 486
RETURN
, 487
REVOKE
, 489
ROLLBACK WORK
, 495
SAVEPOINT
, 497
SELECT
, 499, 505
SET CONNECTION
, 519
SET CONSTRAINTS
, 521
SET DEFAULT DBEFILESET
,
524
SET DML ATOMICITY
, 526
SET MULTITRANSACTION
,
529
SET PRINTRULES
, 534, 536
SET TRANSACTION
, 542
SET USER TIMEOUT
, 548
SETOPT
, 531
SQLEXPLAIN
, 550
START DBE
, 552
START DBE NEW
, 555
START DBE NEWLOG
, 563
STOP DBE
, 571
summary table
, 283
TERMINATE QUERY
, 572
TERMINATE TRANSACTION
,
573
TERMINATE USER
, 574
TRANSFER OWNERSHIP
, 576
TRUNCATE TABLE
, 578
UPDATE
, 580
UPDATE STATISTICS
, 585
UPDATE WHERE CURRENT
,
587
VALIDATE
, 592
WHENEVER
, 595
WHILE
, 597
SQL statements
categories
, 54
within procedures
, 148
SQLAudit
auditing transactions
, 92
defined
, 43
SQLCA
INCLUDE SQLCA
, 444
used with SQLEXPLAIN
, 550
used with WHENEVER
, 595
SQLCheck
defined
, 43
SQLDA
INCLUDE SQLDA
, 444
used with FETCH
, 424
SQLEXPLAIN
on returning from procedures
,
156
syntax
, 550
SQLGEN
defined
, 43
SQLMigrate
defined
, 43
SQLMON
authority
, 199
defined
, 43
grant authority to run
, 438
monitoring locking
, 199
monitoring transactions
, 90
SQLUtil
defined
, 43
setting transaction limits
, 89
wrapdbe command
, 92
SQLVer
defined
, 43
START DBE
syntax
, 552
START DBE NEW
syntax
, 555
START DBE NEWLOG