************************************************************** * * 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. * * COB005.PCO * WRITTEN BY: S Hurwitz * * This routine tests how the SQL language handles * the rules for the continuation of SQL lines with literals * from one line to the next. * * * 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, cob005.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 INTO TEXT132
VALUES ('TEST 0206 IS THE TEST FOR THE RULES OF THE CONT
- 'INUATION OF LINES FROM ONE LINE TO THE NEXT LI
- 'NE.....') END-EXEC.
EXECSQLSELECT
TEXXT INTO :OUT132 FROM TEXT132 END-EXEC.
******************** END TEST0206 ********************* **** TESTER MAY CHOOSE TO INSERT CODE FOR errcnt > 0 STOPRUN. *********************************************************
¤ Dauer der Verarbeitung: 0.15 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.