SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—523725-004
5-31
Considerations for import
•
If the interval value to be imported is INTERVAL '03-04' YEAR TO MONTH,
specify the field without the keywords in the input data file as:
03-04
Datetime Normalization
NonStop SQL/MX supports the three standard ANSI SQL:1999 datetime formats,
which can be loaded without normalization.
Date formats other than ANSI SQL:1999 formats must be normalized to substitute the
appropriate year, month, and day delimiters; zero-pad missing digits; and transpose
year, month, and day field order. Time formats other than ANSI SQL:1999 formats
must be normalized to substitute the appropriate hour, minute, and second delimiters,
and zero-pad missing digits. See [DATE FORMAT] on page 5-25.
Figure 5-1 illustrates import processing.
Transaction Considerations for import
import might automatically turn auditing off for all partitions on an empty table without
indexes. Auditing is turned back on after the import operation completes or if it fails for
any reason. This allows import to take advantage of fast loading techniques and to
avoid TMF transaction issues. If auditing is turned off for the table, this invalidates
Figure 5-1. SQL/MX import Utility
Import
Executor
Insert rows into T1 after
retrieving row information
from the input file
Select * from flat file
Buffer of transformed data
Transform
Formatted data with
DateTime transforms
Flat file
Raw data
Format File
ETL Extracted Data
Table
Insert
VST006.vsd