Quelle cob001.cob Sprache: Cobol

       IDENTIFICATION DIVISION.
       PROGRAM-ID.  COB001.
       ENVIRONMENT DIVISION.
       CONFIGURATION SECTION.
       SOURCE-COMPUTER.  xyz.
       OBJECT-COMPUTER.  xyz.
       DATA DIVISION.
       WORKING-STORAGE SECTION.

      * EMBEDDED COBOL (file "COB001.PCO")

      **************************************************************
      *
      *                  COMMENT SECTION
      *
      * DATE  1988/06/26 EMBEDDED COBOL LANGUAGE
      * NIST SQL VALIDATION TEST SUITE V6.0
      *  DISCLAIMER:
      *  This program was written by employees of NIST to test SQL
      *  implementations for conformance to the SQL standards.
      *  NIST assumes no responsibility for any party's use of
      *  this program.
      *
      *  COB001.PCO
      *  WRITTEN BY: S Hurwitz
      *
      *    This routine tests a variety of COBOL host identifiers that
      *  are allowed in the embedded language of SQL.
      *
      *    01  <COBOL host identifier> <type specification>
      *    77  <COBOL host identifier> <type specification>
      *
      *  REFERENCES
      *         AMERICAN NATIONAL STANDARD database language - SQL
      *                   X3.135-1989
      *
      *         Section ANNEX C.  <embedded SQL COBOL program>
      **************************************************************

           EXEC SQL BEGIN DECLARE SECTION END-EXEC.
       01  PNUMabcdefghijkABCDEFGHIJK-001       pic  x(3).
       01  PNUMabcdefghijkABCDEFGHIJK-002       pic  x(3).
       01  EMPNAME-123456-123456-abc            pic  x(20).
       01  123456-EMPNUM     pic  x(3).
       01  CITY1---city1     pic  x(15).
       01  000CITY           pic  x(15).
       01  uid PIC X(18).
       01  uidx PIC X(18).
           EXEC SQL END DECLARE SECTION END-EXEC.
       01  SQLCODE PIC S9(9) COMP.
       01  errcnt PIC S9(4) DISPLAY SIGN LEADING SEPARATE.

       01  errflg     pic  99.
       01  pnum001    pic  x(3).

      * date_time declaration *
       01  TO-DAY PIC 9(6).
       01  THE-TIME PIC 9(8).

       PROCEDURE DIVISION.
       P0.

      *initalize
           move 0 to errflg.
           move spaces to pnum001.

      *log into database
           move "HU" to uid.
           CALL "AUTHID" USING uid.
           MOVE "not logged in, not" TO uidx
           EXEC SQL SELECT
                 USER INTO :uidx FROM HU.ECCO END-EXEC
           if (uid NOT = uidx) then
             DISPLAY "ERROR: User " uid " expected."
             DISPLAY "User " uidx " connected."
             DISPLAY " "
             STOP RUN
           END-IF

           MOVE 0 TO errcnt
           DISPLAY
           "SQL Test Suite, V6.0, Embedded COBOL, cob001.pco"
           DISPLAY " "
           DISPLAY
           "59-byte ID"
           DISPLAY "TEd Version #"
           DISPLAY " "
      * date_time print *
           ACCEPT TO-DAY FROM DATE
           ACCEPT THE-TIME FROM TIME
           DISPLAY "Date run YYMMDD: " TO-DAY " at hhmmssff: " THE-TIME

      ******************** BEGIN TEST0185 ********************

           display " TEST0185 ".
           display " Testing COBOL host identifiers ".
           display " reference X3. 135-1986 section ANNEX C ".

           display "- - - - - - - - - - - - - - - - - - - - - - -".
           display " ".

           EXEC SQL SELECT EMPNUM,EMPNAME
                    INTO :123456-EMPNUM,
                         :EMPNAME-123456-123456-abc
                    FROM STAFF
                    WHERE CITY='Akron'
                    END-EXEC.

           display " 123456-EMPNUM=" 123456-EMPNUM
              " EMPNAME-123456-123456-abc= " EMPNAME-123456-123456-abc.
           display "The answer should be 123456-EMPNUM=E5 and "
                  " EMPNAME-123456-123456-abc= Ed".
           if 123456-EMPNUM not = "E5" add 1 to errflg.
           if EMPNAME-123456-123456-abc not = "Ed" add 1 to errflg.

           display "- - - - - - - - - - - - - - - - - - - - - -".

           EXEC SQL SELECT PNUM,CITY
                   INTO :PNUMabcdefghijkABCDEFGHIJK-001,
                        :CITY1---city1
                   FROM PROJ
                   WHERE PNAME = 'CALM'
           END-EXEC.
           display " PNUMabcdefghijkABCKEFGHIJK-001="
                         PNUMabcdefghijkABCDEFGHIJK-001
                  " CITY1---city1= " CITY1---city1.
           display "The answer should be "
                    "PNUMabcdefghijkABCDEFGHIJK-001=P2 and "
                    "CITY1---city1= Vienna".
           if PNUMabcdefghijkABCDEFGHIJK-001 not = "P2"
                     add 1 to errflg.
           if CITY1---city1 not = "Vienna" add 1 to errflg.
           move PNUMabcdefghijkABCDEFGHIJK-001 to pnum001.

           display "- - - - - - - - - - - - - - - - - - - - - -".

           EXEC SQL SELECT PNUM,CITY
                  INTO :PNUMabcdefghijkABCDEFGHIJK-002,
                       :000CITY
                  FROM PROJ
                  WHERE PNAME = 'PAYR'
           END-EXEC.

           display " PNUMabcdefghijkABCDEFGHIJK-002="
                       PNUMabcdefghijkABCDEFGHIJK-002
                   " 000CITY = " 000CITY.
           display "The answer should be"
                   " PNUMabcdefghijkABCDEFGHIJK-002= P6 and "
                   " 000CITY= Deale".

           if PNUMabcdefghijkABCDEFGHIJK-002 not = "P6" add 1 to errflg.
           if 000CITY not = "Deale" add 1 to errflg.
           if pnum001 = PNUMabcdefghijkABCDEFGHIJK-002
                        add 1 to errflg.
           if pnum001 not = PNUMabcdefghijkABCDEFGHIJK-001
                        add 1 to errflg.

           display "- - - - - - - - - - - - - - - - - - - - - - -".

           display " ERRFLG= " errflg
                   " **** maximum number of errors is 8 ***".
           if errflg = 0
              display " *** pass ***"
              display "============================================="
              EXEC SQL INSERT INTO TESTREPORT
                    VALUES('0185','pass','PCO') END-EXEC
           else
              display " cob001.pco *** fail ***"
           display "================================================"
              EXEC SQL INSERT INTO TESTREPORT
                    VALUES('0185','fail','PCO') END-EXEC
             ADD 1 TO errcnt
           END-IF
           display " ".
           EXEC SQL COMMIT WORK END-EXEC.

      ******************** END TEST0185 *********************

      **** TESTER MAY CHOOSE TO INSERT CODE FOR errcnt > 0
           STOP RUN.

      *********************************************************

quality100%

¤ Dauer der Verarbeitung: 0.11 Sekunden (vorverarbeitet) ¤

Wurzel

Suchen

Beweissystem der NASA

Beweissystem Isabelle

NIST Cobol Testsuite

Cephes Mathematical Library

Wiener Entwicklungsmethode

Haftungshinweis

Die Informationen auf dieser Webseite wurden nach bestem Wissen sorgfältig zusammengestellt. Es wird jedoch weder Vollständigkeit, noch Richtigkeit, noch Qualität der bereit gestellten Informationen zugesichert.

Bemerkung:

Die farbliche Syntaxdarstellung ist noch experimentell.