SQL/MP Reference Manual

Index
HP NonStop SQL/MP Reference Manual—523352-013
Index-44
S
SQL.CATALOGS table
See also CATALOGS table
and CREATE CATALOG C-134
and CREATE SYSTEM CATALOG
command C-152
description of C-11
STABLE access
concurrency summary A-3
description of A-1
in EXPLAIN report E-16
nonaudited tables A-2
UPDATE statement U-3
Standard prompt S-60
Standards conformance S-67
Starting to log to a file L-52
Statements
ALTER CATALOG A-8
ALTER COLLATION A-10
ALTER INDEX A-13
ALTER PROGRAM A-27
ALTER TABLE A-29
ALTER TABLE ADD
CONSTRAINT S-70
ALTER TABLE DROP
CONSTRAINT S-70
ALTER VIEW A-50
atomicity S-68
BEGIN WORK B-3
CLOSE C-26
COMMENT C-48
COMMIT WORK C-56
CONTINUE C-70
cost of executing D-52
CREATE ASSERTION (ANSI/ISO
SQL) S-71
CREATE CATALOG C-132
CREATE COLLATION C-137
CREATE CONSTRAINT C-139
CREATE INDEX C-142
CREATE TABLE C-154
Statements (continued)
CREATE VIEW C-166
DCL D-18
DDL D-20
DECLARE CURSOR D-23
DELETE D-39
DESCRIBE D-43
DESCRIBE INPUT D-41
description of S-73
DROP D-63
DROP ASSERTION S-71
DSL D-67
EXECUTE E-7
EXECUTE IMMEDIATE E-11
FETCH F-3
FREE RESOURCES F-30
GET CATALOG OF SYSTEM G-1
GET VERSION G-2
GET VERSION OF PROGRAM G-4
HELP TEXT H-4
INSERT I-14
LOCK TABLE L-45
maximum length L-13
name of P-25
OPEN O-5
PREPARE P-25
prepared P-25
RELEASE R-1
ROLLBACK WORK R-21
SELECT S-18
summary S-73
UNLOCK TABLE U-1
UPDATE U-3
UPDATE STATISTICS U-7
use with catalog tables C-9
Static SQL S-77
Statistics
description of S-78
displaying D-52