SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

Index
HP NonStop SQL/MX Reference Manual—523725-004
Index-6
C
CONTROL TABLE statement
examples of 2-51
syntax diagram of 2-48
CONVERTTIMESTAMP function
examples of 9-32
JULIANTIMESTAMP inverse
relationship to 9-32
syntax diagram of 9-32
Correlation names
examples of 6-10
purpose of 6-10
table reference use of 6-10
COS function
examples of 9-33
syntax diagram of 9-33
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-52
examples of 2-53
syntax diagram of 2-52
CREATE INDEX statement
ALLOCATE within 8-2
AUDITCOMPRESS within 8-3
authorization and availability
requirements 2-59
BLOCKSIZE within 8-4
CLEARONPURGE within 8-5
examples of 2-60
limits on indexes 2-60
MAXEXTENTS within 8-8
populating index 2-59
syntax diagram of 2-54
CREATE PROCEDURE statement
examples of 2-66
CREATE PROCEDURE
statement (continued)
syntax diagram of 2-61
CREATE SCHEMA statement
authorization and availability
requirements 2-70
examples of 2-70
syntax diagram of 2-68
CREATE SQLMP ALIAS statement
examples of 2-74
syntax diagram of 2-71
usage restrictions 2-72
CREATE TABLE statement
ALLOCATE within 8-2
AUDITCOMPRESS within 8-3
authorization and availability
requirements 2-87
BLOCKSIZE within 8-4
CLEARONPURGE within 8-5
DEFAULT clause 7-2
examples of 2-91
LIKE specification 2-88
MAXEXTENTS within 8-8
reducing space 2-89
syntax diagram of 2-75
CREATE TRIGGER statement
authorization and availability
requirements 2-99
syntax diagram of 2-96
CREATE VIEW statement
authorization and availability
requirements 2-108
examples of 2-109
LOCATION file option within 2-107
syntax diagram of 2-105
updatability requirements 2-108
WITH CHECK OPTION within 2-108
CROSS join, description of 2-187
CROSS_PRODUCT_CONTROL
default 10-53
Ctrl-c, effect on queries 1-4