IDENTIFICATION DIVISION.
PROGRAM-ID. DML156.
ENVIRONMENT DIVISION.
CONFIGURATION SECTION.
SOURCE-COMPUTER. xyz.
OBJECT-COMPUTER. xyz.
DATA DIVISION.
WORKING-STORAGE SECTION.
* Standard COBOL (file "DML156.SCO") calling SQL
* procedures in file "DML156.MCO".
****************************************************************
*
* COMMENT SECTION
*
* DATE 1995/09/12 Module 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.
*
* DML156.SCO
* WRITTEN BY: David Flater
* TRANSLATED AUTOMATICALLY FROM EMBEDDED COBOL BY CHRIS SCHANZLE
*
* This routine tests Dynamic SQL.
*
* 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 dstmt PIC X(50).
01 longst PIC X(240).
* 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, dml156.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 TEST0855 *******************
MOVE 1 TO flag
DISPLAY " TEST0855"
DISPLAY " Dynamic SQL syntax errors"
DISPLAY "References:"
DISPLAY " 17.6 GR.4 -- Syntax errors on
- " statement>"
DISPLAY " COR2 17.6 GR.4 -- Many rules were changed"
DISPLAY " F# 1 -- Dynamic SQL"
DISPLAY " - - - - - - - - - - - - - - - - - - -"
COMPUTE SQLCODE = -1
MOVE "xxxxx" TO SQLSTATE
DISPLAY "It is possible that some of these statements will
- " be accepted"
DISPLAY "as vendor extensions."
*This is a SYNVIO test; however, the exception is specified in
*General Rules! Technically we are supposed to enforce these
*exceptions, but it's clearly not the Right Thing....
*4.a: generic garbage
DISPLAY "dstmt=""SELECT SELECT SELECT FETCH FETCH FETCH"""
MOVE "SELECT SELECT SELECT FETCH FETCH FETCH "
TO dstmt
DISPLAY "PREPARE S15611 FROM :dstmt;"
* EXEC SQL PREPARE S15611 FROM :dstmt;
CALL "SUB3" USING SQLCODE SQLSTATE dstmt
MOVE SQLCODE TO SQL-COD
DISPLAY "SQLCODE should be < 0; its value is ", SQL-COD
if (SQLCODE NOT < 0) then
MOVE 0 TO flag
END-IF
DISPLAY "SQLSTATE should be 42000; its value is ", SQLSTATE
PERFORM NOSUBCLASS THRU EXIT-NOSUBCLASS
if (NORMSQ NOT = "42000") then
MOVE 0 TO flag
END-IF
if (NORMSQ = "42000" AND NORMSQ NOT = SQLSTATE)
then
DISPLAY "Valid implementation-defined SQLSTATE accepted."
END-IF
DISPLAY " "
*4.b: ? as <value expression> simply contained in <select list>
DISPLAY "dstmt=""SELECT GRADE, ? FROM HU.STAFF"""
MOVE "SELECT GRADE, ? FROM HU.STAFF "
TO dstmt
DISPLAY "PREPARE S15612 FROM :dstmt;"
* EXEC SQL PREPARE S15612 FROM :dstmt;
CALL "SUB4" USING SQLCODE SQLSTATE dstmt
MOVE SQLCODE TO SQL-COD
DISPLAY "SQLCODE should be < 0; its value is ", SQL-COD
if (SQLCODE NOT < 0) then
MOVE 0 TO flag
END-IF
DISPLAY "SQLSTATE should be 42000; its value is ", SQLSTATE
PERFORM NOSUBCLASS THRU EXIT-NOSUBCLASS
if (NORMSQ NOT = "42000") then
MOVE 0 TO flag
END-IF
if (NORMSQ = "42000" AND NORMSQ NOT = SQLSTATE)
then
DISPLAY "Valid implementation-defined SQLSTATE accepted."
END-IF
DISPLAY " "
*4.c: dyadic operator on ? and ?
*Parens should not matter
DISPLAY "dstmt=""SELECT GRADE, ((?)+?) FROM HU.STAFF"""
MOVE "SELECT GRADE, ((?)+?) FROM HU.STAFF "
TO dstmt
DISPLAY "PREPARE S15613 FROM :dstmt;"
* EXEC SQL PREPARE S15613 FROM :dstmt;
CALL "SUB5" USING SQLCODE SQLSTATE dstmt
MOVE SQLCODE TO SQL-COD
DISPLAY "SQLCODE should be < 0; its value is ", SQL-COD
if (SQLCODE NOT < 0) then
MOVE 0 TO flag
END-IF
DISPLAY "SQLSTATE should be 42000; its value is ", SQLSTATE
PERFORM NOSUBCLASS THRU EXIT-NOSUBCLASS
if (NORMSQ NOT = "42000") then
MOVE 0 TO flag
END-IF
if (NORMSQ = "42000" AND NORMSQ NOT = SQLSTATE)
then
DISPLAY "Valid implementation-defined SQLSTATE accepted."
END-IF
DISPLAY " "
DISPLAY "dstmt=""SELECT GRADE FROM HU.STAFF WHERE GRADE = ?
- " * ?"""
MOVE "SELECT GRADE FROM HU.STAFF WHERE GRADE = ? * ? "
TO dstmt
DISPLAY "PREPARE S15613A FROM :dstmt;"
* EXEC SQL PREPARE S15613A FROM :dstmt;
CALL "SUB6" USING SQLCODE SQLSTATE dstmt
MOVE SQLCODE TO SQL-COD
DISPLAY "SQLCODE should be < 0; its value is ", SQL-COD
if (SQLCODE NOT < 0) then
MOVE 0 TO flag
END-IF
DISPLAY "SQLSTATE should be 42000; its value is ", SQLSTATE
PERFORM NOSUBCLASS THRU EXIT-NOSUBCLASS
if (NORMSQ NOT = "42000") then
MOVE 0 TO flag
END-IF
if (NORMSQ = "42000" AND NORMSQ NOT = SQLSTATE)
then
DISPLAY "Valid implementation-defined SQLSTATE accepted."
END-IF
DISPLAY " "
*4.d: +?, -?, EXTRACT (HOUR FROM ?)
DISPLAY "dstmt=""SELECT +? FROM HU.ECCO"""
MOVE "SELECT +? FROM HU.ECCO "
TO dstmt
DISPLAY "PREPARE S15614 FROM :dstmt;"
* EXEC SQL PREPARE S15614 FROM :dstmt;
CALL "SUB7" USING SQLCODE SQLSTATE dstmt
MOVE SQLCODE TO SQL-COD
DISPLAY "SQLCODE should be < 0; its value is ", SQL-COD
if (SQLCODE NOT < 0) then
MOVE 0 TO flag
END-IF
DISPLAY "SQLSTATE should be 42000; its value is ", SQLSTATE
PERFORM NOSUBCLASS THRU EXIT-NOSUBCLASS
if (NORMSQ NOT = "42000") then
MOVE 0 TO flag
END-IF
if (NORMSQ = "42000" AND NORMSQ NOT = SQLSTATE)
then
DISPLAY "Valid implementation-defined SQLSTATE accepted."
END-IF
DISPLAY " "
DISPLAY "dstmt=""SELECT (-?), C1 FROM USIG"""
MOVE "SELECT (-?), C1 FROM USIG "
TO dstmt
DISPLAY "PREPARE S15615 FROM :dstmt;"
* EXEC SQL PREPARE S15615 FROM :dstmt;
CALL "SUB8" USING SQLCODE SQLSTATE dstmt
MOVE SQLCODE TO SQL-COD
DISPLAY "SQLCODE should be < 0; its value is ", SQL-COD
if (SQLCODE NOT < 0) then
MOVE 0 TO flag
END-IF
DISPLAY "SQLSTATE should be 42000; its value is ", SQLSTATE
PERFORM NOSUBCLASS THRU EXIT-NOSUBCLASS
if (NORMSQ NOT = "42000") then
MOVE 0 TO flag
END-IF
if (NORMSQ = "42000" AND NORMSQ NOT = SQLSTATE)
then
DISPLAY "Valid implementation-defined SQLSTATE accepted."
END-IF
DISPLAY " "
*Even though I don't have a host language data type for datetime
*I can still try to prepare this!
DISPLAY "dstmt=""SELECT EXTRACT (HOUR FROM ?) FROM
- " HU.ECCO"""
MOVE "SELECT EXTRACT (HOUR FROM ?) FROM HU.ECCO "
TO dstmt
DISPLAY "PREPARE S15616 FROM :dstmt;"
* EXEC SQL PREPARE S15616 FROM :dstmt;
CALL "SUB9" USING SQLCODE SQLSTATE dstmt
MOVE SQLCODE TO SQL-COD
DISPLAY "SQLCODE should be < 0; its value is ", SQL-COD
if (SQLCODE NOT < 0) then
MOVE 0 TO flag
END-IF
DISPLAY "SQLSTATE should be 42000; its value is ", SQLSTATE
PERFORM NOSUBCLASS THRU EXIT-NOSUBCLASS
if (NORMSQ NOT = "42000") then
MOVE 0 TO flag
END-IF
if (NORMSQ = "42000" AND NORMSQ NOT = SQLSTATE)
then
DISPLAY "Valid implementation-defined SQLSTATE accepted."
END-IF
DISPLAY " "
*4.e ? as argument to a <set function specification>
DISPLAY "dstmt=""SELECT MAX (?), GRADE FROM HU.STAFF"""
MOVE "SELECT MAX (?), GRADE FROM HU.STAFF "
TO dstmt
DISPLAY "PREPARE S15617 FROM :dstmt;"
* EXEC SQL PREPARE S15617 FROM :dstmt;
CALL "SUB10" USING SQLCODE SQLSTATE dstmt
MOVE SQLCODE TO SQL-COD
DISPLAY "SQLCODE should be < 0; its value is ", SQL-COD
if (SQLCODE NOT < 0) then
MOVE 0 TO flag
END-IF
DISPLAY "SQLSTATE should be 42000; its value is ", SQLSTATE
PERFORM NOSUBCLASS THRU EXIT-NOSUBCLASS
if (NORMSQ NOT = "42000") then
MOVE 0 TO flag
END-IF
if (NORMSQ = "42000" AND NORMSQ NOT = SQLSTATE)
then
DISPLAY "Valid implementation-defined SQLSTATE accepted."
END-IF
DISPLAY " "
*4.f ? IS NULL
DISPLAY "dstmt=""SELECT COUNT(*) FROM HU.STAFF WHERE ? IS
- " NULL"""
MOVE "SELECT COUNT(*) FROM HU.STAFF WHERE ? IS NULL "
TO dstmt
DISPLAY "PREPARE S15618 FROM :dstmt;"
* EXEC SQL PREPARE S15618 FROM :dstmt;
CALL "SUB11" USING SQLCODE SQLSTATE dstmt
MOVE SQLCODE TO SQL-COD
DISPLAY "SQLCODE should be < 0; its value is ", SQL-COD
if (SQLCODE NOT < 0) then
MOVE 0 TO flag
END-IF
DISPLAY "SQLSTATE should be 42000; its value is ", SQLSTATE
PERFORM NOSUBCLASS THRU EXIT-NOSUBCLASS
if (NORMSQ NOT = "42000") then
MOVE 0 TO flag
END-IF
if (NORMSQ = "42000" AND NORMSQ NOT = SQLSTATE)
then
DISPLAY "Valid implementation-defined SQLSTATE accepted."
END-IF
DISPLAY " "
*4.g OVERLAPS (sometime, ?)
* EXEC SQL DELETE FROM CONCATBUF;
CALL "SUB12" USING SQLCODE SQLSTATE
MOVE SQLCODE TO SQL-COD
* EXEC SQL INSERT INTO CONCATBUF VALUES (
* 'SELECT COUNT(*) FROM HU.STAFF' ||
* ' WHERE (TIME ''07:04:07'', ' ||
* ' INTERVAL ''5'' HOUR) OVERLAPS' ||
* ' (TIME ''08:00:00'', ?)'
* );
CALL "SUB13" USING SQLCODE SQLSTATE
MOVE SQLCODE TO SQL-COD
* EXEC SQL SELECT ZZ INTO :longst FROM CONCATBUF;
CALL "SUB14" USING SQLCODE SQLSTATE longst
MOVE SQLCODE TO SQL-COD
DISPLAY "longst=""", longst, """"
DISPLAY "PREPARE S15619 FROM :longst;"
* EXEC SQL PREPARE S15619 FROM :longst;
CALL "SUB15" USING SQLCODE SQLSTATE longst
MOVE SQLCODE TO SQL-COD
DISPLAY "SQLCODE should be < 0; its value is ", SQL-COD
if (SQLCODE NOT < 0) then
MOVE 0 TO flag
END-IF
DISPLAY "SQLSTATE should be 42000; its value is ", SQLSTATE
PERFORM NOSUBCLASS THRU EXIT-NOSUBCLASS
if (NORMSQ NOT = "42000") then
MOVE 0 TO flag
END-IF
if (NORMSQ = "42000" AND NORMSQ NOT = SQLSTATE)
then
DISPLAY "Valid implementation-defined SQLSTATE accepted."
END-IF
DISPLAY " "
*4.h CASE statement -- possible Intermediate test
*4.i comparison and between predicates
DISPLAY "dstmt=""SELECT COUNT(*) FROM HU.STAFF WHERE ? =
- " ?"""
MOVE "SELECT COUNT(*) FROM HU.STAFF WHERE ? = ? "
TO dstmt
DISPLAY "PREPARE S1561A FROM :dstmt;"
* EXEC SQL PREPARE S1561A FROM :dstmt;
CALL "SUB16" USING SQLCODE SQLSTATE dstmt
MOVE SQLCODE TO SQL-COD
DISPLAY "SQLCODE should be < 0; its value is ", SQL-COD
if (SQLCODE NOT < 0) then
MOVE 0 TO flag
END-IF
DISPLAY "SQLSTATE should be 42000; its value is ", SQLSTATE
PERFORM NOSUBCLASS THRU EXIT-NOSUBCLASS
if (NORMSQ NOT = "42000") then
MOVE 0 TO flag
END-IF
if (NORMSQ = "42000" AND NORMSQ NOT = SQLSTATE)
then
DISPLAY "Valid implementation-defined SQLSTATE accepted."
END-IF
DISPLAY " "
DISPLAY "dstmt=""SELECT COUNT(*) FROM HU.STAFF WHERE (? >=
- " ?)"""
MOVE "SELECT COUNT(*) FROM HU.STAFF WHERE (? >= ?) "
TO dstmt
DISPLAY "PREPARE S1561B FROM :dstmt;"
* EXEC SQL PREPARE S1561B FROM :dstmt;
CALL "SUB17" USING SQLCODE SQLSTATE dstmt
MOVE SQLCODE TO SQL-COD
DISPLAY "SQLCODE should be < 0; its value is ", SQL-COD
if (SQLCODE NOT < 0) then
MOVE 0 TO flag
END-IF
DISPLAY "SQLSTATE should be 42000; its value is ", SQLSTATE
PERFORM NOSUBCLASS THRU EXIT-NOSUBCLASS
if (NORMSQ NOT = "42000") then
MOVE 0 TO flag
END-IF
if (NORMSQ = "42000" AND NORMSQ NOT = SQLSTATE)
then
DISPLAY "Valid implementation-defined SQLSTATE accepted."
END-IF
DISPLAY " "
* EXEC SQL DELETE FROM CONCATBUF;
CALL "SUB18" USING SQLCODE SQLSTATE
MOVE SQLCODE TO SQL-COD
* EXEC SQL INSERT INTO CONCATBUF VALUES (
* 'SELECT GRADE FROM HU.STAFF' ||
* ' WHERE ? NOT BETWEEN (?) AND (?) OR' ||
* ' GRADE < 12'
* );
CALL "SUB19" USING SQLCODE SQLSTATE
MOVE SQLCODE TO SQL-COD
* EXEC SQL SELECT ZZ INTO :longst FROM CONCATBUF;
CALL "SUB20" USING SQLCODE SQLSTATE longst
MOVE SQLCODE TO SQL-COD
DISPLAY "longst=""", longst, """"
DISPLAY "PREPARE S1561C FROM :longst;"
* EXEC SQL PREPARE S1561C FROM :longst;
CALL "SUB21" USING SQLCODE SQLSTATE longst
MOVE SQLCODE TO SQL-COD
DISPLAY "SQLCODE should be < 0; its value is ", SQL-COD
if (SQLCODE NOT < 0) then
MOVE 0 TO flag
END-IF
DISPLAY "SQLSTATE should be 42000; its value is ", SQLSTATE
PERFORM NOSUBCLASS THRU EXIT-NOSUBCLASS
if (NORMSQ NOT = "42000") then
MOVE 0 TO flag
END-IF
if (NORMSQ = "42000" AND NORMSQ NOT = SQLSTATE)
then
DISPLAY "Valid implementation-defined SQLSTATE accepted."
END-IF
DISPLAY " "
*4.j Table value constructors -- possible Full test
*4.k ? IN (?, ?)
DISPLAY "dstmt=""SELECT COUNT(*) FROM HU.STAFF WHERE ? IN
- " (?, ?)"""
MOVE "SELECT COUNT(*) FROM HU.STAFF WHERE ? IN (?, ?) "
TO dstmt
DISPLAY "PREPARE S1561D FROM :dstmt;"
* EXEC SQL PREPARE S1561D FROM :dstmt;
CALL "SUB22" USING SQLCODE SQLSTATE dstmt
MOVE SQLCODE TO SQL-COD
DISPLAY "SQLCODE should be < 0; its value is ", SQL-COD
if (SQLCODE NOT < 0) then
MOVE 0 TO flag
END-IF
DISPLAY "SQLSTATE should be 42000; its value is ", SQLSTATE
PERFORM NOSUBCLASS THRU EXIT-NOSUBCLASS
if (NORMSQ NOT = "42000") then
MOVE 0 TO flag
END-IF
if (NORMSQ = "42000" AND NORMSQ NOT = SQLSTATE)
then
DISPLAY "Valid implementation-defined SQLSTATE accepted."
END-IF
DISPLAY " "
*4.l Position expression -- possible Full test
*4.m Form of use, character translation -- Full
*4.n Fold -- Full
*4.o TRIM (? FROM X) TRIM (X FROM ?)
DISPLAY "dstmt=""SELECT TRIM (? FROM EMPNAME) FROM
- " HU.STAFF"""
MOVE "SELECT TRIM (? FROM EMPNAME) FROM HU.STAFF "
TO dstmt
DISPLAY "PREPARE S1561E FROM :dstmt;"
* EXEC SQL PREPARE S1561E FROM :dstmt;
CALL "SUB23" USING SQLCODE SQLSTATE dstmt
MOVE SQLCODE TO SQL-COD
DISPLAY "SQLCODE should be < 0; its value is ", SQL-COD
if (SQLCODE NOT < 0) then
MOVE 0 TO flag
END-IF
DISPLAY "SQLSTATE should be 42000; its value is ", SQLSTATE
PERFORM NOSUBCLASS THRU EXIT-NOSUBCLASS
if (NORMSQ NOT = "42000") then
MOVE 0 TO flag
END-IF
if (NORMSQ = "42000" AND NORMSQ NOT = SQLSTATE)
then
DISPLAY "Valid implementation-defined SQLSTATE accepted."
END-IF
DISPLAY " "
DISPLAY "dstmt=""SELECT * FROM HU.STAFF WHERE CITY = TRIM
- " (?)"""
MOVE "SELECT * FROM HU.STAFF WHERE CITY = TRIM (?) "
TO dstmt
DISPLAY "PREPARE S1561F FROM :dstmt;"
* EXEC SQL PREPARE S1561F FROM :dstmt;
CALL "SUB24" USING SQLCODE SQLSTATE dstmt
MOVE SQLCODE TO SQL-COD
DISPLAY "SQLCODE should be < 0; its value is ", SQL-COD
if (SQLCODE NOT < 0) then
MOVE 0 TO flag
END-IF
DISPLAY "SQLSTATE should be 42000; its value is ", SQLSTATE
PERFORM NOSUBCLASS THRU EXIT-NOSUBCLASS
if (NORMSQ NOT = "42000") then
MOVE 0 TO flag
END-IF
if (NORMSQ = "42000" AND NORMSQ NOT = SQLSTATE)
then
DISPLAY "Valid implementation-defined SQLSTATE accepted."
END-IF
DISPLAY " "
*4.p SUBSTRING (? FROM A FOR B)
DISPLAY "dstmt=""SELECT SUBSTRING (? FROM 2 FOR 2) FROM
- " HU.ECCO"""
MOVE "SELECT SUBSTRING (? FROM 2 FOR 2) FROM HU.ECCO "
TO dstmt
DISPLAY "PREPARE S1561G FROM :dstmt;"
* EXEC SQL PREPARE S1561G FROM :dstmt;
CALL "SUB25" USING SQLCODE SQLSTATE dstmt
MOVE SQLCODE TO SQL-COD
DISPLAY "SQLCODE should be < 0; its value is ", SQL-COD
if (SQLCODE NOT < 0) then
MOVE 0 TO flag
END-IF
DISPLAY "SQLSTATE should be 42000; its value is ", SQLSTATE
PERFORM NOSUBCLASS THRU EXIT-NOSUBCLASS
if (NORMSQ NOT = "42000") then
MOVE 0 TO flag
END-IF
if (NORMSQ = "42000" AND NORMSQ NOT = SQLSTATE)
then
DISPLAY "Valid implementation-defined SQLSTATE accepted."
END-IF
DISPLAY " "
*4.q P contains a <comment>
DISPLAY "dstmt=""SELECT * FROM HU.ECCO -- Output one
- " asterisk"""
MOVE "SELECT * FROM HU.ECCO -- Output one asterisk "
TO dstmt
DISPLAY "PREPARE S1561H FROM :dstmt;"
* EXEC SQL PREPARE S1561H FROM :dstmt;
CALL "SUB26" USING SQLCODE SQLSTATE dstmt
MOVE SQLCODE TO SQL-COD
DISPLAY "SQLCODE should be < 0; its value is ", SQL-COD
if (SQLCODE NOT < 0) then
MOVE 0 TO flag
END-IF
DISPLAY "SQLSTATE should be 42000; its value is ", SQLSTATE
PERFORM NOSUBCLASS THRU EXIT-NOSUBCLASS
if (NORMSQ NOT = "42000") then
MOVE 0 TO flag
END-IF
if (NORMSQ = "42000" AND NORMSQ NOT = SQLSTATE)
then
DISPLAY "Valid implementation-defined SQLSTATE accepted."
END-IF
DISPLAY " "
*4.r CASE statement -- possible Intermediate test
DISPLAY "COMMIT WORK;"
* EXEC SQL COMMIT WORK;
CALL "SUB27" USING SQLCODE SQLSTATE
MOVE SQLCODE TO SQL-COD
PERFORM CHCKOK
DISPLAY " "
if ( flag = 1 ) then
DISPLAY " *** pass *** "
* EXEC SQL INSERT INTO HU.TESTREPORT
* VALUES('0855','pass','MCO');
CALL "SUB28" USING SQLCODE SQLSTATE
MOVE SQLCODE TO SQL-COD
else
DISPLAY " dml156.mco *** fail *** "
* EXEC SQL INSERT INTO HU.TESTREPORT
* VALUES('0855','fail','MCO');
CALL "SUB29" USING SQLCODE SQLSTATE
MOVE SQLCODE TO SQL-COD
COMPUTE errcnt = errcnt + 1
END-IF
DISPLAY "==============================================="
* EXEC SQL COMMIT WORK;
CALL "SUB30" USING SQLCODE SQLSTATE
MOVE SQLCODE TO SQL-COD
******************** END TEST0855 ********************
**** 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.39 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.
|
