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

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—544517-008
5-57
Examples of import
•
Example 5 illustrate –LES options, which takes default value of 1000 each for –L
and –XL and auto generates the output error file and error message file and prints
the summary to the stdout at the end.
import cat.sch.Xample -I x.in -LES
NonStop SQL/MX Import Utility 2.3
(c) Copyright 2007 Hewlett-Packard Development Company, LP.
Rows Imported = 4
Import Results Summary
Import Process ID: 5380
Input File or Process Name: x.in
Start time: Thu Oct 18 15:28:30 2007
Rows to be skipped initially: 0
Rows read so far = 10
Rows skipped = 0
Elapsed time = 0:0:0.187612
Elapsed time since skipping initial rows = 0:0:0.187612
Rows Imported Successfully = 4
Rows ignored due to parsing errors = 5
Rows ignored due to execution errors = 1
Parsing Error Log File Name: PE5380
Parsing Error Messages File Name: PE5380
Execution Error Log File Name: XE5380
Execution Error Messages File Name: XE5380
Import Completed with some non-fatal errors
Support for restarting import
To support the ability to restart import after it terminates due to excessive parsing
errors, excessive execution errors, or non-ignorable errors, the following information is
appended to the results summary file before import terminates:
•
The number of rows with parsing errors.
•
The number of rows with execution errors.