NonStop SQL/MP Reference Manual

Index
NonStop SQL/MP Reference Manual—142115
Index-41
S
CREATE CATALOG statement C-128
CREATE TABLE statement C-149
CREATE VIEW statement C-158
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-9
PROGID option S-9
TMF and S-10
SECURE file attribute
ALTER CATALOG statement A-8
ALTER COLLATION statement A-9
ALTER INDEX statement A-15
ALTER PROGRAM statement A-25
ALTER TABLE statement A-30
ALTER VIEW statement A-45
description of S-11
Security
altering S-7
catalogs and A-8
changing
index A-15
program A-25
table A-30
view A-45
description of S-11
displaying D-53, F-13
file attributes for
CLEARONPURGE C-24
NOPURGEUNTIL N-4
OWNER O-10
SECURE S-11
VERIFIEDWRITES V-1
Safeguard subsystem and A-26
specifying view C-158
super ID S-13
table and view dependencies and A-36
Security strings S-14
Security string, file attribute setting S-11
SECURITYMODE
in INDEXES table I-10
in PROGRAMS table P-30
in TABLES table T-2
SECURITYVECTOR
in INDEXES table I-10
in PROGRAMS table P-30
in TABLES table T-2
SEGMENT, parameter for FastSort Z-4
SELECT command, directing output of O-8
SELECT DISTINCT clause, and CREATE
VIEW statement S-68
SELECT statement
and scale S-47
BROWSE access S-21
cancelling, in SQLCI C-2
description of S-18
DISTINCT clause D-55, S-19
dynamic SQL S-24
FOR UPDATE OF clause S-24
FROM clause S-20
GROUP BY clause S-22
HAVING clause S-21
INTO clause S-19
lock mode option S-21
lock release summary L-46
ORDER BY clause S-22
restrictions for view definitions C-157
suppressing row count display R-25
table privileges S-68
UNION operator S-23
Selecting data
cursor declaration D-22
, D-23
distinct rows S-19
matching values L-2
search conditions S-5