|
Quellcode-Bibliothek
© Kompilation durch diese Firma
[Weder Korrektheit noch Funktionsfähigkeit der Software werden zugesichert.]
Datei:
xts728.cob
Sprache: Cobol
|
|
IDENTIFICATION DIVISION.
PROGRAM-ID. XTS728.
ENVIRONMENT DIVISION.
CONFIGURATION SECTION.
SOURCE-COMPUTER. xyz.
OBJECT-COMPUTER. xyz.
DATA DIVISION.
WORKING-STORAGE SECTION.
* EMBEDDED COBOL (file "XTS728.PCO")
*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
*
* XTS728.PCO
* WRITTEN BY: Nickos Backalidis
* TRANSLATED AUTOMATICALLY FROM EMBEDDED C BY CHRIS SCHANZLE
*
* Flagging Full SQL - <null predicate> with two-col row
*
* REFERENCES
* 8.6 -- <null predicate>
* 7.1 -- <row value constructor>
* 7.1 LR.1a -- Intermediate SQL restriction which prohibits
* the use of more than one <row value
* constructor element> in a <row value
* constructor> that is not simply contained in
* a <table value constructor>
* F#37 -- Intermediate SQL Flagging.
*
* DATE LAST ALTERED 12/12/95 CTS5 Hand-over Test
*
* Cleanups and fixes by V. Kogakis 04/12/95
*
* QA Status: QA Check
*
* Revised by DWF 1996-02-01
* Fixed char string lengths
* Deleted extraneous reference to 7.1 SR.1
* Removed CHCKOK after no data delete
****************************************************************
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 c_ch1 PIC X(10).
01 c_ch2 PIC X(10).
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 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, xts728.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 TEST7028 *******************
MOVE 1 TO flag
DISPLAY " TEST7028"
DISPLAY " Flagging,Full SQL, with
- " two-col row"
DISPLAY " References "
DISPLAY " 8.6 -- "
DISPLAY " 7.1 -- "
DISPLAY " 7.1 LR.1a Intermediate SQL restriction which
- " prohibits"
DISPLAY " the use of more than one
- " constructor"
DISPLAY " element> in a
- " constructor> that is not"
DISPLAY " simply contained in a
- " constructor>"
DISPLAY " F#37 -- Intermediate SQL Flagging."
DISPLAY " - - - - - - - - - - - - - - - - - - -"
*Initialise error reporting variables
COMPUTE SQLCODE = -1
MOVE "xxxxx" TO SQLSTATE
*use tables TABLE728a and TABLE728b from the standard schema
*Make sure that table728b is empty
DISPLAY "DELETE FROM CTS1.TABLE728b;"
EXEC SQL DELETE FROM CTS1.TABLE728b END-EXEC
MOVE SQLCODE TO SQL-COD
*execute the following query
*if a syntax error does not occur then all the
*columns of TABLE728a that are not NULL *
*will be copied in TABLE728b
DISPLAY "INSERT INTO CTS1.TABLE728b"
DISPLAY "SELECT * FROM CTS1.TABLE728a"
DISPLAY "WHERE (C1,C2) IS NOT NULL;"
EXEC SQL INSERT INTO CTS1.TABLE728b
SELECT * FROM CTS1.TABLE728a
WHERE (C1,C2) IS NOT NULL END-EXEC
MOVE SQLCODE TO SQL-COD
PERFORM CHCKOK
DISPLAY " "
*initialise host variables
MOVE "xxxxxxxxxx" TO c_ch1
MOVE "xxxxxxxxxx" TO c_ch2
*Use two select statement(s):single row and examine the
*contents of table CTS1.728b
*1st select
DISPLAY "SELECT COL_1,COL_2 INTO :c_ch1, :c_ch2"
DISPLAY "FROM CTS1.TABLE728b"
DISPLAY "WHERE COL_1 = 'NICKOS' AND COL_2 = 'GEORGE';"
EXEC SQL SELECT COL_1,COL_2 INTO :c_ch1,:c_ch2
FROM CTS1.TABLE728b
WHERE COL_1 = 'NICKOS' AND COL_2 = 'GEORGE' END-EXEC
MOVE SQLCODE TO SQL-COD
PERFORM CHCKOK
DISPLAY "COL_1 should be NICKOS; its value is ", c_ch1
DISPLAY "COL_2 should be GEORGE; its value is ", c_ch2
if (c_ch1 NOT = "NICKOS" OR c_ch2 NOT = "GEORGE")
then
MOVE 0 TO flag
END-IF
DISPLAY " "
*initialise host variables
MOVE "xxxxxxxxxx" TO c_ch1
MOVE "xxxxxxxxxx" TO c_ch2
*2nd SELECT
DISPLAY "SELECT COL_1,COL_2 INTO :c_ch1, :c_ch2"
DISPLAY "FROM CTS1.TABLE728b"
DISPLAY "WHERE COL_1 = 'HARRY' AND COL_2 = 'TANIA';"
EXEC SQL SELECT COL_1,COL_2 INTO :c_ch1,:c_ch2
FROM CTS1.TABLE728b
WHERE COL_1 = 'HARRY' AND COL_2 = 'TANIA' END-EXEC
MOVE SQLCODE TO SQL-COD
PERFORM CHCKOK
DISPLAY "COL_1 should be HARRY; its value is ", c_ch1
DISPLAY "COL_2 should be TANIA; its value is ", c_ch2
if (c_ch1 NOT = "HARRY" OR c_ch2 NOT = "TANIA")
then
MOVE 0 TO flag
END-IF
DISPLAY " "
DISPLAY "ROLLBACK WORK;"
EXEC SQL ROLLBACK WORK END-EXEC
MOVE SQLCODE TO SQL-COD
PERFORM CHCKOK
DISPLAY " "
*record results
if ( flag = 1 ) then
DISPLAY " xts728.pco *** pass *** "
EXEC SQL INSERT INTO CTS1.TESTREPORT
VALUES('7028','pass','PCO') END-EXEC
MOVE SQLCODE TO SQL-COD
DISPLAY "Intermediate SQL extension"
DISPLAY " with two-col row"
DISPLAY "executed successfully."
DISPLAY "Vendor must demonstrate Intermediate Flagger
- " WARNING"
else
DISPLAY " xts728.pco *** NOGO *** "
EXEC SQL INSERT INTO CTS1.TESTREPORT
VALUES('7028','NOGO','PCO') END-EXEC
MOVE SQLCODE TO SQL-COD
DISPLAY "Vendor does not support fully "
DISPLAY "Intermediate SQL extension "
DISPLAY "Support with two-col row is not
- " required"
END-IF
DISPLAY "========================================"
EXEC SQL COMMIT WORK END-EXEC
MOVE SQLCODE TO SQL-COD
******************** END TEST7028 ********************
**** 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.5 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.
|
|
|
