SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

Contents
HP NonStop SQL/MX Reference Manual—640322-001
xix
6. SQL/MX Language Elements (continued)
6. SQL/MX Language Elements (continued)
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
Examples of Search Condition 6-107
Rowset Search Condition 6-108
SQL/MP Aliases 6-109
Stored Procedures 6-109
Subquery 6-109
Tables 6-111
Triggers 6-112
Views 6-112
SQL/MX Views 6-113
SQL/MP Views 6-113
7. SQL/MX Clauses
DEFAULT Clause 7-2
Syntax Description of DEFAULT 7-2
Considerations for DEFAULT 7-3
Examples of DEFAULT 7-4
PARTITION Clause 7-5
Considerations for PARTITION 7-6
Examples of Partitions 7-7
SAMPLE Clause 7-8
Considerations for SAMPLE 7-10
Examples of SAMPLE 7-11
SEQUENCE BY Clause 7-18
Considerations for SEQUENCE BY 7-18