SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

Contents
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
xix
6. SQL/MX Language Elements
DEFINEs 6-38
Using DEFINEs 6-38
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