PROD Data Source

In this section:

The PROD data source lists products sold by a dairy company. It consists of one segment, PRODUCT. The field PROD_CODE is indexed.


Top of page

x
PROD Master File
FILE=KPROD, SUFFIX=FOC
 SEGMENT=PRODUCT, SEGTYPE=S1,
  FIELDNAME=PROD_CODE, ALIAS=PCODE, FORMAT=A3,    FIELDTYPE=I, $
  FIELDNAME=PROD_NAME, ALIAS=ITEM,  FORMAT=A15,   $
  FIELDNAME=PACKAGE,   ALIAS=SIZE,  FORMAT=A12,   $
  FIELDNAME=UNIT_COST, ALIAS=COST,  FORMAT=D5.2M, $

Top of page

x
PROD Structure Diagram
SECTION 01
             STRUCTURE OF FOCUS   FILE PROD   ON 05/15/03 AT 14.57.38
        PRODUCT
01      S1
**************
*PROD_CODE   **I
*PROD_NAME   **
*PACKAGE     **
*UNIT_COST   **
*            **
***************
 **************

Information Builders