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

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—544517-008
5-60
Examples of import
A sample results summary file is as follows:
Input File or Process Name: myinput_for_MYTABLE
Start time: Mon May 2 15:33:13 CDT 2005
Rows to be skipped initially: 201986
Rows read so far = 2579352
Rows skipped = 359827
Elapsed time = 01:46:37.18
Elapsed time since skipping initial rows = 01:13:54:30
Rows Imported Successfully = 2570000
Rows ignored due to parsing errors = 4
Rows ignored due to execution errors = 2
Parsing Error Log File Name: MYTABLE_perrs
Parsing Error Messages File Name: MYTABLE_perrs
Execution Error Log File Name: MYTABLE_xerrs
Execution Error Messages File Name: MYTABLE_xerrs
You should specify -F 2570003 if you want to restart IMPORT
and have it start where this import operation left off.
Import Completed with some non-fatal errors
Import Completed Successfully
Note. The lines that can be repeated are shown in bold in the following sample summary file.
WARNING. The last two rows of the error output file, MYTABLE_perrs, are found on or after
row number 2570003 in the input file.
WARNING. The last 1 rows of the error output file, MYTABLE_xerrs, are found on or after row
number 2570003 in the input file.
Note. A line displaying one of the following will be appended to the end of the results
summary file whenever import reaches the end of the input data without encountering any
non-ignorable error conditions. For this sample results file, neither message would be
appended as this example is for a case where import had to roll back to the last transaction,
and must have encountered some non-ignorable error condition.