|
IDENTIFICATION DIVISION.
PROGRAM-ID. DML161.
ENVIRONMENT DIVISION.
CONFIGURATION SECTION.
SOURCE-COMPUTER. xyz.
OBJECT-COMPUTER. xyz.
DATA DIVISION.
WORKING-STORAGE SECTION.
* EMBEDDED COBOL (file "DML161.PCO")
****************************************************************
*
* COMMENT SECTION
*
* DATE 1996-05-23 EMBEDDED COBOL LANGUAGE
* 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.
*
* DML161.PCO
* WRITTEN BY: David Flater
* TRANSLATED AUTOMATICALLY FROM EMBEDDED C BY CHRIS SCHANZLE
*
* This routine tests user authorization.
*
* REFERENCES
* 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).
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 END-EXEC
MOVE SQLCODE TO SQL-COD
EXEC SQL ROLLBACK WORK END-EXEC
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, Embedded COBOL, dml161.pco"
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 TEST0861 *******************
MOVE 1 TO flag
DISPLAY " TEST0861 "
DISPLAY " CURRENT_USER, SESSION_USER, SYSTEM_USER"
DISPLAY "References:"
DISPLAY " F#32 -- User authorization"
DISPLAY " - - - - - - - - - - - - - - - - - - -"
COMPUTE SQLCODE = -1
MOVE "xxxxx" TO SQLSTATE
MOVE "xxxxxxxxxxxxxxxxxx" TO uidx
DISPLAY "SELECT CURRENT_USER INTO :uidx FROM HU.ECCO;"
EXEC SQL SELECT CURRENT_USER INTO :uidx FROM HU.ECCO
END-EXEC
MOVE SQLCODE TO SQL-COD
PERFORM CHCKOK
DISPLAY "uidx should be 'FLATER '; its value is
- " '", uidx, "'"
if (uidx NOT = "FLATER ") then
MOVE 0 TO flag
END-IF
MOVE "xxxxxxxxxxxxxxxxxx" TO uidx
DISPLAY "SELECT SESSION_USER INTO :uidx FROM HU.ECCO;"
EXEC SQL SELECT SESSION_USER INTO :uidx FROM HU.ECCO
END-EXEC
MOVE SQLCODE TO SQL-COD
PERFORM CHCKOK
DISPLAY "uidx should be 'FLATER '; its value is
- " '", uidx, "'"
if (uidx NOT = "FLATER ") then
MOVE 0 TO flag
END-IF
MOVE "xxxxxxxxxxxxxxxxxx" TO uidx
DISPLAY "SELECT SYSTEM_USER INTO :uidx FROM HU.ECCO;"
EXEC SQL SELECT SYSTEM_USER INTO :uidx FROM HU.ECCO
END-EXEC
MOVE SQLCODE TO SQL-COD
PERFORM CHCKOK
DISPLAY "uidx is '", uidx, "'"
DISPLAY "COMMIT WORK;"
EXEC SQL COMMIT WORK END-EXEC
MOVE SQLCODE TO SQL-COD
PERFORM CHCKOK
DISPLAY " "
if (flag = 1) then
DISPLAY " *** pass *** "
EXEC SQL INSERT INTO HU.TESTREPORT
VALUES('0861','pass','PCO') END-EXEC
MOVE SQLCODE TO SQL-COD
else
DISPLAY " dml161.pco *** fail *** "
EXEC SQL INSERT INTO HU.TESTREPORT
VALUES('0861','fail','PCO') END-EXEC
MOVE SQLCODE TO SQL-COD
COMPUTE errcnt = errcnt + 1
END-IF
EXEC SQL COMMIT WORK END-EXEC
MOVE SQLCODE TO SQL-COD
DISPLAY "================================================"
******************** END TEST0861 ********************
******************** BEGIN TEST0862 *******************
MOVE 1 TO flag
DISPLAY " TEST0862 "
DISPLAY " CURRENT_USER etc. with set session authid"
DISPLAY "References:"
DISPLAY " F#32 -- User authorization"
DISPLAY " - - - - - - - - - - - - - - - - - - -"
COMPUTE SQLCODE = -1
MOVE "xxxxx" TO SQLSTATE
DISPLAY "This test attempts to change session
- " authorizations. Because"
DISPLAY "authorizations are implementation-defined, this
- " test may need"
DISPLAY "modification. The following actions may help to
- " pass the test:"
DISPLAY " -- Change the initial authid to an authid with
- " DBA privileges"
DISPLAY " -- Insert code to work around
- " implementation-defined"
DISPLAY " authentication mechanisms (e.g. to reconnect
- " with a"
DISPLAY " different authid)."
DISPLAY "It might not be possible to change the session
- " authorization,"
DISPLAY "as explained in 16.4 GR.4. In this case, the
- " restrictions that"
DISPLAY "render it impossible should be documented and the
- " test assumed"
DISPLAY "to be passed."
DISPLAY "SET SESSION AUTHORIZATION 'SCHANZLE';"
EXEC SQL SET SESSION AUTHORIZATION 'SCHANZLE' END-EXEC
MOVE SQLCODE TO SQL-COD
PERFORM CHCKOK
DISPLAY " "
MOVE "xxxxxxxxxxxxxxxxxx" TO uidx
DISPLAY "SELECT CURRENT_USER INTO :uidx FROM HU.ECCO;"
EXEC SQL SELECT CURRENT_USER INTO :uidx FROM HU.ECCO
END-EXEC
MOVE SQLCODE TO SQL-COD
PERFORM CHCKOK
DISPLAY "uidx should be 'SCHANZLE '; its value is
- " '", uidx, "'"
if (uidx NOT = "SCHANZLE ") then
MOVE 0 TO flag
END-IF
MOVE "xxxxxxxxxxxxxxxxxx" TO uidx
DISPLAY "SELECT SESSION_USER INTO :uidx FROM HU.ECCO;"
EXEC SQL SELECT SESSION_USER INTO :uidx FROM HU.ECCO
END-EXEC
MOVE SQLCODE TO SQL-COD
PERFORM CHCKOK
DISPLAY "uidx should be 'SCHANZLE '; its value is
- " '", uidx, "'"
if (uidx NOT = "SCHANZLE ") then
MOVE 0 TO flag
END-IF
MOVE "xxxxxxxxxxxxxxxxxx" TO uidx
DISPLAY "SELECT SYSTEM_USER INTO :uidx FROM HU.ECCO;"
EXEC SQL SELECT SYSTEM_USER INTO :uidx FROM HU.ECCO
END-EXEC
MOVE SQLCODE TO SQL-COD
PERFORM CHCKOK
DISPLAY "uidx should be same as in test 0861; its value is
- " '", uidx, "'"
DISPLAY "COMMIT WORK;"
EXEC SQL COMMIT WORK END-EXEC
MOVE SQLCODE TO SQL-COD
PERFORM CHCKOK
DISPLAY " "
if (flag = 1) then
DISPLAY " *** pass *** "
EXEC SQL INSERT INTO HU.TESTREPORT
VALUES('0862','pass','PCO') END-EXEC
MOVE SQLCODE TO SQL-COD
else
DISPLAY " dml161.pco *** fail *** "
EXEC SQL INSERT INTO HU.TESTREPORT
VALUES('0862','fail','PCO') END-EXEC
MOVE SQLCODE TO SQL-COD
COMPUTE errcnt = errcnt + 1
END-IF
EXEC SQL COMMIT WORK END-EXEC
MOVE SQLCODE TO SQL-COD
DISPLAY "================================================"
******************** END TEST0862 ********************
**** 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.
[ Seitenstruktur0.3Drucken
etwas mehr zur Ethik
]
|
