SQL/MX 2.x Reference Manual (H06.04+)

Contents
HP NonStop SQL/MX Reference Manual—540440-003
xviii
7. SQL/MX Clauses
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
Examples of TRANSPOSE 7-29
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
EXTENT 8-6
Considerations for EXTENT 8-6
MAXEXTENTS 8-7
Considerations for MAXEXTENTS 8-7
9. SQL/MX Functions and Expressions
Categories 9-1
Aggregate (Set) Functions 9-1
Character String Functions 9-2
Datetime Functions 9-4