SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

Contents
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
xxvii
5. SQL/MX Utilities
import Utility 5-18
Considerations for import 5-27
Fast Loading and Transaction Considerations 5-27
DDL Locks 5-27
Recovery 5-28
Concurrency 5-28
Format File Sections for import 5-28
Format File Considerations––import 5-31
Input File Considerations––import 5-32
Transaction Considerations for import 5-36
import and Nullable Columns 5-37
Parallel Load for import 5-38
Programmatic Interfaces 5-39
File permissions 5-41
Displaying messages 5-41
Output File Consideration 5-41
Examples of import 5-43
Support for restarting import 5-49
INFO Operation 5-53
Considerations for INFO 5-53
Security Considerations 5-53
Other Considerations 5-53
Examples of INFO 5-54
mxexportddl Utility 5-55
Exporting Metadata and Statistics of SQL/MX Objects 5-55
Considerations for mxexportddl 5-58
Supported by mxexportddl
5-58
Not Supported by mxexportddl 5-58
Examples of mxexportddl 5-58
MXGNAMES Utility
5-59
Considerations for MXGNAMES
5-61
Temporary Work Files 5-61
Examples of MXGNAMES
5-61
mximportddl Utility
5-67
Importing Metadata and Statistics of SQL/MX Objects
5-67
Considerations for mximportddl
5-73
Supported by mximportddl 5-73
Not Supported by mximportddl
5-74
Examples of mximportddl 5-74