SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

Index
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
Index-6
C
Considerations for GRANT
SECURITY_ADMIN 2-214
Considerations for REVOKE CREATE
CATALOG 2-246
Considerations for REVOKE CREATE
SCHEMA 2-247
Considerations for REVOKE
SECURITY_ADMIN 2-251
Considerations of GET ALL
SECURITY_ADMINS 2-201
Constraints
ALTER TABLE use of 2-12
CHECK 6-9
description of 6-9
implemented with indexes 2-26
limits C-1
NOT NULL 6-9
PRIMARY KEY 6-9
privileges 2-25
references column 2-18, 2-22, 6-9
REFERENTIAL INTEGRITY 6-9
UNIQUE 6-9
CONTROL QUERY DEFAULT statement
attributes 10-40
examples of 2-53
syntax diagram of 2-52
CONTROL QUERY SHAPE statement
examples of 2-61
syntax diagram of 2-54
CONTROL TABLE statement
examples of 2-69
syntax diagram of 2-66
CONVERTTIMESTAMP function
examples of 9-36
JULIANTIMESTAMP inverse
relationship to 9-36
syntax diagram of 9-36
Correlation names
examples of 6-11
purpose of 6-11
table reference use of 6-11
COS function
examples of 9-37
syntax diagram of 9-37
COSH function
examples of 9-37
syntax diagram of 9-37
COUNT function
DISTINCT clause within 9-38
examples of 9-39
syntax diagram of 9-38
CREATE CATALOG statement
authorization requirements 2-70
examples of 2-71
syntax diagram of 2-70
CREATE INDEX statement
ALLOCATE within 8-2
AUDITCOMPRESS within 8-3
authorization and availability
requirements 2-77
BLOCKSIZE within 8-4
CLEARONPURGE within 8-5
examples of 2-78
limits on indexes 2-78, C-1
MAXEXTENTS within 8-7
populating index 2-77
syntax diagram of 2-72
CREATE PROCEDURE statement
examples of 2-85
syntax diagram of 2-80
CREATE SCHEMA statement
authorization and availability
requirements 2-90
examples of 2-91
syntax diagram of 2-88
CREATE SQLMP ALIAS statement
examples of 2-94
syntax diagram of 2-92
usage restrictions 2-93
CREATE TABLE statement
ALLOCATE within 8-2