August 10th, 2009

Host Programs, FETCH (Part 2 of 2)

Posted by admin in S. Host Programs

Here is an example of the processing, written in COBOL (which is very similar to English in context):

 WORKING-STORAGE SECTION.
     EXEC SQL
          DECLARE VENDOR_CSR CURSOR FOR
           SELECT VENDOR_NAME, STATUS
             FROM VENDOR_TBL
            WHERE COUNTRY = 'USA'
     END-EXEC
 PROCEDURE DIVISION.
     PERFORM 0000-HOUSEKEEPING.
     PERFORM 1000-PROCESS.
     PERFORM 9000-TERMINATE.
 0000-HOUSEKEEPING.
     EXEC SQL
          OPEN VENDOR_CSR
     END-EXEC.
 1000-PROCESS.
     PERFORM 1100-GET-DATA
       UNTIL SQLCODE = +100.
 1100-GET-DATA.
     EXEC SQL
          FETCH VENDOR_CSR
           INTO :VEN-NAME,
                :VEN-STATUS:VEN-STATUS-IND
     END-EXEC.
     IF SQLCODE NOT = +100
        PERFORM 1110-PROCESS-DATA.
 1110-PROCESS-DATA.
********************************
*    PROCESS THE DATA HERE     *
********************************
 9000-TERMINATE.
     EXEC SQL
          CLOSE VENDOR_CSR
     END-EXEC.
     STOP RUN.

Comments are closed.

Sorry, the comment form is closed at this time.