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

Contents
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
xxxi
6. SQL/MX Language Elements
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
Determining Whether a Column Allows Null 6-81
Null in DISTINCT, GROUP BY, and ORDER BY Clauses 6-82
Null and Expression Evaluation Comparison 6-82
Partitions 6-83
SQL/MP Tables 6-83
SQL/MX Tables 6-83
Automatically Creating Partitions 6-84
Predicates 6-85
BETWEEN Predicate 6-85
Considerations for BETWEEN 6-86
Examples of BETWEEN 6-87
Comparison Predicates 6-88
Considerations for Comparison Predicates 6-89
Examples of Comparison Predicates 6-90
EXISTS Predicate 6-92
Examples of EXISTS 6-92
IN Predicate
6-94
Considerations for IN 6-95
Examples of IN 6-96
LIKE Predicate
6-97
Considerations for LIKE
6-97
Examples of LIKE 6-99
NULL Predicate
6-99
Considerations for NULL
6-100
Examples of NULL
6-100
Quantified Comparison Predicates
6-101
Considerations for ALL, ANY, SOME 6-102
Examples of ALL, ANY, SOME
6-102
Rowset Predicates 6-104