SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

Contents
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
xxx
6. SQL/MX Language Elements
Considerations for Interval Value Expressions 6-49
Examples of Interval Value Expressions 6-51
Numeric Value Expressions 6-52
Considerations for Numeric Value Expressions 6-53
Examples of Numeric Value Expressions 6-55
Rowset Expressions 6-55
Identifiers 6-56
Regular Identifiers 6-56
Delimited Identifiers 6-56
Specifying Delimited Identifiers in OSS Command-Line Arguments 6-56
SQL/MP Considerations for Identifiers 6-57
Using SQL/MX Reserved Words in SQL/MP Names 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
SQL/MP Index Keys 6-62
SQL/MX Index Keys 6-62
Primary Keys 6-63
SYSKEYs 6-63
Selecting SYSKEY 6-63
Literals 6-64
Character String Literals
6-64
Considerations for Character String Literals 6-65
SQL/MP Considerations for Character String Literals 6-66
Examples of Character String Literals
6-67
Datetime Literals
6-68
SQL/MP Considerations for Datetime Literals 6-68
Examples of Datetime Literals
6-70
Interval Literals
6-71
Considerations for Interval Literals
6-73
SQL/MP Considerations for Interval Literals
6-73
Examples of Interval Literals 6-75
Numeric Literals
6-75
Examples of Numeric Literals 6-76