SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—544517-008
5-33
import Utility
-W file-type
specifies the input file type. The possible values for file-type are DELIM and
FIXED. If you do not specify this parameter, import assumes the default DELIM
file type (a delimited input file). If you do not specify this parameter and there is no
format file, import assumes the default delimiters for a delimited input file.
If you use the -W option, it must follow the -IP option on the command line.
-XE exec-error-filename
is an option that specifies the pathname exec-error-filename of an OSS
output file to which import logs data rows that have execution errors. After the
rows in the error file are edited to resolve the execution errors, the resultant error
file can be used as an input file by a subsequent import execution.
The name of the error file must be specified in the OSS format, for example
/usr/jdoe/errfile, and must not be the same file as the one specified with the
-E error-filename option if the -E option is also specified. This output file is
created by the import utility as a non-audited, OSS unstructured file (or a
Guardian file of type 180 if the error log file is specified to be under /G). If the file
already exists, import terminates with an error message. If the -XE option is not
specified, rows with execution errors shall not be logged. If the -XE option is
specified but the -XL option is not, import terminates with an error message.
Note. In Release 2.0, if you specify a parsing error file using the -E option and if the file
currently exists,
import purges the contents of the file before logging the first parsing
error into the file. The handling of the parsing error file is changed so that import
terminates with an error message if the specified parsing error file already exists.
Note.
In Release 2.0, if you specify the -E option but not the -L option, import does
not report an error, it creates the file specified via the -E option as a zero-length file. It
does not write any data rows to the file since the default action when no -L option is
specified is to not accept (and hence not log) any rows with parsing errors. The handling of
the -E option is changed so that import terminates with an error message if the -E
option is specified without the -L option also being specified.
Note.
Although the -XL option allows a maximum of 2,147,483,646 errors to be ignored,
the execution error log file grows to consume a large amount of disk space long before
that many errors were actually encountered. Even if the average input row size were only
50 bytes, the error log file grows to the current OSS file size limit of 2,090,950,656 bytes
when the number of encountered errors is only 41,819,013. Therefore, it is important to
remember that if the -XE option is used, the potential size (and disk space consumption)
of the error log file must be considered when choosing the -XL value.