Files Created During Data File Processing

About Files Created During Data File Processing

DBLoad creates these files during or after processing the instructions in the data file:

Status File

The status file contains all the statistics collected while processing a data file. The name of the status file, is by default the name of the data processing file with the suffix .stat appended to it.

For example, if the name of your data file is newusers, then the default status file name will be newusers.stat. You can set a different name using the statusFile option in the Options section of the data file.

Error File

The error file contains detailed error messages reported while processing a given data file. If any of your transactions fail, you should consult this file for information. The name of the error file is by default the name of the data processing file with the suffix .err appended to it.

For example, if the name of your data file is newusers, then the default error file name will be newusers.err. You can set a different name using the errorFile option in the Options section of the data file.

Unprocessed Data File

The unprocessed data file contains the records that had errors during data processing. You can run the tool again after correcting the errors that prevented processing. If you have specified the option to abort processing on the first error that was encountered
(that is, errorHandle=abort), the tool writes information about the item or records that have errors into the *.upr file.

If you have set the continue-on-error option (that is, errorHandle=continue), then the tool writes only the damaged records into the unprocessed data file. In either case, if you encounter an internal error or a system error, the tool exits immediately.

The name of the unprocessed data file is the name of the data processing file with the *.upr extension added to it. For example, if the name of your data file is newusers, then the default unprocessed data file name is newusers.upr. You can set a different name using the uprFile option in the Options section of the data file.