SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

Contents
HP NonStop SQL/MX Reference Manual—640322-001
xvi
5. SQL/MX Utilities (continued)
5. SQL/MX Utilities (continued)
Examples of INFO 5-66
migrate Utility 5-67
Considerations for migrate 5-69
Examples of migrate 5-70
MODIFY Utility 5-72
Reuse an Existing Partition of a Range Partitioned Table 5-72
Manage Partitions of Range Partitioned Tables and Indexes 5-74
Manage Partitions of Hash Partitioned Tables and Indexes 5-80
Manage System-Clustered Tables 5-85
Considerations for MODIFY 5-87
Examples of MODIFY 5-90
mxexportddl Utility 5-92
Considerations for mxexportddl 5-95
Examples of mxexportddl 5-95
MXGNAMES Utility 5-96
Considerations for MXGNAMES 5-98
Examples of MXGNAMES 5-98
mximportddl Utility 5-103
Considerations for mximportddl 5-109
Examples of mximportddl 5-110
mxtool Utility 5-111
POPULATE INDEX Utility 5-112
Syntax Description of POPULATE INDEX 5-112
Considerations for POPULATE INDEX 5-113
Examples of POPULATE INDEX 5-114
PURGEDATA Utility 5-115
Syntax Description of PURGEDATA 5-115
Considerations for PURGEDATA 5-117
Examples of PURGEDATA 5-118
RECOVER Utility 5-119
Syntax Description of RECOVER 5-119
Considerations for RECOVER 5-120
Examples of RECOVER 5-120
UPGRADE Utility 5-121
Considerations for UPGRADE 5-121
Example of UPGRADE 5-123
VERIFY Operation 5-124
Considerations for VERIFY 5-125