SQL/MP Reference Manual

Index
HP NonStop SQL/MP Reference Manual—523352-013
Index-40
S
SAVEALL option, DUP command D-73
Saved commands, executing O-1
SAVEID option, DUP command D-73
Saving commands in a file S-2
SBB, in EXPLAIN report E-19
Scale
of expression results E-24
of numeric results E-24
SETSCALE function S-46
SCALE in COLUMNS table C-46
Scientific notation N-13
SCRATCH option, LOAD command L-28
SCRATCHON, parameter for FastSort Z-4
SCRATCH, parameter for FastSort Z-4
Search conditions
description of S-5
table selectivity E-19
WHERE clauses W-2
SEARCH DEFINEs D-32
Secondary partition P-19
SECONDARYEXT2, in FILES table F-28
SECONDARYEXT, in FILES table F-27
SECONDHIGHVALUE in COLUMNS
table C-46
SECONDLOWVALUE in COLUMNS
table C-46
Section header
in OBEY file O-1
using with SAVE command S-4
Section names, in command files O-2
SECURE clause
CREATE CATALOG statement C-132
CREATE TABLE statement C-159
CREATE VIEW statement C-168
SECURE command
ALLOWERRORS option S-8
and REVOKE S-68
CLEARONPURGE option S-8
description of S-7
LISTALL option S-9
OWNER option S-8
SECURE command (continued)
PROGID option S-9
TMF and S-9
SECURE file attribute
ALTER CATALOG statement A-8
ALTER COLLATION statement A-10
ALTER INDEX statement A-15
ALTER PROGRAM statement A-27
ALTER TABLE statement A-32
ALTER VIEW statement A-50
description of S-11
Security
catalogs and A-9
description of S-11
displaying D-56, F-12
Safeguard subsystem and A-28
specifying view C-168
super ID S-13
table and view dependencies and A-38
Security changing
index A-15
program A-27
table A-32
view A-50
Security file attributes for
CLEARONPURGE C-26
NOPURGEUNTIL N-5
OWNER O-10
SECURE S-11
VERIFIEDWRITES V-1
Security strings S-14
Security string, file attribute setting S-11
SECURITYMODE
in INDEXES table I-10
in PROGRAMS table P-31
in TABLES table T-3
SECURITYVECTOR
in INDEXES table I-10
in PROGRAMS table P-31
in TABLES table T-2