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

Contents
HP NonStop SQL/MX Reference Manual—544517-008
xv
5. SQL/MX Utilities (continued)
5. SQL/MX Utilities (continued)
Examples of migrate 5-66
MODIFY Utility 5-68
Reuse an Existing Partition of a Range Partitioned Table 5-68
Manage Partitions of Range Partitioned Tables and Indexes 5-70
Manage Partitions of Hash Partitioned Tables and Indexes 5-76
Manage System-Clustered Tables 5-81
Considerations for MODIFY 5-83
Examples of MODIFY 5-86
mxexportddl Utility 5-88
Considerations for mxexportddl 5-91
Examples of mxexportddl 5-91
MXGNAMES Utility 5-92
Considerations for MXGNAMES 5-94
Examples of MXGNAMES 5-94
mximportddl Utility 5-99
Considerations for mximportddl 5-105
Examples of mximportddl 5-106
mxtool Utility 5-107
POPULATE INDEX Utility 5-108
Syntax Description of POPULATE INDEX 5-108
Considerations for POPULATE INDEX 5-109
Examples of POPULATE INDEX 5-110
PURGEDATA Utility 5-111
Syntax Description of PURGEDATA 5-111
Considerations for PURGEDATA 5-113
Examples of PURGEDATA 5-114
RECOVER Utility 5-115
Syntax Description of RECOVER 5-115
Considerations for RECOVER 5-116
Examples of RECOVER 5-116
VERIFY Operation 5-117
Considerations for VERIFY 5-118
Examples of VERIFY 5-119
6. SQL/MX Language Elements
Catalogs 6-3
SQL/MX Catalogs 6-3
SQL/MP Catalogs 6-3