Sample Programs—Database Access › About This Appendix

About This Appendix

This appendix contains three sample CA Culprit programs that access data in a non-SQL defined database using either database records or a logical record:

• The first program navigates the DEPARTMENT, EMPLOYEE, and OFFICE records of the database and processes the data depending upon the value of PATH-ID in the input buffer.
• The second program navigates a bill-of-materials set relationship within the database and executes DB-EXIT calls within the procedure logic of the report to retrieve database records.
• The third program specifies a logical record on the PATH parameter. CA Culprit processes logical records according to the selection criteria specified on the WHERE clause in the PATH parameter.

Appendix K: Employee Database Subschema contains the structure of the Employee database and the definitions of the fields that are used as input to these programs. Each program is discussed separately below.