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

Contents
HP NonStop SQL/MX Reference Manual—544517-008
xvii
6. SQL/MX Language Elements (continued)
6. SQL/MX Language Elements (continued)
Numeric Value Expressions 6-49
Rowset Expressions 6-52
Identifiers 6-53
Regular Identifiers 6-53
Delimited Identifiers 6-53
SQL/MP Considerations for Identifiers 6-54
Examples of Identifiers 6-54
Indexes 6-56
SQL/MP Indexes 6-56
SQL/MX Indexes 6-56
Keys 6-57
Clustering Keys 6-57
First (Partition) Keys 6-58
Index Keys 6-59
Primary Keys 6-60
SYSKEYs 6-60
Literals 6-61
Character String Literals 6-61
Datetime Literals 6-65
Interval Literals 6-68
Numeric Literals 6-72
MXCI Parameters 6-74
MXCI Named Parameters 6-74
MXCI Unnamed Parameters 6-74
Type Assignment for Parameters 6-74
Working With MXCI Parameters 6-75
Use of Parameter Names 6-75
Examples of MXCI Parameters 6-76
Null 6-77
Using Null Versus Default Values 6-77
Defining Columns That Allow or Prohibit Null 6-78
Partitions 6-80
SQL/MP Tables 6-80
SQL/MX Tables 6-80
Predicates 6-82
BETWEEN Predicate 6-82
Comparison Predicates 6-85
EXISTS Predicate 6-89