Introduction › Example 2: Employee-record Restore Application

Example 2: Employee-record Restore Application

The employee-record restore application restores to the database selected archived employee records and their associated coverage records.

The following figure shows the I/O performed by the employee-record restore application.

Application Notes

The following notes describe the application:

• One of the two input files contains the ids of employee records to be restored.
• The second input file contains the archived employee records and their associated coverage records.
• Based on employee ids specified in the first input file, the application restores employee and associated coverage records from the second input file.
• A transaction summary report file is created.
• A suspense file stores all invalid records from the first input file.
• No suspense file is allocated for the second input file. It is assumed that the archived employee and coverage records are formatted correctly. Note, however, that a suspense file can be allocated for each input file in an application.
• A log file accumulates error messages and other information.