| products/Sources/formale Sprachen/Java/apache-tomcat-10.1.16-src/webapps/docs/ |
|
Quellcode-Bibliothek
© Kompilation durch diese Firma
[Weder Korrektheit noch Funktionsfähigkeit der Software werden zugesichert.]
Datei: cob007.cob Sprache: Unknown
|
IDENTIFICATION DIVISION.
PROGRAM-ID. COB007. ENVIRONMENT DIVISION. CONFIGURATION SECTION. SOURCE-COMPUTER. xyz. OBJECT-COMPUTER. xyz. DATA DIVISION. WORKING-STORAGE SECTION. * Standard COBOL (file "COB007.SCO") calling SQL * procedures in file "COB007.MCO" *************************************************************** * * COMMENT SECTION * * DATE 1988/08/29 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. * * COB007.SCO * WRITTEN BY: S Hurwitz * TRANSLATED AUTOMATICALLY FROM EMBEDDED COBOL BY CHRIS SCHANZLE * * THIS ROUTINE TESTS COBOL DATA TYPES IN SQL LANGUAGE. * * REFERENCES * AMERICAN NATIONAL STANDARD database language - SQL * X3.135-1989 * * SECTION 5.5 <data type> * ANNEX C. <embedded SQL COBOL program> * * *************************************************************** * EXEC SQL BEGIN DECLARE SECTION END-EXEC 01 var1 PIC S9 DISPLAY SIGN LEADING SEPARATE. 01 var7 PIC S9(7) DISPLAY SIGN LEADING SEPARATE. * EXEC SQL END DECLARE SECTION END-EXEC 01 uid PIC X(18). 01 uidx PIC X(18). 01 SQL-COD PIC S9(9) DISPLAY SIGN LEADING SEPARATE. 01 SQLCODE PIC S9(9) COMP. 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. MOVE "HU" 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." DISPLAY " " STOP RUN END-IF MOVE 0 TO errcnt DISPLAY "SQL Test Suite, V6.0, Module COBOL, cob007.sco" 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 TEST0210 ******************* DISPLAY " TEST0210" DISPLAY "reference: X3.135-1989 5.5 & ANNEX C. " DISPLAY "- - - - - - - - - - - - - - - - - - - - " DISPLAY " " DISPLAY "*** CREATE TABLE P1 (numtest NUMERIC(1)) " DISPLAY "*** INSERT INTO P1 " DISPLAY "*** VALUES('1') " DISPLAY " " * EXEC SQL INSERT INTO P1 * VALUES(1) END-EXEC CALL "SUB1" USING SQLCODE MOVE SQLCODE TO SQL-COD DISPLAY " After INSERT SQLCODE = ", SQL-COD " " MOVE 0 TO var1 * EXEC SQL SELECT * * INTO :var1 * FROM P1 END-EXEC CALL "SUB2" USING SQLCODE var1 MOVE SQLCODE TO SQL-COD DISPLAY " var1 = ", var1 * EXEC SQL ROLLBACK WORK; CALL "SUB3" USING SQLCODE MOVE SQLCODE TO SQL-COD if (var1 = 1) then DISPLAY " " DISPLAY " *** pass ***" DISPLAY " " * EXEC SQL INSERT INTO TESTREPORT * VALUES('0210','pass','MCO') END-EXEC CALL "SUB4" USING SQLCODE MOVE SQLCODE TO SQL-COD else DISPLAY " " DISPLAY " cob007.sco *** fail ***" DISPLAY " " * EXEC SQL INSERT INTO TESTREPORT * VALUES('0210','fail','MCO') END-EXEC ADD 1 TO errcnt CALL "SUB5" USING SQLCODE MOVE SQLCODE TO SQL-COD END-IF DISPLAY "=====================================================" DISPLAY " " * EXEC SQL COMMIT WORK; CALL "SUB6" USING SQLCODE MOVE SQLCODE TO SQL-COD ******************** END TEST0210 ******************* ******************** BEGIN TEST0211 ******************* DISPLAY " TEST0211 " DISPLAY "reference: X3.135-1989 5.5 & ANNEX C. " DISPLAY "- - - - - - - - - - - - - - - - - - - - " DISPLAY " " DISPLAY "*** CREATE TABLE P7 (numtest NUMERIC(7)) " DISPLAY "*** INSERT INTO P7 " DISPLAY "*** VALUES(1234567) " DISPLAY " " * EXEC SQL INSERT INTO P7 * VALUES(1234567) END-EXEC CALL "SUB7" USING SQLCODE MOVE SQLCODE TO SQL-COD DISPLAY " After INSERT SQLCODE = ", SQL-COD " " MOVE 0 TO var7 * EXEC SQL SELECT * * INTO :var7 * FROM P7 END-EXEC CALL "SUB8" USING SQLCODE var7 MOVE SQLCODE TO SQL-COD DISPLAY " var7 = ", var7 * EXEC SQL ROLLBACK WORK; CALL "SUB9" USING SQLCODE MOVE SQLCODE TO SQL-COD if (var7 = 1234567) then DISPLAY " " DISPLAY " *** pass ***" DISPLAY " " * EXEC SQL INSERT INTO TESTREPORT * VALUES('0211','pass','MCO') END-EXEC CALL "SUB10" USING SQLCODE MOVE SQLCODE TO SQL-COD else DISPLAY " " DISPLAY " cob007.sco *** fail ***" DISPLAY " " * EXEC SQL INSERT INTO TESTREPORT * VALUES('0211','fail','MCO') END-EXEC ADD 1 TO errcnt CALL "SUB11" USING SQLCODE MOVE SQLCODE TO SQL-COD END-IF DISPLAY "=====================================================" DISPLAY " " * EXEC SQL COMMIT WORK; CALL "SUB12" USING SQLCODE MOVE SQLCODE TO SQL-COD ******************** END TEST0211 ******************* **** TESTER MAY CHOOSE TO INSERT CODE FOR errcnt > 0 STOP RUN. [ Dauer der Verarbeitung: 0.22 Sekunden (vorverarbeitet) ] |