Samples Overview

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:

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.


Information Builders