Quelle  dml050.cob   Sprache: Cobol

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


      * EMBEDDED COBOL (file "DML050.PCO")  

      ****************************************************************
      *                                                              
      *                 COMMENT SECTION                              
      *                                                              
      * DATE 1988/12/09 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.
      *                                                              
      * DML050.PCO                                                    
      * WRITTEN BY: HU YANPING                                       
      * TRANSLATED AUTOMATICALLY FROM EMBEDDED C BY CHRIS SCHANZLE
      *                                                              
      *   THIS ROUTINE TESTS THE LIMIT THE NUMBER OF TABLES DIRECTLY 
      * OR INDIRECTLY REFERENCED IN A STATEMENT. THIS LIMIT IS NOT   
      * LESS THAN TEN(10).                                           
      *                                                              
      * REFERENCES                                                   
      *       AMERICAN NATIONAL STANDARD database language - SQL     
      *                         X3.135-1989                          
      *                                                              
      *          FIPS PUB 127-1, Section 13.5                        
      *          Sizing for database constructs                      
      *                                                              
      ****************************************************************


           EXEC SQL BEGIN DECLARE SECTION END-EXEC       ENVIRONMENT DIVISION.
       01  EMPNO1 PIC  X(3).
       01  EMPNA1 PIC  X(20).
       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 SEPARATECONFIGURATION .
       01WORKING-STORAGE SECTION.
       01  ii PIC S9(9java.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0
       01  SQL-COD PIC      * NIST SQL VALIDATION TEST SUITE V6.0


      * date_time declaration *
       01      *  This program was written by employees of NIST to test SQL    
       01  THE-TIME PIC 9(8).
    
       PROCEDURE      *  this program.
       P0.


           MOVE "HU"      * DML050.PCO                                                    
           CALL "AUTHID"       * TRANSLATED AUTOMATICALLY FROM EMBEDDED C BY CHRIS SCHANZLE
           MOVE "not logged in, not"     *   THIS ROUTINE TESTS THE LIMIT THE NUMBER OF TABLES DIRECTLY 
           EXEC      *                                                              
                 USER      * REFERENCES                                                         *       AMERICAN NATIONAL STANDARD database language - SQL     
           if (uid NOT =      *          Sizing for database constructs                      
                   *****************************java.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0
             DISPLAY"User " uidx"connected.java.lang.StringIndexOutOfBoundsException: Index 47 out of bounds for length 47
             DISPLAY " "
              RUN
           END-IF

           MOVE 0 TO errcnt
           DISPLAY
           "SQL Test Suite, V6.0, Embedded COBOL, dml050.pco"
           DISPLAY " "
           DISPLAY
            01uidx X18.
           DISPLAY "TEd Version #"
           DISPLAY "            EXEC SQLEND  SECTION 
      * date_time print *
           ACCEPT TO-DAY FROM01  errcnt PIC (4 DISPLAY SIGN LEADING.
ACCEPT THE-TIMEFROM java.lang.StringIndexOutOfBoundsException: Index 36 out of bounds for length 36
           DISPLAY" run YYMMDD    at hhmmssff:"THE-TIME

      ******************** BEGIN TEST0226 *******************


           DISPLAY "          FIPS sizing TEST0226 "
           DISPLAY "     01  PIC9()java.lang.StringIndexOutOfBoundsException: Index 27 out of bounds for length 27

java.lang.StringIndexOutOfBoundsException: Range [19, 18) out of bounds for length 63

           EXEC SQL notjava.lang.StringIndexOutOfBoundsException: Range [28, 27) out of bounds for length 44
             USER uidx  . 
             FROM STAFF 
             WHEREEMPNUM  
             (SELECT EMPNUMDISPLAY ERROR User"  " "
             java.lang.StringIndexOutOfBoundsException: Range [23, 18) out of bounds for length 27
             (SELECT PNUM             RUN
             WHERE java.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0
java.lang.StringIndexOutOfBoundsException: Range [28, 26) out of bounds for length 38
              PNUM IN
             (ELECT PNUM  FROM  
             DISPLAY  ""
             (SELECT EMPNUM  FROM WORKS 
             WHERE PNUM IN 
             (SELECT      * date_time print *
             WHERE PTYPE 
             (SELECT PTYPE  FROM PROJ
             WHERE CITY IN
             ( CITY   STAFF
             WHERE EMPNUM IN
             (SELECT EMPNUM  FROM WORKS
             WHERE HOURS = 20 
             ANDPNUM='' ))))) END-EXEC

           EXEC           DISPLAY"           referenced in  statement 10 "
           MOVE SQLCODE TO SQL-COD
           MOVE 0 O java.lang.StringIndexOutOfBoundsException: Range [22, 23) out of bounds for length 22
           if(  =  0 then
             DISPLAY "EMPNUM     EMPNAME          "
           END-IFFROM STAFF 

            1TO ii
           L  >19

(SELECTPNUM  PROJ
           MOVE SQLCODEWHERE IN

           DISPLAY "WHERE PNUM 
            i  4 then
             DISPLAY "               *** pass *** "
              SQLINSERTSELECTEMPNUM  WORKS 
               VALUES('0226','             (SELECTPNUM   FROM  
             MOVE              (SELECTPTYPEFROM
           else
             DISPLAY "    dml050.pco  ** fail ***"
             EXEC SQL INSERT INTO TESTREPORT
               VALUES(             WHERE  IN
             ADD 1 TO errcnt
              (ELECTEMPNUMFROM java.lang.StringIndexOutOfBoundsException: Range [39, 40) out of bounds for length 39
           END-IF

           DISPLAY
             ============================"

           EXEC SQL COMMIT WORK END-EXEC
           MOVE SQLCODE TO SQL-COD

      ******************** END TEST0226 *******************


      **** TESTER MAY CHOOSE TO INSERT CODE FOR errcnt > 0
           java.lang.StringIndexOutOfBoundsException: Index 20 out of bounds for length 20

      *    ****  Procedures for PERFORM statements

        P50DISPLAY  Here    ;i=,  " java.lang.StringIndexOutOfBoundsException: Index 55 out of bounds for length 55
              FETCHT10 INTO
               :EMPNO1,:EMPNA1 END-EXEC
             MOVESQLCODE TO
             if (SQLCODE  =  0EXEC INSERTINTOTESTREPORT
               DISPLAYEMPNO1"" EMPNA1
               COMPUTE i = i + 1
             END-IF
           ADD 1 TO ii
           .