NonStop SQL/MP Reference Manual

Index
NonStop SQL/MP Reference Manual—142115
Index-43
S
PURGE command P-33
SHARE clause, LOCK TABLE
statement L-41
SHARE option, LOAD command L-25
SHARED ACCESS on DDL
statements W-4
Shared lock
description of L-47
on SELECT statement S-21
SHARE clause L-41
Shift JIS character set C-17
Shorthand views
and UNION operator C-160
, S-26
AUDIT file attribute A-69
based on joins C-160
description of S-48, V-9
SHOW CONTROL command S-49
SHOW DEFINE command S-49
SHOW DEFMODE command S-50
SHOW LAYOUT command S-51
SHOW PARAM command S-51
SHOW PREPARED command S-52
SHOW REPORT command S-53
SHOW SESSION command S-54
SHOW STYLE command S-55
Similarity between protection views S-56
Similarity between tables S-56
SIMILARITY CHECK clause
ALTER TABLE statement A-30
ALTER VIEW statement A-46
CREATE TABLE statement C-149
CREATE VIEW statement C-158
Similarity checks S-55
SIMILARITYCHECK, in TABLES
table T-2
SIMILARITYINFO, in PROGRAMS
table P-31
Simple file names G-7
Simple fileset list F-29
Single spacing L-14
SKIP clause
DETAIL command D-46
report writer option R-12
SKIP option, CONTROL TABLE
directive C-78
SKIPIN option, LOAD command L-25
SKIPOUT option, COPY command C-116
SLACK file attribute S-58
SLACK option, LOAD command L-27
SMALLINT data syntax D-5
SMF (Storage Management
Foundation) S-76
SOME, in quantified predicate Q-5
SORT DEFINEs D-31
SORTED option, LOAD command L-26
Sorting
ORDER BY clause on SELECT S-22
parameters for Z-4
performance Z-3
SORTPROG process, controlling S-25
SOURCE option, CONVERT
command C-93
SOURCEDATE option, DUP
command D-71
SOURCEDICT option, LOAD
command L-28
SOURCEREC option, LOAD
command L-28
Space available in file F-20
SPACE clause, DETAIL command D-46
SPACE clause, report writer option R-12
SPACE layout option R-12, S-58
Spaces, suppressing in printing C-58
Splitting
indexes A-19
partitions, ALTER TABLE
statement A-31
tables A-31
the default detail line L-50
SPOOL DEFINEs D-31
Spooler