NonStop SQL/MP Reference Manual

Index
NonStop SQL/MP Reference Manual—142115
Index-44
S
device width R-22
use of O-8
SQL
and host communication H-5
compilation, prepare statements P-24
compiler event messages Z-10
identifiers S-60
message file Z-16
programmatic E-1
statement execution time D-49
statements S-72
static S-75
tables
converting an Enscribe file to C-89
loading data into L-17
rules for copying C-120
SQL compiler event messages Z-10
SQL directive S-60
SQL SENSITIVE flag F-35
SQL VALID flag F-35
SQLCA
description of I-4
effect of DECLARE CURSOR D-22
SQLCI
commands S-64
description of S-61
processing rules T-7
prompts S-61
summary of report writer
commands R-9
using DEFINEs from D-29
SQLCODE S-67
SQLCOMP command S-67
authority for S-15
with CATALOG DEFINE D-37
with DEFINEs D-29
SQLDA
and FETCH statement F-4
and OPEN statement O-5
defined I-5
DESCRIBE INPUT statement D-40
INCLUDE SQLDA directive I-5
SQLSA
defined I-6
effect of DECLARE CURSOR D-22
INCLUDE SQLSA directive I-6
SQLSTATE status codes S-69
SQL.CATALOGS table
and CREATE CATALOG C-128
and CREATE SYSTEM CATALOG
command C-142
description of C-9
See CATALOGS table
SQL/MP errors D-20
STABLE access
concurrency summary A-3
description of A-1
in EXPLAIN report E-17
nonaudited tables A-2
UPDATE statement U-3
Standard prompt S-61
Standards conformance S-67
Starting to log to a file L-49
Statements
ALTER CATALOG A-7
ALTER COLLATION A-9
ALTER INDEX A-12
ALTER PROGRAM A-25
ALTER TABLE A-27
ALTER TABLE ADD
CONSTRAINT S-69
ALTER TABLE DROP
CONSTRAINT S-69
ALTER VIEW A-45
atomicity S-68
BEGIN WORK B-2
CLOSE C-25
COMMENT C-43
COMMIT WORK C-51