DATA DESCRIPTION SPECIFICATIONS (DDS)

Figure 1 and Figure 2 shows the data description specifications (DDS) for the physical files used by the examples. Figure 3 shows the DDS for the logical file used by the first three examples.

Figure 1. DDS for database file EMPMST (physical file)
     A*****************************************************************
     A* DESCRIPTION:  This is the DDS for the physical file EMPMST.   *
     A*               It contains one record format called EMPREC.    *
     A*               This file contains one record for each employee *
     A*               of the company.                                 *
     A*****************************************************************
     A*
     A          R EMPREC
     A            ENUM           5  0       TEXT('EMPLOYEE NUMBER')
     A            ENAME         20          TEXT('EMPLOYEE NAME')
     A            ETYPE          1          TEXT('EMPLOYEE TYPE')
     A            EDEPT          3  0       TEXT('EMPLOYEE DEPARTMENT')
     A            ENHRS          3  1       TEXT('EMPLOYEE NORMAL WEEK HOURS')
     A          K ENUM
Figure 2. DDS for database file TRWEEK (physical file)
     A*****************************************************************
     A* DESCRIPTION:  This is the DDS for the physical file TRWEEK.   *
     A*               It contains one record format called RCWEEK.    *
     A*               This file contains all weekly entries made to   *
     A*               the time reporting system.                      *
     A*****************************************************************
     A*
     A          R RCWEEK
     A            ENUM           5  0       TEXT('EMPLOYEE NUMBER')
     A            WEEKNO         2  0       TEXT('WEEK NUMBER OF CURRENT YEAR')
     A            EHWRK          4  1       TEXT('EMPLOYEE HOURS WORKED')
     A          K ENUM
     A          K WEEKNO
Figure 3. DDS for database file EMPL1 (logical file)
     A*****************************************************************
     A* RELATED FILES:  EMPMST    (Physical File)                     *
     A*                 TRWEEK    (Physical File)                     *
     A*   DESCRIPTION:  This is the DDS for the logical file EMPL1.   *
     A*                 It contains two record formats called         *
     A*                 EMPREC and RCWEEK.                            *
     A*****************************************************************
     A          R EMPREC                    PFILE(EMPMST)
     A          K ENUM
     A*
     A          R RCWEEK                    PFILE(TRWEEK)
     A          K ENUM
     A          K WEEKNO