| products/Sources/formale Sprachen/Cobol/Test-Suite/SQL M/ |
|
Quellcode-Bibliothek© Kompilation durch diese Firma[Weder Korrektheit noch Funktionsfähigkeit der Software werden zugesichert.]Datei: dml153.cob Sprache: Cobol |
|
||||||
|
IDENTIFICATION DIVISION.
PROGRAM-ID. DML153. ENVIRONMENT DIVISION. CONFIGURATION SECTION. SOURCE-COMPUTER. xyz. OBJECT-COMPUTER. xyz. DATA DIVISION. WORKING-STORAGE SECTION. * Standard COBOL (file "DML153.SCO") calling SQL * procedures in file "DML153.MCO". **************************************************************** * * COMMENT SECTION * * DATE 1995/3/27 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. * * DML153.SCO * WRITTEN BY: David W. Flater * TRANSLATED AUTOMATICALLY FROM EMBEDDED COBOL BY CHRIS SCHANZLE * * This routine tests FIPS feature 11 (Transaction Isolation). * * REFERENCES * FIPS PUB 127-2 14.1 Transitional SQL * ANSI SQL-1992 * **************************************************************** * EXEC SQL BEGIN DECLARE SECTION END-EXEC 01 SQLCODE PIC S9(9) COMP. 01 SQLSTATE PIC X(5). 01 uid PIC X(18). 01 uidx PIC X(18). 01 int1 PIC S9(9) DISPLAY SIGN LEADING SEPARATE. 01 c20 PIC X(20). * EXEC SQL END DECLARE SECTION END-EXEC 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 NORMSQ. 05 NORMSQX 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 "FLATER " TO uid CALL "AUTHID" USING uid MOVE "not logged in, not" TO uidx * EXEC SQL SELECT USER INTO :uidx FROM HU.ECCO; CALL "SUB1" USING SQLCODE SQLSTATE uidx MOVE SQLCODE TO SQL-COD * EXEC SQL ROLLBACK WORK; CALL "SUB2" USING SQLCODE SQLSTATE 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, Module COBOL, dml153.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 TEST0848 ******************* MOVE 1 TO flag DISPLAY " TEST0848" DISPLAY " Query spec with subquery is now updatable" DISPLAY "References:" DISPLAY " F# 11 -- Transaction isolation" DISPLAY " 7.9 LR.2.a" DISPLAY " - - - - - - - - - - - - - - - - - - -" COMPUTE SQLCODE = -1 MOVE "xxxxx" TO SQLSTATE DISPLAY "CREATE VIEW EXON AS" DISPLAY " SELECT * FROM HU.STAFF WHERE CITY IN" DISPLAY " (SELECT CITY FROM HU.PROJ);" * EXEC SQL CREATE VIEW EXON AS * SELECT * FROM HU.STAFF WHERE CITY IN * (SELECT CITY FROM HU.PROJ); CALL "SUB3" USING SQLCODE SQLSTATE MOVE SQLCODE TO SQL-COD PERFORM CHCKOK DISPLAY " " DISPLAY "COMMIT WORK;" * EXEC SQL COMMIT WORK; CALL "SUB4" USING SQLCODE SQLSTATE MOVE SQLCODE TO SQL-COD PERFORM CHCKOK DISPLAY " " DISPLAY "DELETE FROM EXON" DISPLAY " WHERE GRADE = 10;" * EXEC SQL DELETE FROM EXON * WHERE GRADE = 10; CALL "SUB5" USING SQLCODE SQLSTATE MOVE SQLCODE TO SQL-COD PERFORM CHCKOK DISPLAY " " COMPUTE int1 = -1 DISPLAY "SELECT COUNT(*) INTO :int1 FROM HU.STAFF;" * EXEC SQL SELECT COUNT(*) INTO :int1 FROM HU.STAFF; CALL "SUB6" USING SQLCODE SQLSTATE int1 MOVE SQLCODE TO SQL-COD PERFORM CHCKOK DISPLAY "int1 should be 4; its value is ", int1 if (int1 NOT = 4) then MOVE 0 TO flag END-IF DISPLAY "ROLLBACK WORK;" * EXEC SQL ROLLBACK WORK; CALL "SUB7" USING SQLCODE SQLSTATE MOVE SQLCODE TO SQL-COD PERFORM CHCKOK DISPLAY " " DISPLAY "DECLARE GORTON CURSOR FOR" DISPLAY " SELECT EMPNAME FROM EXON;" * EXEC SQL DECLARE GORTON CURSOR FOR * SELECT EMPNAME FROM EXON END-EXEC DISPLAY "OPEN GORTON;" * EXEC SQL OPEN GORTON; CALL "SUB8" USING SQLCODE SQLSTATE MOVE SQLCODE TO SQL-COD PERFORM CHCKOK DISPLAY " " MOVE "xxxxxxxxxxxxxxxxxxxx" TO c20 DISPLAY "FETCH GORTON INTO :c20;" * EXEC SQL FETCH GORTON INTO :c20; CALL "SUB9" USING SQLCODE SQLSTATE c20 MOVE SQLCODE TO SQL-COD PERFORM CHCKOK DISPLAY "c20 is '", c20 "'" DISPLAY "UPDATE EXON" DISPLAY " SET EMPNAME = 'Heathen'" DISPLAY " WHERE CURRENT OF GORTON;" * EXEC SQL UPDATE EXON * SET EMPNAME = 'Heathen' * WHERE CURRENT OF GORTON; CALL "SUB10" USING SQLCODE SQLSTATE MOVE SQLCODE TO SQL-COD PERFORM CHCKOK DISPLAY " " MOVE "xxxxxxxxxxxxxxxxxxxx" TO c20 DISPLAY "FETCH GORTON INTO :c20;" * EXEC SQL FETCH GORTON INTO :c20; CALL "SUB11" USING SQLCODE SQLSTATE c20 MOVE SQLCODE TO SQL-COD PERFORM CHCKOK DISPLAY "c20 is '", c20 "'" DISPLAY "UPDATE EXON" DISPLAY " SET EMPNAME = 'Heretic'" DISPLAY " WHERE CURRENT OF GORTON;" * EXEC SQL UPDATE EXON * SET EMPNAME = 'Heretic' * WHERE CURRENT OF GORTON; CALL "SUB12" USING SQLCODE SQLSTATE MOVE SQLCODE TO SQL-COD PERFORM CHCKOK DISPLAY " " MOVE "xxxxxxxxxxxxxxxxxxxx" TO c20 DISPLAY "FETCH GORTON INTO :c20;" * EXEC SQL FETCH GORTON INTO :c20; CALL "SUB13" USING SQLCODE SQLSTATE c20 MOVE SQLCODE TO SQL-COD PERFORM CHCKOK DISPLAY "c20 is '", c20 "'" DISPLAY "DELETE FROM EXON" DISPLAY " WHERE CURRENT OF GORTON;" * EXEC SQL DELETE FROM EXON * WHERE CURRENT OF GORTON; CALL "SUB14" USING SQLCODE SQLSTATE MOVE SQLCODE TO SQL-COD PERFORM CHCKOK DISPLAY " " DISPLAY "CLOSE GORTON;" * EXEC SQL CLOSE GORTON; CALL "SUB15" USING SQLCODE SQLSTATE MOVE SQLCODE TO SQL-COD PERFORM CHCKOK DISPLAY " " COMPUTE int1 = -1 DISPLAY "SELECT COUNT(*) INTO :int1 FROM HU.STAFF" DISPLAY " WHERE EMPNAME LIKE 'H%';" * EXEC SQL SELECT COUNT(*) INTO :int1 FROM HU.STAFF * WHERE EMPNAME LIKE 'H%'; CALL "SUB16" USING SQLCODE SQLSTATE int1 MOVE SQLCODE TO SQL-COD PERFORM CHCKOK DISPLAY "int1 should be 2; its value is ", int1 if (int1 NOT = 2) then MOVE 0 TO flag END-IF COMPUTE int1 = -1 DISPLAY "SELECT COUNT(*) INTO :int1 FROM HU.STAFF;" * EXEC SQL SELECT COUNT(*) INTO :int1 FROM HU.STAFF; CALL "SUB17" USING SQLCODE SQLSTATE int1 MOVE SQLCODE TO SQL-COD PERFORM CHCKOK DISPLAY "int1 should be 4; its value is ", int1 if (int1 NOT = 4) then MOVE 0 TO flag END-IF DISPLAY "ROLLBACK WORK;" * EXEC SQL ROLLBACK WORK; CALL "SUB18" USING SQLCODE SQLSTATE MOVE SQLCODE TO SQL-COD PERFORM CHCKOK DISPLAY " " DISPLAY "DECLARE GORDY CURSOR FOR" DISPLAY " SELECT EMPNAME FROM HU.STAFF WHERE GRADE >" DISPLAY " (SELECT MIN (BUDGET) / 1000 FROM HU.PROJ" DISPLAY " WHERE HU.STAFF.CITY = HU.PROJ.CITY)" DISPLAY " AND EMPNAME <> 'Don';" * EXEC SQL DECLARE GORDY CURSOR FOR * SELECT EMPNAME FROM HU.STAFF WHERE GRADE > * (SELECT MIN (BUDGET) / 1000 FROM HU.PROJ * WHERE HU.STAFF.CITY = HU.PROJ.CITY) * AND EMPNAME <> 'Don' END-EXEC DISPLAY "OPEN GORDY;" * EXEC SQL OPEN GORDY; CALL "SUB19" USING SQLCODE SQLSTATE MOVE SQLCODE TO SQL-COD PERFORM CHCKOK DISPLAY " " MOVE "xxxxxxxxxxxxxxxxxxxx" TO c20 DISPLAY "FETCH GORDY INTO :c20;" * EXEC SQL FETCH GORDY INTO :c20; CALL "SUB20" USING SQLCODE SQLSTATE c20 MOVE SQLCODE TO SQL-COD PERFORM CHCKOK DISPLAY "c20 is '", c20 "'" DISPLAY "UPDATE HU.STAFF" DISPLAY " SET EMPNAME = 'Zerta'" DISPLAY " WHERE CURRENT OF GORDY;" * EXEC SQL UPDATE HU.STAFF * SET EMPNAME = 'Zerta' * WHERE CURRENT OF GORDY; CALL "SUB21" USING SQLCODE SQLSTATE MOVE SQLCODE TO SQL-COD PERFORM CHCKOK DISPLAY " " MOVE "xxxxxxxxxxxxxxxxxxxx" TO c20 DISPLAY "FETCH GORDY INTO :c20;" * EXEC SQL FETCH GORDY INTO :c20; CALL "SUB22" USING SQLCODE SQLSTATE c20 MOVE SQLCODE TO SQL-COD PERFORM CHCKOK DISPLAY "c20 is '", c20 "'" DISPLAY "DELETE FROM HU.STAFF" DISPLAY " WHERE CURRENT OF GORDY;" * EXEC SQL DELETE FROM HU.STAFF * WHERE CURRENT OF GORDY; CALL "SUB23" USING SQLCODE SQLSTATE MOVE SQLCODE TO SQL-COD PERFORM CHCKOK DISPLAY " " MOVE "xxxxxxxxxxxxxxxxxxxx" TO c20 DISPLAY "FETCH GORDY INTO :c20;" * EXEC SQL FETCH GORDY INTO :c20; CALL "SUB24" USING SQLCODE SQLSTATE c20 MOVE SQLCODE TO SQL-COD DISPLAY "SQLCODE should be 100; its value is ", SQL-COD DISPLAY "SQLSTATE should be 02000; its value is ", SQLSTATE PERFORM NOSUBCLASS THRU EXIT-NOSUBCLASS if (SQLCODE NOT = 100 OR NORMSQ NOT = "02000") then MOVE 0 TO flag END-IF if (NORMSQ = "02000" AND NORMSQ NOT = SQLSTATE) then DISPLAY "Valid implementation-defined SQLSTATE accepted." END-IF DISPLAY " " DISPLAY "CLOSE GORDY;" * EXEC SQL CLOSE GORDY; CALL "SUB25" USING SQLCODE SQLSTATE MOVE SQLCODE TO SQL-COD PERFORM CHCKOK DISPLAY " " COMPUTE int1 = -1 DISPLAY "SELECT COUNT(*) INTO :int1 FROM HU.STAFF" DISPLAY " WHERE EMPNAME < 'Fred';" * EXEC SQL SELECT COUNT(*) INTO :int1 FROM HU.STAFF * WHERE EMPNAME < 'Fred'; CALL "SUB26" USING SQLCODE SQLSTATE int1 MOVE SQLCODE TO SQL-COD PERFORM CHCKOK DISPLAY "int1 should be 3; its value is ", int1 if (int1 NOT = 3) then MOVE 0 TO flag END-IF DISPLAY "ROLLBACK WORK;" * EXEC SQL ROLLBACK WORK; CALL "SUB27" USING SQLCODE SQLSTATE MOVE SQLCODE TO SQL-COD PERFORM CHCKOK DISPLAY " " DISPLAY "DROP VIEW EXON CASCADE;" * EXEC SQL DROP VIEW EXON CASCADE; CALL "SUB28" USING SQLCODE SQLSTATE MOVE SQLCODE TO SQL-COD PERFORM CHCKOK DISPLAY " " DISPLAY "COMMIT WORK;" * EXEC SQL COMMIT WORK; CALL "SUB29" USING SQLCODE SQLSTATE MOVE SQLCODE TO SQL-COD PERFORM CHCKOK DISPLAY " " if ( flag = 1 ) then DISPLAY " *** pass *** " * EXEC SQL INSERT INTO HU.TESTREPORT * VALUES('0848','pass','MCO'); CALL "SUB30" USING SQLCODE SQLSTATE MOVE SQLCODE TO SQL-COD else DISPLAY " dml153.sco *** fail *** " * EXEC SQL INSERT INTO HU.TESTREPORT * VALUES('0848','fail','MCO'); CALL "SUB31" USING SQLCODE SQLSTATE MOVE SQLCODE TO SQL-COD COMPUTE errcnt = errcnt + 1 END-IF DISPLAY "===============================================" * EXEC SQL COMMIT WORK; CALL "SUB32" USING SQLCODE SQLSTATE MOVE SQLCODE TO SQL-COD ******************** END TEST0848 ******************** **** TESTER MAY CHOOSE TO INSERT CODE FOR errcnt > 0 STOP RUN. * **** Procedures for PERFORM statements *Test SQLCODE and SQLSTATE for normal completion. CHCKOK. 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 NORMSQ NOT = "00000") then MOVE 0 TO flag END-IF if (NORMSQ = "00000" AND NORMSQ NOT = SQLSTATE) then DISPLAY "Valid implementation-defined SQLSTATE accepted." END-IF . 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 NORMSQ MOVE 3 TO norm1 *subclass begins in position 3 of char array NORMSQ *valid subclass begins with 5-9, I-Z, end of ALPNUM table PERFORM VARYING norm2 FROM 14 BY 1 UNTIL norm2 > 36 if (NORMSQX(norm1) = ALPNUM(norm2)) then MOVE "0" TO NORMSQX(norm1) END-IF END-PERFORM *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) if (NORMSQ = SQLSTATE) then GO TO EXIT-NOSUBCLASS END-IF MOVE 4 TO norm1 *examining position 4 of char array NORMSQ *valid characters are 0-9, A-Z PERFORM VARYING norm2 FROM 1 BY 1 UNTIL norm2 > 36 if (NORMSQX(norm1) = ALPNUM(norm2)) then MOVE "0" TO NORMSQX(norm1) END-IF END-PERFORM MOVE 5 TO norm1 *valid characters are 0-9, A-Z *examining position 5 of char array NORMSQ PERFORM VARYING norm2 FROM 1 BY 1 UNTIL norm2 > 36 if (NORMSQX(norm1) = ALPNUM(norm2)) then MOVE "0" TO NORMSQX(norm1) END-IF END-PERFORM *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 (NORMSQX(1) = "0" AND NORMSQX(2) = "1") then MOVE "0" TO NORMSQX(2) END-IF . EXIT-NOSUBCLASS. EXIT. ¤ Dauer der Verarbeitung: 0.20 Sekunden (vorverarbeitet) ¤ |
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.Bot Zugriff |
