SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

Contents
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
xxxii
7. SQL/MX Clauses
Pseudocolumns 6-105
Considerations for Pseudocolumns 6-106
Schemas 6-107
Search Condition 6-108
Considerations for Search Condition 6-109
Order of Evaluation 6-109
Column References 6-109
Subqueries 6-109
Examples of Search Condition 6-109
Rowset Search Condition 6-110
Sequence Generators 6-110
SQL/MP Aliases 6-112
Stored Procedures 6-112
Subquery 6-112
SELECT Form of a Subquery 6-113
Using Subqueries to Provide Comparison Values 6-113
Nested Subqueries When Providing Comparison Values 6-113
Correlated Subqueries When Providing Comparison Values 6-114
Tables 6-114
Base Tables and Views 6-115
Example of a Base Table 6-115
Triggers 6-115
Views 6-115
SQL/MX Views 6-116
SQL/MP Views 6-116
Example of a View 6-116
7. SQL/MX Clauses
DEFAULT Clause 7-2
Syntax Description of DEFAULT 7-2
Considerations for DEFAULT
7-3
Default Value on a CREATE TABLE Statement
7-3
Examples of DEFAULT 7-4
PARTITION Clause
7-6
Considerations for PARTITION
7-7
Data Type Limitations
7-7
Decoupling of Clustering Key and Partitioning Key
7-8
Examples of Partitions 7-8
SAMPLE Clause
7-9