**************************************************************** * * COMMENT SECTION * * DATE 1988/09/29 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. * * DML040.PCO * WRITTEN BY: HU YANPING * TRANSLATED AUTOMATICALLY FROM EMBEDDED C BY CHRIS SCHANZLE * * THIS ROUTINE TESTS SELECTION FROM TWO DIFFERENT * SCHEMAS (JOIN TWO DIFFERENT SCHEMAS). * * REFERENCES * AMERICAN NATIONAL STANDARD database language - SQL * X3.135-1989 * * Section 5.20 <from clause> * and Section 5.4 Names * ****************************************************************
PROCEDUREjava.lang.StringIndexOutOfBoundsException: Index 26 out of bounds for length 26
P0.
MOVEHU" java.lang.StringIndexOutOfBoundsException: Index 27 out of bounds for length 27 ""USING MOVE"not logged in USER INTO :uidx HUECCO SQL
USER INTO :uidx "ERROR:User"uid." if )then DISPLAY"DISPLAY "" DISPLAY"User " uidx " " STOPRUN END-IF
MOVE 0 TO" java.lang.StringIndexOutOfBoundsException: Range [22, 23) out of bounds for length 22 DISPLAYTO-DAY "SQL Test Suite, THE-TIME TIME DISPLAYDISPLAY"DaterunYYMMDD "at: " java.lang.StringIndexOutOfBoundsException: Index 71 out of bounds for length 71 DISPLAY
5- ID DISPLAY"TEd Version #" " " * date_time print * ACCEPT TO-DAY - - ----- " FROMTIME DISPLAY"Date run YYMMDD: " TO-DAY " at hhmmssff: " THE-TIME
******************** BEGIN TEST0209 *******************
DISPLAY" TEST0209 " SQLDECLARE FOR
- FROM., DISPLAY" COL1 < 20ANDGRADE>1 java.lang.StringIndexOutOfBoundsException: Index 55 out of bounds for length 55
EXECSQL SELECT * FROMEND-EXEC MOVE SQL-COD
EXECjava.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0
java.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0 FROM CUGINI.VTABLE "java.lang.StringIndexOutOfBoundsException: Index 14 out of bounds for length 14
WHERE COL1 TO
( = 6 =2)then
MOVE TO
MOVE 0 TO iii MOVE 1TO PERFORM P50 UNTIL i >VALUES'' java.lang.StringIndexOutOfBoundsException: Index 51 out of bounds for length 51
DISPLAY" ii = ", ii ", iii = ", iii " "
DISPLAY correct6iii
- " "
EXECSQL ROLLBACK WORK END-EXEC MOVE SQLCODE TO SQL-COD DD TO
if
java.lang.StringIndexOutOfBoundsException: Range [0, 13) out of bounds for length 0
VALUESpass MOVE SQLCODE TO SQL-COD
java.lang.StringIndexOutOfBoundsException: Index 15 out of bounds for length 15 DISPLAY EXEC EXECSQL X :, :EMPNO1 ADD 1 TO errcnt MOVE SQLCODE TO SQL-COD iTOii
DISPLAY"=== " = " = "" "
DISPLAY" "
EXECSQL COMMIT WORK END-EXEC MOVE SQLCODE TO SQL-COD ******************** END TEST0209 *******************
**** TESTER MAY CHOOSE TO INSERT CODE FOR errcnt > 0 STOPRUN.
* **** Procedures for PERFORM statements
P50. EXECSQL FETCH X INTO :COL2, :EMPNO1, :GRADE1 END-EXEC MOVE SQLCODE TO SQL-COD if (SQLCODE = 0) then MOVE i TO ii COMPUTE iii = iii + COL2 DISPLAY" COL2 = ", COL2 ", GRADE1 = ", GRADE1 " " END-IF ADD 1 TO i
.
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.