SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

Contents
HP NonStop SQL/MX Reference Manual—640322-001
xviii
6. SQL/MX Language Elements (continued)
6. SQL/MX Language Elements (continued)
Using DEFINEs From MXCI 6-40
DEFINEs of Class MAP 6-40
Expressions 6-41
Character Value Expressions 6-41
Datetime Value Expressions 6-43
Interval Value Expressions 6-47
Numeric Value Expressions 6-52
Rowset Expressions 6-55
Identifiers 6-56
Regular Identifiers 6-56
Delimited Identifiers 6-56
SQL/MP Considerations for Identifiers 6-57
Examples of Identifiers 6-57
Indexes 6-59
SQL/MP Indexes 6-59
SQL/MX Indexes 6-59
Keys 6-60
Clustering Keys 6-60
First (Partition) Keys 6-61
Index Keys 6-62
Primary Keys 6-63
SYSKEYs 6-63
Literals 6-64
Character String Literals 6-64
Datetime Literals 6-68
Interval Literals 6-71
Numeric Literals 6-75
MXCI Parameters 6-77
MXCI Named Parameters 6-77
MXCI Unnamed Parameters 6-77
Type Assignment for Parameters 6-77
Working With MXCI Parameters 6-78
Use of Parameter Names 6-78
Examples of MXCI Parameters 6-79
Null 6-80
Using Null Versus Default Values 6-80
Defining Columns That Allow or Prohibit Null 6-81
Partitions 6-83