SQL/MX 2.x Reference Manual (H06.04+)

Index
HP NonStop SQL/MX Reference Manual—540440-003
Index-6
C
CONTROL QUERY DEFAULT
statement (continued)
examples of 2-34
syntax diagram of 2-33
CONTROL QUERY SHAPE statement
examples of 2-41
syntax diagram of 2-35
CONTROL TABLE statement
examples of 2-49
syntax diagram of 2-46
CONVERTTIMESTAMP function
examples of 9-30
JULIANTIMESTAMP inverse
relationship to 9-30
syntax diagram of 9-30
Correlation names
examples of 6-10
purpose of 6-10
table reference use of 6-10
COS function
examples of 9-31
syntax diagram of 9-31
COSH function
examples of 9-31
syntax diagram of 9-31
COUNT function
DISTINCT clause within 9-32
examples of 9-33
syntax diagram of 9-32
CREATE CATALOG statement
authorization requirements 2-50
examples of 2-51
syntax diagram of 2-50
CREATE INDEX statement
ALLOCATE within 8-2
AUDITCOMPRESS within 8-3
authorization and availability
requirements 2-57
BLOCKSIZE within 8-4
CLEARONPURGE within 8-5
CREATE INDEX statement (continued)
examples of 2-58
limits on indexes 2-58, C-1
MAXEXTENTS within 8-7
populating index 2-57
syntax diagram of 2-52
CREATE PROCEDURE statement
examples of 2-64
syntax diagram of 2-59
CREATE SCHEMA statement
authorization and availability
requirements 2-68
examples of 2-69
syntax diagram of 2-66
CREATE SQLMP ALIAS statement
examples of 2-73
syntax diagram of 2-70
usage restrictions 2-71
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-87
MAXEXTENTS within 8-7
reducing space 2-88
syntax diagram of 2-74
CREATE TRIGGER statement
authorization and availability
requirements 2-98
syntax diagram of 2-95
CREATE VIEW statement
authorization and availability
requirements 2-107
examples of 2-108
LOCATION file option within 2-106