Sample Programs—Table Access and Creation › Overview

Overview

This appendix contains four sample CA Culprit programs that access or create non-SQL defined data tables:

• The first program obtains input from a sequential file that contains information about company employees. The output creates two tables and replaces the information contained in a third.
• The second program navigates the database structure shown in Employee Database Subschema. The output from the CA Culprit run produces two reports; one report adds new information to a previously defined table and the second report creates a new table.
• The third program uses a table as input to the CA Culprit run. One report prints the contents of the table and a second report creates another table.
• The fourth program consolidates three tables and prints the contents of the tables.

Each CA Culprit program is discussed separately below.