SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

Index
HP NonStop SQL/MX Reference Manual—544517-008
Index-6
C
CONTROL QUERY DEFAULT
statement (continued)
examples of 2-37
syntax diagram of 2-36
CONTROL QUERY SHAPE statement
examples of 2-45
syntax diagram of 2-38
CONTROL TABLE statement
examples of 2-53
syntax diagram of 2-50
CONVERTTIMESTAMP function
examples of 9-33
JULIANTIMESTAMP inverse
relationship to 9-33
syntax diagram of 9-33
Correlation names
examples of 6-11
purpose of 6-11
table reference use of 6-11
COS function
examples of 9-34
syntax diagram of 9-34
COSH function
examples of 9-34
syntax diagram of 9-34
COUNT function
DISTINCT clause within 9-35
examples of 9-36
syntax diagram of 9-35
CREATE CATALOG statement
authorization requirements 2-54
examples of 2-55
syntax diagram of 2-54
CREATE INDEX statement
ALLOCATE within 8-2
AUDITCOMPRESS within 8-3
authorization and availability
requirements 2-61
BLOCKSIZE within 8-4
CLEARONPURGE within 8-5
CREATE INDEX statement (continued)
examples of 2-62
limits on indexes 2-62, C-1
MAXEXTENTS within 8-7
populating index 2-61
syntax diagram of 2-56
CREATE PROCEDURE statement
examples of 2-69
syntax diagram of 2-63
CREATE SCHEMA statement
authorization and availability
requirements 2-73
examples of 2-73
syntax diagram of 2-71
CREATE SQLMP ALIAS statement
examples of 2-78
syntax diagram of 2-75
usage restrictions 2-76
CREATE TABLE statement
ALLOCATE within 8-2
AUDITCOMPRESS within 8-3
authorization and availability
requirements 2-92, 2-97
BLOCKSIZE within 8-4
CLEARONPURGE within 8-5
DEFAULT clause 7-2
examples of 2-97
LIKE specification 2-93
MAXEXTENTS within 8-7
reducing space 2-94
syntax diagram of 2-79
CREATE TRIGGER statement
authorization and availability
requirements 2-104
syntax diagram of 2-101
CREATE VIEW statement
authorization and availability
requirements 2-113
examples of 2-114
LOCATION file option within 2-112