Previous Topic

Next Topic

Book Contents

Book Index

Example

EXECUTE block INPUT processes the sequential file named CTB.PROD.EMPREP. The file is read line by line. Employee details are extracted from each line that contains the symbol "#" in column 15.

Figure 263 ON FILE Statement Example

     LIBRARY : CTB.PROD.RULES                                RULE : RULEMP

 COMMAND ===>                                                    SCROLL===> CRSR

 +-----------------------------------------------------------------------------+

  ===========================================================================

  EXECUTE INPUT    UPON                                                   C  

  ON FILE       FILENAME CTBT.PROD.EMPRE                                     

     MODE PG    LINECT 0060    DATASTAMP                                     

  WHEN LINE 001     - 060     COL 015     - 015              STOP    AND/OR  

       STRING = #                                                            

    DO EXTRACT  = NAME                                                       

                  LEVEL 0 LINE +000 COL -002 - +013 PROCESS          TYP     

    DO EXTRACT  = SICK                                                       

                  LEVEL 0 LINE +000 COL +087 - +088 PROCESS          TYP     

    DO EXTRACT  = VAC                                                        

                  LEVEL 0 LINE +000 COL +093 - +094 PROCESS          TYP     

    DO BLOCK    = CHECK    ARG NAME,SICK,VAC                              C  

    DO                                                                       

  WHEN LINE         -         COL         -                  STOP    AND/OR  

       STRING =                                                              

    DO                                                                       

  ===========================================================================

  EXECUTE FIN      UPON                                                   C  

  ON DATA                                                                    

 PLEASE FILL IN RULE DEFINITION.                                        16.00.22

Parent Topic

ON FILE: Data Selection Statement