**************************************************************** * * COMMENT SECTION * * DATE 1994/12/27 EMBEDDED 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. * * FLG013.PCO * WRITTEN BY: David W. Flater * TRANSLATED AUTOMATICALLY FROM EMBEDDED C BY CHRIS SCHANZLE * * This routine tests an extension to FIPS SQL. * * REFERENCES * XOP710.PC -- X/O,Acceptance of correctly placed SQLCA * (Colin O'Driscoll) * X/Open CAE SQL 8.1.1 * ****************************************************************
*Declarations for SQLCODE and SQLSTATE are omitted since they *might conflict with the SQLCA declaration.
* This is part of the extension being tested. EXECSQL INCLUDE SQLCA END-EXEC.
01 SQL-COD PIC S9(9) DISPLAYSIGNLEADINGSEPARATE.
PROCEDUREDIVISION.
P0.
MOVE"FLATER "TO uid CALL"AUTHID"USING uid MOVE"not logged in, not"TO uidx EXECSQLSELECT USER INTO :uidx FROM HU.ECCO END-EXEC MOVE SQLCODE TO SQL-COD EXECSQL ROLLBACK WORK END-EXEC MOVE SQLCODE TO SQL-COD if (uid NOT = uidx) then DISPLAY"ERROR: User ", uid " expected. User ", uidx "
- " connected" STOPRUN END-IF MOVE 0 TO errcnt
DISPLAY "SQL Test Suite, V6.0, Embedded COBOL, flg013.pco" DISPLAY "59-byte ID" DISPLAY"TEd Version #" *date_time print ACCEPT TO-DAY FROMDATE ACCEPT THE-TIME FROMTIME DISPLAY"Date run YYMMDD: " TO-DAY " at hhmmssff: " THE-TIME
******************** BEGIN TEST0833 ******************* MOVE 1 TO flag
DISPLAY" SQLCODE = -1;" MOVE -1 TO SQLCODE DISPLAY"SELECT USER INTO :uidx FROM HU.ECCO;" EXECSQLSELECT USER INTO :uidx FROM HU.ECCO END-EXEC MOVE SQLCODE TO SQL-COD DISPLAY"SQLCODE is ", SQL-COD
DISPLAY"ROLLBACK WORK;" EXECSQL ROLLBACK WORK END-EXEC MOVE SQLCODE TO SQL-COD
DISPLAY" SQL extension INCLUDE SQLCA used successfully." DISPLAY" Vendor must demonstrate FIPS flagger WARNING." EXECSQLINSERTINTO HU.TESTREPORT
VALUES('0833','pass','PCO') END-EXEC MOVE SQLCODE TO SQL-COD