SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

Contents
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
xx
7. SQL/MX Clauses
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
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-6
Considerations for PARTITION 7-7
Examples of Partitions
7-8
SAMPLE Clause
7-9
Considerations for SAMPLE
7-11
Examples of SAMPLE
7-12
SEQUENCE BY Clause 7-19
Considerations for SEQUENCE BY
7-19