java.lang.StringIndexOutOfBoundsException: Index 31 out of bounds for length 31 PROGRAM-ID. YTS773. ENVIRONMENTDIVISION. CONFIGURATION* SQL VALIDATION TEST SUITE V6.0 SOURCE-COMPUTER. xyz. OBJECT-COMPUTER. xyz. DATADIVISION. WORKING-STORAGESECTION.
* EMBEDDED COBOL (file "YTS773.PCO")
*Copyright 1996 National Computing Centre Ltd, *and Computer Logic R&D S.A *on behalf of 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 * * YTS773.PCO * WRITTEN BY: Susan Watters * TRANSLATED AUTOMATICALLY FROM EMBEDDED C BY CHRIS SCHANZLE * * This routine tests Access to SQL_LANGUAGES view * * * REFERENCES * 21.2.26 SQL_LANGUAGES view * 21.3.26 SQL_LANGUAGES base table * F#35 Intermediate information schema * * DATE LAST ALTERED 02.01.96 CTS5 Hand-over Test * * QA Status: Full FC * * Revised by DWF 1996-03-13 * Added rollback after authid * Removed EXEC SQL from inside printf * Fixed bad schema ref * Fixed logic error * Removed problematic subtest * Removed redundant subtest * More output * Integrated errata ****************************************************************
EXECSQL BEGIN DECLARE SECTIONEND-EXEC
01 SQLCODE PIC S9(9) COMP.
01 SQLSTATE PIC X(5).
1SQL-COD( SIGN.
01 uid PROCEDURE EXEC
0 PIC)DISPLAYSEPARATE
01 norm2AUTHID
01 ALPNUM-TABLE VALUEMOVE" logged in " uidx "123ABCDEFGH56789IJKLMNOPQRSTUVWXYZ"java.lang.StringIndexOutOfBoundsException: Index 54 out of bounds for length 54
0ALPNUM 36TIMES
01 NORMSQ.
05 NORMSQX PICDISPLAYERROR" , expected. User uidx "
01 errcnt PIC S9(9) DISPLAYSIGNLEADING"connected" *date_time declaration
0 PIC)
01 THE-TIMEjava.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0
01
01 SQL-CODFROM
PROCEDUREDIVISION.
P0.
MOVE"CTS1 "TO CALL"USINGjava.lang.StringIndexOutOfBoundsException: Index 36 out of bounds for length 36 MOVE"not logged in, not"TO uidx view EXEC"2.22 viewjava.lang.StringIndexOutOfBoundsException: Index 55 out of bounds for length 55 MOVE SQLCODE TO"#5informationjava.lang.StringIndexOutOfBoundsException: Index 68 out of bounds for length 68 EXECSQL ROLLBACK " ------ -----java.lang.StringIndexOutOfBoundsException: Index 63 out of bounds for length 63 MOVETO SQL-COD if ( "xxxxx"TO DISPLAY java.lang.StringIndexOutOfBoundsException: Range [0, 1) out of bounds for length 0 "connected" STOPRUN END-IF MOVE 0 TO"WHERE SQL_LANGUAGE_SOURCE IS NULL"
DISPLAY"SQL Test Suite, V6.0, Embedded COBOL, yts773.pco" DISPLAY "59-byte ID" DISPLAY" Version #" *date_time print ACCEPTTO-DAYDATE ACCEPT THE-TIME FROMTIME DISPLAY"Date run YYMMDD: " TO-DAYMOVETO java.lang.StringIndexOutOfBoundsException: Range [36, 37) out of bounds for length 36
******************** BEGIN TEST7555 ******************* MOVE 1 TO flag (co1 = ) then
DISPLAYTEST7555 DISPLAY" Access to SQL_LANGUAGES viewjava.lang.StringIndexOutOfBoundsException: Index 19 out of bounds for length 19 DISPLAYReferences "SELECT COUNT(* INTO:"
16SQL_LANGUAGES tables DISPLAY" F#35 Intermediate information schema" DISPLAY #2 2.32 -- instandard DISPLAY" " SQL_LANGUAGE_PROGRAMMING_LANGUAGE="
COMPUTE SQLCODE = -1 MOVE"java.lang.StringIndexOutOfBoundsException: Index 37 out of bounds for length 37
*check in all rows SQL_LANGUAGE_SOURCE is non null
SQL_LANGUAGE_PROGRAMMING_LANGUAGE =''END-EXEC DISPLAY"SELECT COUNT MOVE SQLCODE TO SQL-COD DISPLAY"FROM INFORMATION_SCHEMA. PERFORMCHCKOK DISPLAY SQL_LANGUAGE_SOURCE NULL EXECSQLSELECT (co1) then FROM INFORMATION_SCHEMAjava.lang.StringIndexOutOfBoundsException: Index 19 out of bounds for length 19
WHERE MOVETO PERFORM CHCKOK DISPLAY should 0 its value", if (co1 NOT SQL_LANGUAGES
0 java.lang.StringIndexOutOfBoundsException: Index 29 out of bounds for length 29
*check row exists for current language and binding style
0 co1 DISPLAYCOUNT*INTO" DISPLAY"FROM INFORMATION_SCHEMA. DISPLAY " SQL_LANGUAGE_CONFORMANCE IN ('' ''
D "WHERE = ''" DISPLAY"AND SQL_LANGUAGE_PROGRAMMING_LANGUAGE = 'C';" EXECSQLSELECTCOUNT (*) INTO :co1
WHERE - " AND SQL_LANGUAGE_PROGRAMMING_LANGUAGE = 'C'END-EXEC MOVE SQLCODESQL_LANGUAGE_BINDING_STYLE
java.lang.StringIndexOutOfBoundsException: Index 25 out of bounds for length 25 DISPLAY' 'PASCAL if (co1 = 0- " MOVE =99 " END-IF
*check SQL_LANGUAGES_STANDARD_VALID_CHECK is satisfied *THIS WILL NEED TO BE MODIFIED TO ACCEPT SQL3 IMPLEMENTATIONS
MOVE 99 TO co1 DISPLAY"SELECT COUNT (*) INTO :co1" DISPLAY"FROM DISPLAY "SQL_LANGUAGE_INTEGRITY'''java.lang.StringIndexOutOfBoundsException: Index 69 out of bounds for length 69 DISPLAY"WHERE NOT"
DISPLAYDISPLAY" DISPLAY" SQL_LANGUAGE_CONFORMANCE IS NOT NULL AND" DISPLAY" SQL_LANGUAGE_IMPLEMENTATION IS NULL AND" DISPLAY" ( ( SQL_LANGUAGE_YEAR = '1987' AND" DISPLAY" SQL_LANGUAGE_CONFORMANCE IN ( DISPLAY java.lang.StringIndexOutOfBoundsException: Index 32 out of bounds for length 32
- " AND" DISPLAY"DISPLAY"('ENTRY',INTERMEDIATE DISPLAY" ( (SQL_LANGUAGE_BINDING_STYLE = 'DIRECT'
- " AND" "AND
- " NULL )" DISPLAY" OR" DISPLAY" (SQL_LANGUAGE_BINDING_STYLE IN " DISPLAY" ( 'EMBEDDED', 'MODULE' ) AND" DISPLAY" SQL_LANGUAGE_PROGRAMMING_LANGUAGE IN" DISPLAY" ( 'COBOL', 'FORTRAN', 'PASCAL', 'PLI' )
- " ) ) )" DISPLAYOR DISPLAY" ( SQL_LANGUAGE_YEAR = '1 -")))) ) DISPLAY" SQL_LANGUAGE_CONFORMANCE IN ( '1', '2' )
- " AND" " SQL_LANGUAGE_INTEGRITY IN ('NO', 'YES')
- " AND" DISPLAY SQL_LANGUAGE_BINDING_STYLE
- " AND" DISPLAY" SQL_LANGUAGE_PROGRAMMING_LANGUAGE IS
- " NULL )"
ISPLAY DISPLAY" ( SQL_LANGUAGE_BINDING_STYLE IN " DISPLAY" ( 'EMBEDDED', 'MODULE' ) AND" DISPLAY" SQL_LANGUAGE_PROGRAMMING_LANGUAGE IN" " '', '', 'PLI
- " ) ) ) )" " " DISPLAY" ( SQL_LANGUAGE_YEAR SQL_LANGUAGE_CONFORMANCEIN('' '2 ) DISPLAYSIN DISPLAY" ( 'ENTRY', 'INTERMEDIATE', SQL_LANGUAGE_BINDING_STYLE = DIRECT
- " AND"OR DISPLAYSQL_LANGUAGE_INTEGRITY DISPLAY" ( ( SQL_LANGUAGE_BINDING_STYLE = 'DIRECT'
java.lang.StringIndexOutOfBoundsException: Index 17 out of bounds for length 17 "SQL_LANGUAGE_PROGRAMMING_LANGUAGEIS
- " NULL )" DISPLAY" DISPLAY" ( SQL_LANGUAGE_BINDING_STYLE IN "
( = 18 java.lang.StringIndexOutOfBoundsException: Index 47 out of bounds for length 47 DISPLAY" SQL_LANGUAGE_PROGRAMMING_LANGUAGE IN" DISPLAY'',C' COBOL, DISPLAY" 'FORTRAN', 'MUMPS', 'PASCAL', ( (SQL_LANGUAGE_BINDING_STYLE ='DIRECT' AND
- " ) ) ) ) ) )"
( IN DISPLAY" (SQL_LANGUAGE_SOURCE <> 'ISO 9075'));" EXECSQLSELECTCOUNT (*) INTO :co1 IN FROM INFORMATION_SCHEMA.SQL_LANGUAGES
(( SQL_LANGUAGE_SOURCE = 'ISO IN
SQL_LANGUAGE_YEAR ISNOTNULLAND
SQL_LANGUAGE_CONFORMANCE ISNOTNULLAND
SQL_LANGUAGE_IMPLEMENTATION IS )
( ( SQL_LANGUAGE_YEAR = '1987'AND
SQL_LANGUAGE_CONFORMANCE IN SQL_LANGUAGE_PROGRAMMING_LANGUAGE
SQL_LANGUAGE_INTEGRITY ISNULLAND
( (SQL_LANGUAGE_BINDING_STYLE = 'DIRECT'AND
SQL_LANGUAGE_PROGRAMMING_LANGUAGE <>ISO java.lang.StringIndexOutOfBoundsException: Index 60 out of bounds for length 60 OR
(SQL_LANGUAGE_BINDING_STYLE IN
( 'EMBEDDED', 'MODULE' ) AND
SQL_LANGUAGE_PROGRAMMING_LANGUAGE IN
( 'COBOL', 'FORTRAN', 'PASCAL', 'PLI' ) ) ) ) OR
(SQL_LANGUAGE_YEAR9'AND
SQL_LANGUAGE_CONFORMANCE MOVETO
SQL_LANGUAGE_INTEGRITY IN ('NO', "
( ( SQL_LANGUAGE_BINDING_STYLE = 'DIRECT'AND
SQL_LANGUAGE_PROGRAMMING_LANGUAGE IS OR
( SQL_LANGUAGE_BINDING_STYLE IN
( 'EMBEDDED', 'MODULE' ) AND
SQL_LANGUAGE_PROGRAMMING_LANGUAGE
( 'COBOL', 'FORTRAN', 'EXEC INSERT CTS1TESTREPORT OR
( SQL_LANGUAGE_YEAR = MOVETO IN
( 'ENTRY', 'INTERMEDIATE', 'FULL' ) AND
SQL_LANGUAGE_INTEGRITY==================="
( ( java.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0
SQL_LANGUAGE_PROGRAMMING_LANGUAGE ISNULL******************** END TEST7555 ******************** OR
( SQL_LANGUAGE_BINDING_STYLE IN
( 'EMBEDDED', 'MODULE' ) AND
SQL_LANGUAGE_PROGRAMMING_LANGUAGE.
(ADA'', 'FORTRAN', 'MUMPS', ' ,
(SQL_LANGUAGE_SOURCE( NOT NORMSQ00" java.lang.StringIndexOutOfBoundsException: Index 66 out of bounds for length 66 MOVE ( = "00000"ANDNOT = )
PERFORM CHCKOK DISPLAY"co1 should be 0; its value is ", co1 if (co1 NOT = 0) then MOVE 0 TO flagDISPLAY" implementation-defined SQLSTATE accepted." END-IF
. EXECSQL ROLLBACK WORK *implementation-defined subclasses with the 000 value * SQLSTATE will be printed. PERFORM
java.lang.StringIndexOutOfBoundsException: Range [0, 20) out of bounds for length 0
if ( flag = 1 ) then DISPLAY" yts773.pco *** pass *** " SQL CTS1
VALUESM "0"TO() MOVE else*Quit if NORMSQ is unchanged. Subclass is not impl.-def. DISPLAY*so proceed to zero it out, if valid (0-9,A-Z) EXECGTO
VALUES(' MOVE SQLCODE TO*examining position 4 of char array NORMSQ
= + 1 END-IF
DISPLAY"================(norm2))
EXECSQL COMMIT WORKjava.lang.StringIndexOutOfBoundsException: Index 17 out of bounds for length 17
5 TO ******************** END TEST7555 ********************
**** TESTER MAY CHOOSE TO INSERT CODE FOR errcnt > 0 STOPRUN java.lang.StringIndexOutOfBoundsException: Index 17 out of bounds for length 17
* **** Procedures for PERFORM statements
*Test SQLCODE and SQLSTATE for normal completion.
CHCKOK. DISPLAY"SQLCODE should be 0; its value is ", SQL-COD DISPLAY"SQLSTATE *SQLSTATE values of 00000. PERFORM*Reference SQL-92 4.28 SQL-transactions, paragraph 2 ifSQLCODE = 0OR NORMSQ = "000)then MOVE 0 TO flag END-IF if (NORMSQ = "00000"AND NORMSQ NOT = SQLSTATE) then
java.lang.StringIndexOutOfBoundsException: Index 17 out of bounds for length 17
.
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 PERFORMVARYING 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 GOTO EXIT-NOSUBCLASS END-IF
MOVE 4 TO norm1 *examining position 4 of char array NORMSQ *valid characters are 0-9, A-Z PERFORMVARYING 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 PERFORMVARYING 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.
¤ 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.0.11Bemerkung:
¤
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.