CUSMSTL2: DDS for a Logical File

Figure 209. DDS for logical file CUSMSTL2

     A*****************************************************************
     A*     FILE NAME:  CUSMSTL2                                      *
     A*  RELATED PGMS:  SCHZIP                                        *
     A* RELATED FILES:  CUSMST   (PHYSICAL FILE)                      *
     A*   DESCRIPTION:  THIS IS LOGICAL FILE CUSMSTL2.                *
     A*                 IT CONTAINS ONE RECORD FORMAT CALLED CMLREC2. *
     A*                 LOGICAL VIEW OF CUSTOMER MASTER FILE (CUSMST) *
     A*                 BY CUSTOMER ZIP CODE (ZIP)                    *
     A*****************************************************************
     A          R CMLREC2                   PFILE(CUSMST)
     A            ZIP
     A            NAME
     A            ARBAL
     A          K ZIP

The DDS for the database file used by this program describe one record format: CMLREC2. The logical file CUSMSTL2 keyed by zip code is based on the physical file CUSMST, as indicated by the PFILE keyword. The record format created by the logical file will include only those fields specified in the logical file DDS. All other fields will be excluded.

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