Quelle cdr030.cob Sprache: Cobol

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

      * Standard COBOL (file "CDR030.SCO") calling SQL
      * procedures in file "CDR030.MCO".
      * STANDARD COBOL (file "CDR030.SCO")

      ****************************************************************
      *
      *                 COMMENT SECTION
      *
      * DATE 1992/08/06 STANDARD 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.
      *
      * CDR030.SCO
      * WRITTEN BY: Joan Sullivan
      *
      *   THIS ROUTINE TESTS SQLSTATE 23000
      *
      ****************************************************************

      * EXEC SQL BEGIN DECLARE SECTION END-EXEC
       01  uid PIC  X(18).
       01  uidx PIC  X(18).
       01  junkit PIC  X(10).
       01  CPNUM1 PIC S9(9) DISPLAY SIGN LEADING SEPARATE.
       01  count1 PIC S9(9) DISPLAY SIGN LEADING SEPARATE.
      *  EXEC SQL END DECLARE SECTION END-EXEC
       01  SQLCODE PIC S9(9) COMP.
       01  SQLSTATE PIC  X(5).
       01  ii PIC S9(9) DISPLAY SIGN LEADING SEPARATE.
       01  norm1 PIC S9(9) DISPLAY SIGN LEADING SEPARATE.
       01  norm2 PIC S9(9) DISPLAY SIGN LEADING SEPARATE.
       01  ALPNUM-TABLE VALUE IS
               "01234ABCDEFGH56789IJKLMNOPQRSTUVWXYZ".
           05  ALPNUM PIC X OCCURS 36 TIMES.

       01  NR-TAB.
           05  NORMSQ PIC X OCCURS 5 TIMES.
       01  errcnt PIC S9(9) DISPLAY SIGN LEADING SEPARATE.
      *date_time declaration
       01  TO-DAY PIC 9(6).
       01  THE-TIME PIC 9(8).
       01  flag PIC S9(9) DISPLAY SIGN LEADING SEPARATE.

       01  SQL-COD PIC S9(9) DISPLAY SIGN LEADING SEPARATE.

       PROCEDURE DIVISION.
       P0.

             MOVE "SUN" TO uid
             CALL "AUTHID" USING uid
             MOVE "not logged in, not" TO uidx
      *  EXEC SQL SELECT USER INTO :uidx FROM SUN.ECCO;
             CALL "SUB1" USING SQLCODE SQLSTATE uidx
             MOVE SQLCODE TO SQL-COD
             if (uid  NOT  =   uidx) then
               DISPLAY "ERROR: User ", uid " expected. User ", uidx "
      -    " connected"
             STOP RUN
             END-IF
             MOVE 0 TO errcnt

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

      ******************** BEGIN TEST0516 *******************
             MOVE 1 TO flag

             DISPLAY " TEST0516 "
             DISPLAY " SQLSTATE = 23000: integrity constraint violation"
             DISPLAY "Note: VALID implementation-defined subclass will
      -    " be"
             DISPLAY " accepted instead of no-subclass value of 000
      -    " "
             DISPLAY "Reference ANSI SQL-1992 10.6 "
             DISPLAY " General Rule 4"
             DISPLAY " - - - - - - - - - - - - - - - - - - -"

      *Testing referential integrity ERROR, parent missing
             DISPLAY "INSERT INTO EMP VALUES"
             DISPLAY " (41,'Tom','China Architecture',"
             DISPLAY " 20,'Architecture',040553);"
             MOVE "x" TO SQLSTATE
      *  EXEC SQL INSERT INTO EMP VALUES
      *    (41,'Tom','China Architecture',
      *    20,'Architecture',040553);
             CALL "SUB2" USING SQLCODE SQLSTATE
             MOVE SQLCODE TO SQL-COD
             DISPLAY "Testing referential integrity ERROR, parent
      -    " missing"
             DISPLAY "SQLCODE should be < 0; its value is ", SQL-COD
             DISPLAY "SQLSTATE should be '23000'; its value is ",
             SQLSTATE
             DISPLAY  " "
             PERFORM NOSUBCLASS THRU EXIT-NOSUBCLASS
             if (SQLCODE  NOT <  0  OR  NR-TAB NOT = "23000") then
               MOVE 0 TO flag
             END-IF

             DISPLAY "-------------------------------------------------"

      *Testing referential integrity ERROR, children exist
             DISPLAY "DELETE FROM EMP"
             DISPLAY " WHERE ENO = 21; "
             MOVE "x" TO SQLSTATE
      *  EXEC SQL DELETE FROM EMP
      *    WHERE ENO = 21;
             CALL "SUB3" USING SQLCODE SQLSTATE
             MOVE SQLCODE TO SQL-COD
             DISPLAY "Testing referential integrity ERROR, children
      -    " exist"
             DISPLAY "SQLCODE should be < 0; its value is ", SQL-COD
             DISPLAY "SQLSTATE should be '23000'; its value is ",
             SQLSTATE
             DISPLAY  " "
             PERFORM NOSUBCLASS THRU EXIT-NOSUBCLASS
             if (SQLCODE  NOT <  0  OR  NR-TAB NOT = "23000") then
               MOVE 0 TO flag
             END-IF

             DISPLAY "-------------------------------------------------"

      *Testing referential integrity ERROR, children exist
             DISPLAY "UPDATE EMP"
             DISPLAY " SET ENAME = 'Thomas' WHERE ENO = 21; "
             MOVE "x" TO SQLSTATE
      *  EXEC SQL UPDATE EMP
      *    SET ENAME = 'Thomas'
      *    WHERE ENO = 21;
             CALL "SUB4" USING SQLCODE SQLSTATE
             MOVE SQLCODE TO SQL-COD
             DISPLAY "Testing referential integrity ERROR, children
      -    " exist "
             DISPLAY "SQLCODE should be < 0; its value is ", SQL-COD
             DISPLAY "SQLSTATE should be '23000'; its value is ",
             SQLSTATE
             DISPLAY  " "
             PERFORM NOSUBCLASS THRU EXIT-NOSUBCLASS
             if (SQLCODE  NOT <  0  OR  NR-TAB NOT = "23000") then
               MOVE 0 TO flag
             END-IF

             DISPLAY "-------------------------------------------------"

      *Testing unique constraint ERROR
             DISPLAY " **** PRIMARY KEY (EMPNUM) **** "
             DISPLAY "DELETE FROM STAFF7;"
             DISPLAY "INSERT INTO STAFF7 (EMPNUM) VALUES ('XXX');"

      *  EXEC SQL DELETE FROM STAFF7;
             CALL "SUB5" USING SQLCODE SQLSTATE
             MOVE SQLCODE TO SQL-COD

             MOVE "x" TO SQLSTATE
      *  EXEC SQL INSERT INTO STAFF7 (EMPNUM) VALUES ('XXX')
      * ;
             CALL "SUB6" USING SQLCODE SQLSTATE
             MOVE SQLCODE TO SQL-COD
             DISPLAY "SQLCODE should be 0; its value is ", SQL-COD
             DISPLAY "SQLSTATE should be '00000'; its value is ",
             SQLSTATE
             PERFORM NOSUBCLASS THRU EXIT-NOSUBCLASS
             if (SQLCODE  NOT =  0  OR  NR-TAB NOT = "00000") then
               MOVE 0 TO flag
             END-IF

             MOVE "x" TO SQLSTATE
      *  EXEC SQL INSERT INTO STAFF7 (EMPNUM) VALUES ('XXX')
      * ;
             CALL "SUB7" USING SQLCODE SQLSTATE
             MOVE SQLCODE TO SQL-COD
             DISPLAY "INSERT INTO STAFF7 (EMPNUM) VALUES ('XXX');"
             DISPLAY "Testing unique constraint ERROR "
             DISPLAY "SQLCODE should be < 0; its value is ", SQL-COD
             DISPLAY "SQLSTATE should be '23000'; its value is ",
             SQLSTATE
             DISPLAY  " "
             PERFORM NOSUBCLASS THRU EXIT-NOSUBCLASS
             if (SQLCODE  NOT <  0  OR  NR-TAB NOT = "23000") then
               MOVE 0 TO flag
             END-IF

             DISPLAY "-------------------------------------------------"

      *Testing unique constraint ERROR
             DISPLAY " **** UNIQUE (PNUM) **** "
             DISPLAY " DELETE FROM PROJ3;"
             DISPLAY " INSERT INTO PROJ3 (PNUM) VALUES ('787');"
             DISPLAY " INSERT INTO PROJ3 (PNUM) VALUES ('789');"

      *  EXEC SQL DELETE FROM PROJ3;
             CALL "SUB8" USING SQLCODE SQLSTATE
             MOVE SQLCODE TO SQL-COD

      *  EXEC SQL INSERT INTO PROJ3 (PNUM) VALUES ('787');
             CALL "SUB9" USING SQLCODE SQLSTATE
             MOVE SQLCODE TO SQL-COD
             MOVE "x" TO SQLSTATE
      *  EXEC SQL INSERT INTO PROJ3 (PNUM) VALUES ('789');
             CALL "SUB10" USING SQLCODE SQLSTATE
             MOVE SQLCODE TO SQL-COD
             DISPLAY "SQLCODE should be 0; its value is ", SQL-COD
             DISPLAY "SQLSTATE should be '00000'; its value is ",
             SQLSTATE
             PERFORM NOSUBCLASS THRU EXIT-NOSUBCLASS
             if (SQLCODE  NOT =  0  OR  NR-TAB NOT = "00000") then
               MOVE 0 TO flag
             END-IF

             MOVE "x" TO SQLSTATE
      *  EXEC SQL UPDATE PROJ3 SET PNUM = '787' WHERE PNUM = '789'
      * ;
             CALL "SUB11" USING SQLCODE SQLSTATE
             MOVE SQLCODE TO SQL-COD
             DISPLAY "UPDATE PROJ3 SET PNUM = '787' WHERE PNUM = '789';"
             DISPLAY "Testing unique constraint ERROR "
             DISPLAY "SQLCODE should be < 0; its value is ", SQL-COD
             DISPLAY "SQLSTATE should be '23000'; its value is ",
             SQLSTATE
             DISPLAY  " "
             PERFORM NOSUBCLASS THRU EXIT-NOSUBCLASS
             if (SQLCODE  NOT <  0  OR  NR-TAB NOT = "23000") then
               MOVE 0 TO flag
             END-IF

             DISPLAY "-------------------------------------------------"

      *Testing check constraint ERROR
             DISPLAY " **** CHECK GRADE NOT IN (5,22) ****"
             DISPLAY " DELETE FROM STAFF11;"
             DISPLAY " INSERT INTO STAFF11"
             DISPLAY " VALUES('E3','Susan',11,'Hawaii');"

      *  EXEC SQL DELETE FROM STAFF11;
             CALL "SUB12" USING SQLCODE SQLSTATE
             MOVE SQLCODE TO SQL-COD
             MOVE "x" TO SQLSTATE
      *  EXEC SQL INSERT INTO STAFF11
      *    VALUES('E3','Susan',11,'Hawaii');
             CALL "SUB13" USING SQLCODE SQLSTATE
             MOVE SQLCODE TO SQL-COD
             DISPLAY "SQLCODE should be 0; its value is ", SQL-COD
             DISPLAY "SQLSTATE should be '00000'; its value is ",
             SQLSTATE
             PERFORM NOSUBCLASS THRU EXIT-NOSUBCLASS
             if (SQLCODE  NOT =  0  OR  NR-TAB NOT = "00000") then
               MOVE 0 TO flag
             END-IF

             MOVE "x" TO SQLSTATE
      *  EXEC SQL UPDATE STAFF11
      *    SET GRADE = 5
      *    WHERE EMPNUM = 'E3';
             CALL "SUB14" USING SQLCODE SQLSTATE
             MOVE SQLCODE TO SQL-COD

             DISPLAY " UPDATE STAFF11"
             DISPLAY " SET GRADE = 5"
             DISPLAY " WHERE EMPNUM = 'E3';"
             DISPLAY "Testing check constraint ERROR "
             DISPLAY "SQLCODE should be < 0; its value is ", SQL-COD
             DISPLAY "SQLSTATE should be '23000'; its value is ",
             SQLSTATE
             DISPLAY  " "
             PERFORM NOSUBCLASS THRU EXIT-NOSUBCLASS
             if (SQLCODE  NOT <  0  OR  NR-TAB NOT = "23000") then
               MOVE 0 TO flag
             END-IF

             DISPLAY "-------------------------------------------------"

      *Testing check constraint ERROR
             DISPLAY " ***** CHECK NOT EMPNAME LIKE 'T",  " ****"
             DISPLAY "UPDATE STAFF11"
             DISPLAY " SET EMPNAME = 'Tom'"
             DISPLAY " WHERE EMPNUM = 'E3';"

             MOVE "x" TO SQLSTATE
      *  EXEC SQL UPDATE STAFF11
      *    SET EMPNAME = 'Tom'
      *    WHERE EMPNUM = 'E3';
             CALL "SUB15" USING SQLCODE SQLSTATE
             MOVE SQLCODE TO SQL-COD
             DISPLAY "Testing check constraint ERROR"
             DISPLAY "SQLCODE should be < 0; its value is ", SQL-COD
             DISPLAY "SQLSTATE should be '23000'; its value is ",
             SQLSTATE
             DISPLAY  " "
             PERFORM NOSUBCLASS THRU EXIT-NOSUBCLASS
             if (SQLCODE  NOT <  0  OR  NR-TAB NOT = "23000") then
               MOVE 0 TO flag
             END-IF

      *  EXEC SQL ROLLBACK WORK;
             CALL "SUB16" USING SQLCODE SQLSTATE
             MOVE SQLCODE TO SQL-COD

             if (flag  =  1) then
               DISPLAY " *** pass *** "
      *    EXEC SQL INSERT INTO SUN.TESTREPORT
      *      VALUES('0516','pass','MCO');
               CALL "SUB17" USING SQLCODE SQLSTATE
               MOVE SQLCODE TO SQL-COD
             else
               DISPLAY " cdr030.sco *** fail *** "
      *    EXEC SQL INSERT INTO SUN.TESTREPORT
      *      VALUES('0516','fail','MCO');
               CALL "SUB18" USING SQLCODE SQLSTATE
               MOVE SQLCODE TO SQL-COD
               COMPUTE errcnt = errcnt + 1
             END-IF
      *  EXEC SQL COMMIT WORK;
             CALL "SUB19" USING SQLCODE SQLSTATE
             MOVE SQLCODE TO SQL-COD
             DISPLAY "================================================"

      ******************** END TEST0516 ********************

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

      *    ****  Procedures for PERFORM statements

       NOSUBCLASS.

      *This routine replaces valid implementation-defined
      *subclasses with 000.  This replacement equates valid
      *implementation-defined subclasses with the 000 value
      *expected by the test case; otherwise the test will fail.
      *After calling NOSUBCLASS, NORMSQ will be tested
      *                          SQLSTATE will be printed.

           MOVE SQLSTATE TO NR-TAB

           MOVE 3 TO norm1
      *subclass begins in position 3 of char array NORMSQ
           MOVE 14 TO norm2
           PERFORM P90 UNTIL norm2 > 36

           if (NR-TAB   =   SQLSTATE) then
             GO TO EXIT-NOSUBCLASS
           END-IF
      *Quit if NORMSQ is unchanged.  Subclass is not impl.-def.
      *Changed NORMSQ means implementation-defined subclass,
      *so proceed to zero it out, if valid (0-9,A-Z)

           MOVE 4 TO norm1
      *examining position 4 of char array NORMSQ
           MOVE 1 TO norm2
           PERFORM P89 UNTIL norm2 > 36

           MOVE 5 TO norm1
      *examining position 5 of char array NORMSQ
           MOVE 1 TO norm2
           PERFORM P88 UNTIL norm2 > 36


      *implementation-defined subclasses are allowed for warnings
      *(class = 01).  These equate to successful completion
      *SQLSTATE values of 00000.
      *Reference SQL-92 4.28 SQL-transactions, paragraph 2

           if (NORMSQ(1)  =  "0"  AND  NORMSQ(2)  =  "1") then
             MOVE "0" TO NORMSQ(2)
           END-IF
           GO TO EXIT-NOSUBCLASS
           .

       P90.
      *valid subclass begins with 5-9, I-Z, end of ALPNUM table
           if (NORMSQ(norm1)  =  ALPNUM(norm2)) then
             MOVE "0" TO NORMSQ(norm1)
           END-IF
           ADD 1 TO norm2
           .

       P89.
      *valid characters are 0-9, A-Z
           if (NORMSQ(norm1)  =  ALPNUM(norm2)) then
             MOVE "0" TO NORMSQ(norm1)
           END-IF
           ADD 1 TO norm2
           .

       P88.
      *valid characters are 0-9, A-Z
           if (NORMSQ(norm1)  =  ALPNUM(norm2)) then
             MOVE "0" TO NORMSQ(norm1)
           END-IF
           ADD 1 TO norm2
           .

       EXIT-NOSUBCLASS.
           EXIT.

quality100%

¤ Dauer der Verarbeitung: 0.16 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.