SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

Index
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-004
Index-6
C
Considerations for REVOKE CREATE
SCHEMA 2-321
Considerations for REVOKE
SECURITY_ADMIN 2-326
Considerations of GET ALL
SECURITY_ADMINS 2-234
Constraints
ALTER TABLE use of 2-19
CHECK 6-9
description of 6-9
implemented with indexes 2-33
limits C-1
NOT NULL 6-9
PRIMARY KEY 6-9
privileges 2-32
references column 2-25, 2-29, 6-9
REFERENTIAL INTEGRITY 6-9
UNIQUE 6-9
CONTROL QUERY DEFAULT statement
attributes 10-39
examples of 2-61
syntax diagram of 2-60
CONTROL QUERY SHAPE statement
examples of 2-69
syntax diagram of 2-62
CONTROL TABLE statement
examples of 2-77
syntax diagram of 2-74
CONVERTTIMESTAMP function
examples of 8-36
JULIANTIMESTAMP inverse
relationship to 8-36
syntax diagram of 8-36
Correlation names
examples of 6-11
purpose of 6-11
table reference use of 6-11
COS function
examples of 8-37
syntax diagram of 8-37
COSH function
examples of 8-37
syntax diagram of 8-37
COUNT function
DISTINCT clause within 8-38
examples of 8-39
syntax diagram of 8-38
CREATE CATALOG statement
authorization requirements 2-78
examples of 2-79
syntax diagram of 2-78
CREATE INDEX statement
ALLOCATE within 9-2
AUDITCOMPRESS within 9-3
authorization and availability
requirements 2-85
BLOCKSIZE within 9-4
CLEARONPURGE within 9-5
examples of 2-86
limits on indexes 2-86, C-1
MAXEXTENTS within 9-7
populating index 2-85
syntax diagram of 2-80
CREATE PROCEDURE statement
examples of 2-93
syntax diagram of 2-88
CREATE SCHEMA statement
authorization and availability
requirements 2-98
examples of 2-99
syntax diagram of 2-96
CREATE SQLMP ALIAS statement
examples of 2-106
syntax diagram of 2-104
usage restrictions 2-105
CREATE TABLE statement
ALLOCATE within 9-2
AUDITCOMPRESS within 9-3
authorization and availability
requirements 2-124, 2-136