SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

Contents
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
xix
6. SQL/MX Language Elements
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
SQL/MP Tables 6-83
SQL/MX Tables
6-83
Predicates 6-85
BETWEEN Predicate 6-85
Comparison Predicates
6-88
EXISTS Predicate
6-92
IN Predicate 6-94
LIKE Predicate
6-97
NULL Predicate
6-99
Quantified Comparison Predicates
6-101
Rowset Predicates
6-104
Schemas 6-105
Search Condition
6-106
Considerations for Search Condition 6-107