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

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—540440-003
5-26
Considerations for import
If the import operation fails unexpectedly, the RECOVER utility does not reenable
triggers that were disabled before running import. You must reenable them. For
expected errors, error handling ensures that triggers are reenabled.
No restart facility is available to handle partially copied data.
Concurrency
If you are importing into an empty table or if the target table does not have index or
referential integrity constraints, import uses fast-loading techniques. Concurrent
import operations are not allowed. Concurrent DML, DDL, and utility operations are
also not allowed.
If import is not using fast-loading techniques, all DML operations (SELECT, UPDATE,
DELETE, INSERT) can be performed concurrently. If too many locks are on the
partition, DP2 escalates to a table lock, which prevents concurrent DML operations.
Utilities that read only metadata (EXPORTDDL, INFO, MXGNAMES, SHOWDDL,
SHOWLABEL, VERIFY) can be performed concurrently.
Parallel imports on the same table are allowed. DDL operations are not recommended.
Format File Sections for import
A format file is optional and, if used, consists of up to four sections. You specify the
format file by using the option -U format-filename. A sample format file is
provided in the import example (see Format File Describing the Data). The sections
you can include are:
•
[DATE FORMAT]
•
[COLUMN FORMAT]
•
[DELIMITED FORMAT]
•
[FIXED WIDTH FORMAT]
The format file structure and field options that are available are:
Format File Structure Format File Field Options
[DATE FORMAT]
DateOrder=order
Order of the date fields:
MDY: month/day/year
DYM: day/year/month
YMD: year/month/day
YDM: year/day/month
DMY: day/month/year
MYD: month/year/day
Default is MDY.
DateDelimiter=date_delim
Delimiter for the date. Default is a slash (for
example, mm/dd/yyyy).
TimeDelimiter=time_delim
Delimiter for the time. Default is a colon (for
example, hh:mm:ss).