Unloading Data from the Source Database

To unload database data into an ASCII file:

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

2. Enter the database name. The Unload menu appears. There are two options:

   • Option 1 - All Tables unloads data from all the tables on the database into an ASCII file

   • Option 2 - Selected Tables unloads data from your choice of database tables into an ASCII file

3. Select the option you want. If you select option 2 - Selected Tables, you make your choice from a list of the tables which appears. The data is exported to an ASCII file named <DATABASE_NAME>.TXT

Modifying the Unload Facility

To export the data from the tables specified in a file, run the Unload utility like this:

UNLOAD -DB <database_name> -TABLE @<file_name>.lst

where <file_name> lists the tables, separated by spaces, to be unloaded.

To suppress screen output while data is unloading, use the -QUIET command tail, as in:

UNLOAD -QUIET