SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

Contents
HP NonStop SQL/MX Reference Manual—544517-008
xviii
6. SQL/MX Language Elements (continued)
6. SQL/MX Language Elements (continued)
IN Predicate 6-91
LIKE Predicate 6-94
NULL Predicate 6-96
Quantified Comparison Predicates 6-98
Rowset Predicates 6-101
Schemas 6-102
Search Condition 6-103
Considerations for Search Condition 6-104
Examples of Search Condition 6-104
Rowset Search Condition 6-105
SQL/MP Aliases 6-106
Stored Procedures 6-106
Subquery 6-106
Tables 6-108
Triggers 6-109
Views 6-109
SQL/MX Views 6-110
SQL/MP Views 6-110
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
Examples of SEQUENCE BY 7-20
STORE BY Clause 7-22
Considerations for STORE BY 7-23
Effect of Storage Order on Partitioning 7-24
TRANSPOSE Clause 7-25
Considerations for TRANSPOSE 7-27