SQL/MX 2.x Reference Manual (H06.04+)

Contents
HP NonStop SQL/MX Reference Manual—540440-003
xvii
6. SQL/MX Language Elements (continued)
6. SQL/MX Language Elements (continued)
Datetime Literals 6-64
Interval Literals 6-67
Numeric Literals 6-71
MXCI Parameters 6-73
MXCI Named Parameters 6-73
MXCI Unnamed Parameters 6-73
Type Assignment for Parameters 6-73
Working With MXCI Parameters 6-74
Use of Parameter Names 6-74
Examples of MXCI Parameters 6-75
Null 6-76
Using Null Versus Default Values 6-76
Defining Columns That Allow or Prohibit Null 6-77
Partitions 6-79
SQL/MP Tables 6-79
SQL/MX Tables 6-79
Predicates 6-81
BETWEEN Predicate 6-81
Comparison Predicates 6-84
EXISTS Predicate 6-88
IN Predicate 6-90
LIKE Predicate 6-93
NULL Predicate 6-95
Quantified Comparison Predicates 6-97
Rowset Predicates 6-100
Schemas 6-101
Search Condition 6-102
Considerations for Search Condition 6-103
Examples of Search Condition 6-103
Rowset Search Condition 6-104
SQL/MP Aliases 6-105
Stored Procedures 6-105
Subquery 6-105
Tables 6-107
Triggers 6-108
Views 6-108
SQL/MX Views 6-109
SQL/MP Views 6-109