Loading Data into the Target Database

To load database data from an ASCII file created by the Unload utility or formatted as explained in Understanding the Data Format:

On the DP4 System Main menu, select the Run Program option and enter:

Enter the name of the file, including its .TXT extension, that holds the data. The data is loaded into the database specified at the beginning of the file. The table being updated and a record count is displayed as the data is loaded. Unless you specify the -error option described below it does not matter if some fields containined in the file are not in the database table, or fields on the database are missing in the file. LOAD is very useful for transferring data to databases with slightly different structures.

Modifying the Load Facility

To override the database specified in the data file, use the -DB command tail, for example:

To suppress screen output while the data is loading, append the -QUIET command tail:

Normally the Load facility ignores fields that are in the file but missing from the target database. To force Load to regard this as an error and abort its operation, add the -ERROR command tail: