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

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—523725-004
5-25
Considerations for import
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 file format 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).
FourDigitYear=four_year
Y or N. Default is Y; 4 digits (for example,
12/25/1997).
You have the option of specifying a two-digit
year date or timestamp value. If you specify a
two-digit and the year value is less than 30,
import assumes the first two digits of the year to
be 20. If the year value is greater than or equal
to 30, import assumes the first two digits of the
year to be 19.
DecimalSymbol=decimal
One character. Default is a decimal point (.).
You can specify some character, other than the
default decimal point (.) character, to be used
whenever the input file has a time value that
includes a fractional part of a second. This
DecimalSymbol character is used only with a
fractional second. It is not recognized in general
numeric input, such as 12345.67, or in floating
point numbers. For general numerics and
floating point numbers, you must use the
decimal point.