Introduction › Example 1: Employee-record Archiving Application

Example 1: Employee-record Archiving Application

The employee-record archiving application writes selected employee records and their associated insurance coverage records from an CA IDMS/DB database to tape.

The figure below shows the I/O performed by the application.

Application Notes

The following notes describe the application:

• Each input file record contains the id of an employee record to be archived.
• Each specified employee record is retrieved from the CA IDMS/DB database and written to an output file.
• All insurance coverage records associated with an employee being archived are retrieved from the database and written to the same output file.
• Coverage records are deleted as they are archived. Employee records are deleted after all associated coverage records have been archived.
• A transaction summary report file is created.
• Invalid input records are written to a suspense file.
• A log file accumulates error messages and other information.