ILE RPG Programmer's Guide


DATA DESCRIPTION SPECIFICATIONS (DDS)

Figure 171 and Figure 172 shows the data description specifications (DDS) for the physical files used by the examples. Figure 173 shows the DDS for the logical file used by the first three examples.

Figure 171. 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 172. 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 173. 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

[ Top of Page | Previous Page | Next Page | Contents | Index ]