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

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—523725-004
5-26
Considerations for import
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 character that separates 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]
RecordLength=record_length
The physical record length of the input file. The
length must include the new line row delimiter, if
used. You must specify record_length for
fixed width format.
NullValue=null_char
A character denoting null. Default is space. If an
input field consists of all null_char, null is
stored in the target column.
col=column_name,start,length
[,varcharPrefix_length]
The target table column name and the start
position and length of the input field in the
source data file.
varcharPrefix_length is the number of
bytes in the length prefix for an input value
whose target is a VARCHAR column. Default is
0. If the null or default flag
NullDefault_flag is defined, it precedes
the length prefix in the input field.
Each field in the source data file has a
corresponding col entry.