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

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—544517-008
5-48
Programmatic Interfaces
import sets the exit status code to 30 if the input file is readable, but is a zero-length
file. (No success and no ignorable errors).
import sets the exit status code to 40, if it attempts to import all specified rows from
the input file, encounters one or more ignorable errors, does not encounter any non-
ignorable errors, and no rows are successfully imported. (No success and ignorable
errors encountered).
import sets the exit status code to 50, if no rows are successfully imported and it
encounters a non-ignorable error or exceeds an error threshold. (No success and a
serious problem encountered).
import sets the exit status code to 70, if it detects any errors opening, reading, or
writing of input or output files, or other serious problems that prevent it from starting to
import the first row from the input file. (Serious problems that prevent the import from
starting)
import sets the exit status code to 90, if it detects any invalid option or combination of
options..
To summarize these exit status codes:
Note. In Release 2.0, under these conditions, import wrote a message to Stdout
displaying how many rows were imported, but did not write a message displaying "Import
Completed …" In Release 2.X, import will do the same.
Note. In Release 2.0, under these conditions, Import wrote both a message saying "Rows
Imported = 0" and a message saying "Import Completed Successfully" to Stdout . For Release
2.X, under these conditions, Import will write only the message "Rows Imported = 0".
Note. In Release 2.0, under these conditions,
import wrote a message to Stdout
displaying "Import Completed Successfully". For Release 2.X, under these same conditions,
import will instead write a message displaying "Import Completed with some non-fatal
errors".
Note. In Release 2.0, under these conditions,
import wrote a message to Stdout
displaying how many rows were imported, but did not write a message displaying "Import
Completed”. In Release 2.X, import will do the same.
Note. In Release 2.0, under these conditions,
import will write the same messages to
Stdout as was done by Release 2.0.
Note. In Release 2.0, under these conditions,
import will write the same messages to
Stdout as was done by Release 2.0.
0 Complete success
10 A qualified success
20 Some success, but a serious problem encountered