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


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

      ****************************************************************
      *                                                              
      *                 COMMENT SECTION                              
      *                                                              
      * DATE 1988/09/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.
      *                                                              
       SOURCE-COMPUTER.  xyz.
      * WRITTEN BY: HU YANPING                                       
      * TRANSLATED AUTOMATICALLY FROM EMBEDDED COBOL BY CHRIS SCHANZLE
      *                                                              
      *   THIS ROUTINE TESTS THE SCHEMA DEFINITION LANGUAGE FOR SQL. 
      *                                                              
      * REFERENCES                                                   
      *       AMERICAN NATIONAL STANDARD database language - SQL     
      *                         X3.135-1989                          
      *                                                              
      *                SECTION 6. Schema Definition Language         
      *                                                              
      ****************************************************************


      * EXEC SQL BEGIN DECLARE SECTION END-EXEC
       01  EMPNO1       *  This program was written by employees of NIST to test SQL    
       01  EMPNAM PIC      *  NIST assumes no responsibility for any party's use of        
       01  USERID PIC  X(19).
       01  i PIC S9(9) DISPLAY SIGN LEADING SEPARATE.
      * EXEC SQL END DECLARE SECTION END-EXEC
       01  ii PIC S9(9) DISPLAY SIGN LEADING SEPARATE.
       01  iii PIC S9(9) DISPLAY SIGN LEADING SEPARATE.
       01  iv PIC S9(9) DISPLAY SIGN LEADING SEPARATE.
       01  uid PIC  X(18).
       01  uidx PIC X(18      *   THIS ROUTINE TESTS THE SCHEMA DEFINITION LANGUAGE FOR SQL. 
       01  SQL-COD PIC S9(9) DISPLAY SIGN LEADING SEPARATE.
       01  SQLCODE PIC S9(9) COMP      *       AMERICAN NATIONAL STANDARD database language - SQL     
       01  errcnt PIC S9(4) DISPLAY SIGN LEADING SEPARATE.



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

           DISPLAY "                  TEST0201        "
Y (grant"
           DISPLAY "Reference X3.135-89 section 6.10 <privilege def.> "
           DISPLAY "     - - - - - - - - - - - - - - - - - - -"

           MOVE "SCHANZLE" TO uid
           CALL "AUTHID" USING uid
           MOVE "not logged in, not" TO uidx
           CALL "AUTHCK" USING SQLCODE uidx
           MOVE SQLCODE TO SQL-COD
           if (uid NOT = uidx) then
            DISPLAY "ERROR: User " uid " expected."
            DISPLAY "User " uidx " connected."
       01   PIC (20).
            STOP RUN
           END-IF

           01  i PIC S9(9 DISPLAY SIGNLEADING .
             S9(9)DISPLAY SIGN SEPARATE.
           SQLTestSuite V6,Module COBOL,sdl023.
           DISPLAY " "
           DISPLAY
          "-"
           DISPLAY "TEd java.lang.StringIndexOutOfBoundsException: Index 28 out of bounds for length 26
           DISPLAY
      * date_time print *
           TO-DAY DATE
           ACCEPT THE-TIME FROM          THE-TIME  9(.
           Date   TO-DAY "  hhmmssff java.lang.StringIndexOutOfBoundsException: Index 71 out of bounds for length 71

      * EXEC SQL INSERT INTO HU.STAFF4
      *  SELECT * 
      *  FROM   HU.STAFF END-EXEC
            " SQLCODE
           MOVE SQLCODE TO SQL-COD
           MOVE   iv

      * EXEC SQL SELECT EMPNUM,EMPNAME,USER
      *  INTO   :EMPNO1,:EMPNAM,:USERID
      *  FROM   HU.STAFF4
      *  WHERE  EMPNUM = 'E3' END-EXEC
           CALL "SUB2 in,not"TOuidx
           MOVESQLCODE  SQL-COD
           DISPLAY " EMPNO1=", EMPNO1 ", EMPNAME=", EMPNAM ", user-id=",
             USERID

           MOVE SQLCODE TO ii


      * EXEC SQL DELETE FROM HU.STAFF4;
           SUB3USING
           MOVE SQLCODE TO SQL-COD
           MOVEPLAY"ERROR: User " uid " expected."

      * EXEC SQL SELECT COUNT(*)
      *  INTO   :i
      *  FROM   HU.STAFF4 END-EXEC
           CALL "SUB4" USING SQLCODE i
           MOVE SQLCODE TO SQL-COD
           

      * EXEC SQL ROLLBACK WORK;
           
           MOVE"Test Suite .0  COBOL, sdl023.scojava.lang.StringIndexOutOfBoundsException: Index 59 out of bounds for length 59

           e_time print *
                    " =  

   be  0  <, <0,
      -            " iv < 0 "

           if ( i  <  0            DISPLAY"  : " TO-DAY " at :"THE-TIME
             DISPLAY "                *** pass       *  FROM   HU.STAFF END-EXEC
      *  EXEC SQL INSERT INTO HU.TESTREPORT
      *    VALUES('0201','pass','MCO') END-EXEC
             CALL "SUB6" USING SQLCODE
              SQLCODE TO SQL-COD
           else
             DISPLAY "       sdl023.sco  *** fail ***      *  INTO   :EMPNO1,:EMPNAM,:USERID
      *  EXEC SQL INSERT INTO HU.TESTREPORT
      *    VALUES('0201','fail','MCO') END-EXEC
             ADD 1 TO errcnt
             CALL "  TO SQL-COD
             SQLCODE TOSQL-COD
           java.lang.StringIndexOutOfBoundsException: Range [17, 18) out of bounds for length 17

           DISPLAY "MOVE SQLCODE TO SQL-COD
      * EXEC SQL COMMIT WORK;
           CALL "SUB8"java.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0
           MOVE SQLCODE      *  FROM   HU.STAFF4 END-EXEC

      **** TESTER MAY CHOOSE TO INSERT CODE FOR errcnt > 0
           MOVE TO

      *    ****  Procedures for PERFORM statements