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

Contents
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
xvi
5. SQL/MX Utilities
Considerations for DUP 5-12
Examples of DUP 5-14
FASTCOPY Utility 5-15
FASTCOPY TABLE Command 5-18
FASTCOPY INDEX Command 5-18
Considerations for FASTCOPY 5-19
Examples of FASTCOPY 5-23
FIXRCB Operation 5-24
Error Conditions 5-24
Example of FIXRCB Operation 5-24
FIXUP Operation 5-25
Considerations for FIXUP Operation 5-28
Examples of FIXUP Operation 5-28
GIVE SCHEMA Operation 5-29
Considerations for GIVE SCHEMA 5-29
Examples of GIVE SCHEMA 5-30
GOAWAY Operation 5-31
Syntax Description of GOAWAY 5-31
Considerations for GOAWAY 5-33
Examples of GOAWAY 5-33
import Utility 5-36
Considerations for import 5-44
Programmatic Interfaces 5-56
Output File Consideration 5-58
Examples of import 5-60
INFO Operation 5-70
Considerations for INFO
5-70
Examples of INFO 5-71
MODIFY Utility 5-77
Reuse an Existing Partition of a Range Partitioned Table
5-77
Manage Partitions of Range Partitioned Tables and Indexes
5-79
Manage Partitions of Hash Partitioned Tables and Indexes 5-85
Manage System-Clustered Tables
5-90
Renaming Guardian location of partitions of tables or indexes
5-92
Considerations for MODIFY
5-93
Examples of MODIFY
5-99
mxexportddl Utility 5-101
Considerations for mxexportddl
5-104
Examples of mxexportddl 5-104