The LOAD DATA statement tells SQL*Loader that this is the beginning of a new data load.

The INFILE clause specifies the name of a datafile containing data that you want to load. You can specify multiple files to load. The STR attribute with INFILE clause specifies a new end-of-line character. For "ASCII Bulk-Export" from Pro2 it is '^^^' string.

The APPEND clause is one of the options you can use when loading data into a table that is not empty. I use it here since I load two files at once.

The TERMINATEDBY clause is one of the delimiters it is possible to specify for a field. In this example it is tab (\t).

The TRAILING NULLCOLS clause tells SQL*Loader to treat any relatively positioned columns that are not present in the record as null columns. I'm using it here since I'm generating the PROGRESS_RECID field while it's not in the dump file. To generate a field value, I use the next value of the sequence ACCOUNT_SEQ.

After preparing the control file, you simply run the following command to start the data load:

The LOAD DATA statement tells SQL*Loader that this is the beginning of a new data load.

The INFILE clause specifies the name of a datafile containing data that you want to load. You can specify multiple files to load. The STR attribute with INFILE clause specifies a new end-of-line character. For "ASCII Bulk-Export" from Pro2 it is '^^^' string.

The APPEND clause is one of the options you can use when loading data into a table that is not empty. I use it here since I load two files at once.

The TERMINATEDBY clause is one of the delimiters it is possible to specify for a field. In this example it is tab (\t).

The TRAILING NULLCOLS clause tells SQL*Loader to treat any relatively positioned columns that are not present in the record as null columns. I'm using it here since I'm generating the PROGRESS_RECID field while it's not in the dump file. To generate a field value, I use the next value of the sequence ACCOUNT_SEQ.

After preparing the control file, you simply run the following command to start the data load: