NonStop SQL/MP Reference Manual

Index
NonStop SQL/MP Reference Manual—142115
Index-45
S
CONTINUE C-65
cost of executing D-49
CREATE ASSERTION (ANSI/ISO
SQL) S-70
CREATE CATALOG C-127
CREATE COLLATION C-130
CREATE CONSTRAINT C-131
CREATE INDEX C-133
CREATE TABLE C-143
CREATE VIEW C-156
DCL D-16
DDL D-19
DECLARE CURSOR D-22
DELETE D-37
DESCRIBE D-41
DESCRIBE INPUT D-40
description of S-72
DROP D-60
DROP ASSERTION S-70
DSL D-65
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-3
INSERT I-14
LOCK TABLE L-41
maximum length L-11
name of P-24
OPEN O-4
PREPARE P-24
prepared P-24
RELEASE R-1
ROLLBACK WORK R-23
SELECT S-18
summary S-72
UNLOCK TABLE U-1
UPDATE U-3
UPDATE STATISTICS U-7
use with catalog tables C-8
Static SQL S-75
Statistics
description of S-76
displaying D-49
enabling display of S-42
file F-22
from PREPARE P-24
retrieving from catalog tables U-11
selecting current compiler with U-10
updating U-7
using for better access plan S-76
STATISTICS display, FILEINFO
command F-22
Statistics for partition U-10
STATISTICS option
FILEINFO command F-11
SET SESSION command S-42
STATISTICSTIME, in BASETABS
table B-1
Status, checking with SQLCA I-4
STOP AT option, CONTROL TABLE
directive C-78
Stopping a SELECT command C-2
Storage Management Foundation
(SMF) S-76
Stored commands
deleting R-18
displaying S-53
String functions S-78
String literals S-78
and quotation marks S-79
Structured files F-8
Style options
displaying S-55
resetting R-22
saving in file S-2