File Descriptions and Tables

Topics: ADDRESS Sample COURSE Sample DEDUCT Sample EMPINFO Sample FUNDTRAN Sample PAYINFO Sample SALINFO Sample ECOURSE Sample EMPADD Sample EMPFUND Sample EMPPAY Sample SALDUCT Sample SALARY Sample DPBRANCH Sample DPINVENT Sample DPVENDOR Sample

This appendix consists of sample tables and views cited in previous chapters. It provides single-table Master and Access Files and CHECK FILE diagrams for: ADDRESS COURSE DEDUCT EMPINFO FUNDTRAN PAYINFO SALINFO In addition, it includes the following multi-table Master and Access Files and CHECK FILE diagrams: ECOURSE EMPADD EMPFUND EMPPAY SALDUCT An OCCURS segment is described in the following Master File and Access File with a CHECK FILE diagram: SALARY

This appendix also illustrates sample tables used in examples for the Direct SQL Passthru facility:

• DPBRANCH
• DPINVENT
• DPVENDOR

As discussed in Direct SQL Passthru, the in-memory SQLOUT Master Files and the FOCUS views created with SQL PREPARE vary depending on the specified SELECT statements. They are not accessible for the above tables and are not provided in this appendix.