SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

Contents
HP NonStop SQL/MX Reference Manual—523725-004
xvii
6. SQL/MX Language Elements (continued)
6. SQL/MX Language Elements (continued)
Datetime Literals 6-65
Interval Literals 6-69
Numeric Literals 6-74
MXCI Parameters 6-76
MXCI Named Parameters 6-76
MXCI Unnamed Parameters 6-76
Type Assignment for Parameters 6-76
Working With MXCI Parameters 6-77
Use of Parameter Names 6-77
Examples of MXCI Parameters 6-78
Null 6-79
Using Null Versus Default Values 6-79
Defining Columns That Allow or Prohibit Null 6-80
Partitions 6-82
SQL/MP Tables 6-82
SQL/MX Tables 6-82
Predicates 6-84
BETWEEN Predicate 6-84
Comparison Predicates 6-87
EXISTS Predicate 6-91
IN Predicate 6-93
LIKE Predicate 6-96
NULL Predicate 6-98
Quantified Comparison Predicates 6-99
Rowset Predicates 6-103
Schemas 6-104
Search Condition 6-105
Considerations for Search Condition 6-106
Examples of Search Condition 6-106
Rowset Search Condition 6-107
SQL/MP Aliases 6-108
Stored Procedures 6-108
Subquery 6-108
Tables 6-110
Triggers 6-111
Views 6-111
SQL/MX Views 6-112
SQL/MP Views 6-112