SQL/MP Reference Manual

Index
HP NonStop SQL/MP Reference Manual—523352-013
Index-43
S
SORT DEFINEs D-32
SORTED option, LOAD command L-27
Sorting
ORDER BY clause on SELECT S-23
parameters for Z-4
performance Z-4
SORTPROG process, controlling S-25
SOURCE option, CONVERT
command C-97
SOURCEDATE option, DUP
command D-73
SOURCEDICT option, LOAD
command L-29
SOURCEREC option, LOAD
command L-29
Space available in file F-19
SPACE clause, DETAIL command D-49
SPACE clause, report writer option R-11
SPACE layout option R-10, S-58
Spaces, suppressing in printing C-63
Splitting
indexes A-19
partitions, ALTER TABLE
statement A-34
tables A-34
the default detail line L-53
SPOOL DEFINEs D-33
Spooler
device width R-20
use of O-8
SQL
and host communication H-6
compilation, prepare statements P-25
compiler event messages Z-11
identifiers S-59
message file Z-18
programmatic E-2
statement execution time D-52
statements S-73
static S-77
SQL compiler event messages Z-11
SQL directive S-59
SQL SENSITIVE flag F-35
SQL tables
converting an Enscribe file to C-94
loading data into L-18
rules for copying C-124
SQL VALID flag F-35
SQLCA
description of I-4
effect of DECLARE CURSOR D-24
SQLCI
commands S-63
description of S-60
processing rules T-8
prompts S-60
summary of report writer
commands R-7
using DEFINEs from D-30
SQLCODE S-67
SQLCOMP command
authority for S-15
description of S-67
with CATALOG DEFINE D-37
with DEFINEs D-31
SQLDA
and FETCH statement F-3
and OPEN statement O-5
DESCRIBE INPUT statement D-41
description of I-4
INCLUDE SQLDA directive I-4
SQLNULLABLE option
COPY command C-117
LOAD command L-23
load operations L-40
SQLSA
description of I-6
effect of DECLARE CURSOR D-24
INCLUDE SQLSA directive I-6
SQLSTATE status codes S-69