| products/sources/formale sprachen/Java/openjdk-20-36_src/test/jdk/tools/jar/modularJar/src/foo/jdk/test/foo/ |
|
Quellcode-Bibliothek
© Kompilation durch diese Firma
[Weder Korrektheit noch Funktionsfähigkeit der Software werden zugesichert.]
Datei: xts741.cob Sprache: Unknown
|
IDENTIFICATION DIVISION.
PROGRAM-ID. XTS741. ENVIRONMENT DIVISION. CONFIGURATION SECTION. SOURCE-COMPUTER. xyz. OBJECT-COMPUTER. xyz. DATA DIVISION. WORKING-STORAGE SECTION. * Standard COBOL (file "XTS741.SCO") calling SQL * procedures in file "XTS741.MCO". *Copyright 1995 National Computing Centre Limited *and Computer Logic R&D S.A *on behalf of the CTS5 SQL2 Project. *All rights reserved. *The CTS5 SQL2 Project is sponsored by the European Community. * *The National Computing Centre Limited and Computer Logic R&D *have given permission to NIST to distribute this program *over the World Wide Web in order to promote SQL standards. *DISCLAIMER: *This program was reviewed by employees of NIST for *conformance to the SQL standards. *NIST assumes no responsibility for any party's use of *this program. **************************************************************** * * COMMENT SECTION * * SQL VALIDATION TEST SUITE V6.0 * * XTS741.SCO TEST7041 * WRITTEN BY: Nickos Backalidis * TRANSLATED AUTOMATICALLY FROM EMBEDDED COBOL BY CHRIS SCHANZLE * * COUNT(ALL NULLIF...) with generated nulls * * REFERENCES * 6.5 -- <Set function specification> * 6.9 FT.2 <case abbreviation> * 6.9 SR.1 * 6.5 SR.1 * F#44 -- Intermediate set function * F#5 -- DATETIME data types * F#26 -- CASE expression * * DATE LAST ALTERED 18/12/95 CTS5 Hand-over Test * * Cleanups and fixes by V. Kogakis 08/12/95 * Print timestamp * Include Files * Define NOSUBCLASS/CHCKOK at test beginning * * QA STATUS : FC * * Revised by DWF 1996-02-09 * Clean up status checks * Removed coding rules violations * Removed field widths in printfs **************************************************************** * 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 cncols PIC S9(9) DISPLAY SIGN LEADING SEPARATE. * 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 "CTS1 " TO uid CALL "AUTHID" USING uid MOVE "not logged in, not" TO uidx * EXEC SQL SELECT USER INTO :uidx FROM CTS1.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, xts741.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 TEST7041 ******************* MOVE 1 TO flag DISPLAY " TEST7041" DISPLAY " COUNT(ALL NULLIF...) with generated Nulls " DISPLAY " References:" DISPLAY " 6.5 -- DISPLAY " 6.9 FT.2 DISPLAY " 6.9 SR.1 " DISPLAY " F#44 -- Intermediate set function " DISPLAY " F#5 -- DATETIME data types " DISPLAY " F#26 -- CASE expression " DISPLAY " - - - - - - - - - - - - - - - - - - -" *initialise error reporting variables COMPUTE SQLCODE = -1 MOVE "xxxxx" TO SQLSTATE *use an empty table EMPTY740 from the standard schema *and count every column and check returned results *Ensure that the table EMPTY740 is empty. * EXEC SQL DELETE FROM EMPTY740; CALL "SUB3" USING SQLCODE SQLSTATE MOVE SQLCODE TO SQL-COD *Insert six rows in table EMPTY740 in order to test *variations of COUNT ALL NULLIF DISPLAY "INSERT INTO EMPTY740" DISPLAY "VALUES('NICKOS','NICK',NULL,116,TIME'18:00:00');" * EXEC SQL INSERT INTO EMPTY740 * VALUES('NICKOS','NICK',NULL,116,TIME'18:00:00'); CALL "SUB4" USING SQLCODE SQLSTATE MOVE SQLCODE TO SQL-COD PERFORM CHCKOK DISPLAY " " DISPLAY "INSERT INTO EMPTY740" DISPLAY "VALUES('MARIA',NULL,NULL,NULL,TIME'12:00:00');" * EXEC SQL INSERT INTO EMPTY740 * VALUES('MARIA',NULL,NULL,NULL,TIME'12:00:00'); CALL "SUB5" USING SQLCODE SQLSTATE MOVE SQLCODE TO SQL-COD PERFORM CHCKOK DISPLAY " " DISPLAY "INSERT INTO EMPTY740" DISPLAY "VALUES('KILLER','BUCK',NULL,127,TIME'09:30:30');" * EXEC SQL INSERT INTO EMPTY740 * VALUES('KILLER','BUCK',NULL,127,TIME'09:30:30'); CALL "SUB6" USING SQLCODE SQLSTATE MOVE SQLCODE TO SQL-COD PERFORM CHCKOK DISPLAY " " DISPLAY "INSERT INTO EMPTY740" DISPLAY "VALUES('JOYCE',NULL,NULL,17,TIME'15:43:52');" * EXEC SQL INSERT INTO EMPTY740 * VALUES('JOYCE',NULL,NULL,17,TIME'15:43:52'); CALL "SUB7" USING SQLCODE SQLSTATE MOVE SQLCODE TO SQL-COD PERFORM CHCKOK DISPLAY " " DISPLAY "INSERT INTO EMPTY740" DISPLAY "VALUES('ANGIE','TREE',NULL,7,TIME'12:53:13');" * EXEC SQL INSERT INTO EMPTY740 * VALUES('ANGIE','TREE',NULL,7,TIME'12:53:13'); CALL "SUB8" USING SQLCODE SQLSTATE MOVE SQLCODE TO SQL-COD PERFORM CHCKOK DISPLAY " " DISPLAY "INSERT INTO EMPTY740" DISPLAY "VALUES('BUCK','BUCK',NULL,12,TIME'16:29:22');" * EXEC SQL INSERT INTO EMPTY740 * VALUES('BUCK','BUCK',NULL,12,TIME'16:29:22'); CALL "SUB9" USING SQLCODE SQLSTATE MOVE SQLCODE TO SQL-COD PERFORM CHCKOK DISPLAY " " *Commit the rows insertion DISPLAY "COMMIT WORK;" * EXEC SQL COMMIT WORK; CALL "SUB10" USING SQLCODE SQLSTATE MOVE SQLCODE TO SQL-COD PERFORM CHCKOK DISPLAY " " *1st case for testing COUNT ALL NULLIF *we expect a zero so initialise host to value <> 0 MOVE 9 TO cncols DISPLAY "SELECT COUNT(ALL NULLIF ('Nickos','Nickos ')) " DISPLAY "INTO :cncols FROM EMPTY740;" * EXEC SQL SELECT COUNT(ALL NULLIF ('Nickos','Nickos ')) * INTO :cncols FROM EMPTY740; CALL "SUB11" USING SQLCODE SQLSTATE cncols MOVE SQLCODE TO SQL-COD DISPLAY "Count should be 0; its value is ", cncols DISPLAY "SQLSTATE should be 01003; its value is ", SQLSTATE if (cncols NOT = 0 OR SQLSTATE NOT = "01003") then MOVE 0 TO flag END-IF DISPLAY " " *2nd case for testing COUNT ALL NULLIF MOVE 0 TO cncols DISPLAY "SELECT COUNT(ALL NULLIF (COL_1,'JANET'))" DISPLAY "INTO :cncols FROM EMPTY740;" * EXEC SQL SELECT COUNT(ALL NULLIF (COL_1,'JANET')) * INTO :cncols FROM EMPTY740; CALL "SUB12" USING SQLCODE SQLSTATE cncols MOVE SQLCODE TO SQL-COD PERFORM CHCKOK DISPLAY "Count should be 6; its value is ", cncols if (cncols NOT = 6) then MOVE 0 TO flag END-IF DISPLAY " " *3rd case MOVE 0 TO cncols DISPLAY "SELECT COUNT(ALL NULLIF ('NICKOS',COL_1)) " DISPLAY "INTO :cncols FROM EMPTY740;" * EXEC SQL SELECT COUNT(ALL NULLIF ('NICKOS',COL_1)) * INTO :cncols FROM EMPTY740; CALL "SUB13" USING SQLCODE SQLSTATE cncols MOVE SQLCODE TO SQL-COD DISPLAY "Count should be 5; its value is ", cncols DISPLAY "SQLSTATE should be 01003; its value is ", SQLSTATE if (cncols NOT = 5 OR SQLSTATE NOT = "01003") then MOVE 0 TO flag END-IF DISPLAY " " *4th SELECT statement: single row *5th SELECT statement: single row DISPLAY "SELECT COUNT(ALL NULLIF (COL_2,COL_1))" DISPLAY "INTO :cncols FROM EMPTY740;" MOVE 0 TO cncols * EXEC SQL SELECT COUNT(ALL NULLIF (COL_2,COL_1)) * INTO :cncols FROM EMPTY740; CALL "SUB14" USING SQLCODE SQLSTATE cncols MOVE SQLCODE TO SQL-COD DISPLAY "Count should be 3; its value is ", cncols DISPLAY "SQLSTATE should be 01003; its value is ", SQLSTATE if (cncols NOT = 3 OR SQLSTATE NOT = "01003") then MOVE 0 TO flag END-IF DISPLAY " " *6th SELECT statement: single row MOVE 0 TO cncols DISPLAY "SELECT COUNT(ALL NULLIF (COL_4,COL_3))" DISPLAY "INTO :cncols FROM EMPTY740;" * EXEC SQL SELECT COUNT(ALL NULLIF (COL_4,COL_3)) * INTO :cncols FROM EMPTY740; CALL "SUB15" USING SQLCODE SQLSTATE cncols MOVE SQLCODE TO SQL-COD DISPLAY "Count should be 5; its value is ", cncols DISPLAY "SQLSTATE should be 01003; its value is ", SQLSTATE if (cncols NOT = 5 OR SQLSTATE NOT = "01003") then MOVE 0 TO flag END-IF DISPLAY " " *7th SELECT statement: single row MOVE 0 TO cncols DISPLAY "SELECT COUNT(ALL NULLIF (COL_5,TIME'12:00:00'))" DISPLAY "INTO :cncols FROM EMPTY740;" * EXEC SQL SELECT COUNT(ALL NULLIF (COL_5,TIME'12:00:00')) * INTO :cncols FROM EMPTY740; CALL "SUB16" USING SQLCODE SQLSTATE cncols MOVE SQLCODE TO SQL-COD DISPLAY "Count should be 5; its value is ", cncols DISPLAY "SQLSTATE should be 01003; its value is ", SQLSTATE if (cncols NOT = 5 OR SQLSTATE NOT = "01003") then MOVE 0 TO flag END-IF DISPLAY " " DISPLAY "ROLLBACK WORK;" * EXEC SQL ROLLBACK WORK; CALL "SUB17" USING SQLCODE SQLSTATE MOVE SQLCODE TO SQL-COD PERFORM CHCKOK DISPLAY " " DISPLAY "DELETE FROM EMPTY740;" * EXEC SQL DELETE FROM EMPTY740; CALL "SUB18" USING SQLCODE SQLSTATE MOVE SQLCODE TO SQL-COD PERFORM CHCKOK DISPLAY " " DISPLAY "COMMIT WORK;" * EXEC SQL COMMIT WORK; CALL "SUB19" USING SQLCODE SQLSTATE MOVE SQLCODE TO SQL-COD PERFORM CHCKOK DISPLAY " " *now record results if ( flag = 1 ) then DISPLAY " xts741.mco *** pass *** " * EXEC SQL INSERT INTO CTS1.TESTREPORT * VALUES('7041','pass','MCO'); CALL "SUB20" USING SQLCODE SQLSTATE MOVE SQLCODE TO SQL-COD else DISPLAY " xts741.mco *** fail *** " * EXEC SQL INSERT INTO CTS1.TESTREPORT * VALUES('7041','fail','MCO'); CALL "SUB21" USING SQLCODE SQLSTATE MOVE SQLCODE TO SQL-COD COMPUTE errcnt = errcnt + 1 END-IF DISPLAY "========================================" * EXEC SQL COMMIT WORK; CALL "SUB22" USING SQLCODE SQLSTATE MOVE SQLCODE TO SQL-COD ******************** END TEST7041 ******************** **** 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.4 Sekunden (vorverarbeitet) ] |