************************************************************** * * COMMENT SECTION * * DATE 1988/09/14 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. * * COB006.PCO * WRITTEN BY: S Hurwitz * * This routine tests how the SQL language handles * the placement of comments within SQL statements. * * * REFERENCES * AMERICAN NATIONAL STANDARD database language - SQL * X3.135-1989 * SECTION ANNEX A. <embedded SQL host program> * Snytax Rule 3. ***************************************************************
*log into database move"HU"to uid. CALL"AUTHID"USING uid. MOVE"not logged in, not"TO uidx EXECSQLSELECT
USER INTO :uidx FROM HU.ECCO END-EXEC if (uid NOT = uidx) then DISPLAY"ERROR: User " uid " expected." DISPLAY"User " uidx " connected." DISPLAY" " STOPRUN END-IF
MOVE 0 TO errcnt DISPLAY "SQL Test Suite, V6.0, Embedded COBOL, cob006.pco" DISPLAY" " DISPLAY "59-byte ID" DISPLAY"TEd Version #" DISPLAY" " * date_time print * ACCEPT TO-DAY FROMDATE ACCEPT THE-TIME FROMTIME DISPLAY"Date run YYMMDD: " TO-DAY " at hhmmssff: " THE-TIME
EXECSQLINSERT ************ comment comment comment ******************* INTO TEXT132 *********** This is a test for the rules ****************
VALUES ('TEST0207 TESTS SQL WITH COMMENTS INTERSPERSED') *********** of SQL statements and comments *********** END-EXEC. *********** interspersed in the SQL language. ***********
EXECSQLSELECT *********** comment comment comment *********************
TEXXT INTO :OUT132 FROM TEXT132 *********** comment comment comment ********************* END-EXEC.
******************** END TEST0207 ********************* ******************************************************** **** TESTER MAY CHOOSE TO INSERT CODE FOR errcnt > 0 STOPRUN. *********************************************************
¤ Dauer der Verarbeitung: 0.11 Sekunden
(vorverarbeitet)
¤
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.