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

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—540440-003
5-27
Considerations for import
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 two
digits 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.
NormalizeDate=normalize
Y or N. Default is N; no datetime normalization.
[COLUMN FORMAT]
col=field_name,skip
[,NullDefault_flag]
The source field name and whether to skip the
field in the source data file.
If data is to be stored in the target table,
field_name must be the name of the target
column.
skip is Y or N. Default is N: do not skip.
NullDefault_flag is Y or N. Default is N: no
null or default flag preceding the data.
If the flag in the input field is N, null is inserted
into the column.
If the flag is D, the default value is inserted into
the column. Otherwise, the input field value is
inserted.
Each field in the source data file has a
corresponding col entry.
[DELIMITED FORMAT]
FieldDelimiter=field_delim
One or more characters that separate fields in a
row or record. Default is a comma (,).
RowDelimiter=row_delim
One or more characters that separate rows.
Default is the new line character (\n).
Qualifier=qualifier
One character that can enclose a field in a row
or record. Default is a double quote (").
[FIXED WIDTH FORMAT]