SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

SQL/MX Utilities
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
5-54
Considerations for import
[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]
RecordLength=record_length
A decimal ASCII number that specifies the
physical record length (in characters, not bytes)
of each input row. The length must include the
row delimiter, if used. You must specify
record_length for fixed width format.
The value specified for record_length must
be greater than or equal to (start + length -
1) / (number of bytes per character) for all
subsequent col= lines in this section of the
format file.
All input records must be the same length,
exactly record_length characters long.
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.