SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

Contents
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
xx
7. SQL/MX Clauses
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
Examples of SEQUENCE BY 7-21
STORE BY Clause
7-23
Considerations for STORE BY
7-24
Effect of Storage Order on Partitioning
7-25
TRANSPOSE Clause 7-26
Considerations for TRANSPOSE 7-28
Examples of TRANSPOSE
7-30
8. SQL/MX File Attributes
ALLOCATE/DEALLOCATE 8-2
Considerations for ALLOCATE
8-2
AUDITCOMPRESS
8-3
Considerations for AUDITCOMPRESS
8-3
BLOCKSIZE
8-4
CLEARONPURGE 8-5
Considerations for CLEARONPURGE
8-5