SQL/MX 2.x Installation and Management Guide (H06.04+)

Reorganizing SQL/MX Tables and Maintaining Data
HP NonStop SQL/MX Installation and Management Guide—540436-001
10-24
Other import Features
Format File Considerations for import
For more information about format file structures and field options for import, see the
SQL/MX Reference Manual.
Format File for a DELIM Input File
If the input file type is DELIM and you want to use a format file, you must include the
[COLUMN FORMAT] section. The other sections are optional.
Format File for a FIXED Input File
If the input file type is FIXED, you must specify a format file that includes the
[COLUMN FORMAT] and [FIXED WIDTH FORMAT] sections. The columns listed in
the [COLUMN FORMAT] section must match the columns listed in the [FIXED WIDTH
FORMAT] section. The other sections are optional.
Input File Considerations for import
Fixed Input File
In a fixed input file, specified by using the -W FIXED option, different columns can
have different lengths. But for each column, all rows must be the same length. You
should pad column values that are shorter than the column width with spaces or
NullValue characters to ensure that every row has exactly the same number of bytes
for a given column.
Delimited Input File
A delimited input file, specified by using the -W DELIM option or by default, uses field
and row delimiters and field qualifiers if needed. If you specify a format file, import
uses the delimiters in the file unless you also specify delimeters on the import
command line, in which case the command line specifications are used.
If you do not specify a format file, import uses the default delimiters described in the
SQL/MX Reference Manual.
For information about other input file considerations, including using a field qualifier,
field delimeter, row delimeter, or record delimeter, see the SQL/MX Reference Manual.
Other import Features
import automatically turns auditing off for all partitions of an empty table without
indexes. Auditing is turned back on after the import operation completes or if it fails
for any reason. This enables import to take advantage of fast loading techniques and
to avoid TMF transaction issues. Turning off auditing for a table invalidates online
dumps. After the import operation completes, you must take a new TMF online dump
for all partitions on the table. For more information, see Running import on Empty
Tables on page 10-25.