× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



If anyone else cares; I can not open a PMR, so no matter if I care.

Env: v7r1 [IBM i 7.1] TL15317\TC15317 includes SI58126 with QSQRCHK

Setup: CREATE VIEW with no table-references, (*SYS) system-naming in effect, current schema = DEFAULT [i.e. *LIBL], alternative name without FOR SYSTEM name [long-name] so a system-name must be generated, no schema name as qualifier [i.e. unqualified] view-name so view should be created in the current library (*CURLIB) for the job.

Actual statement:

//DATA FILE(RSS_INLINE) FILETYPE(*SRC) ENDCHAR('//')
create view curlib_trickery
(intcol) as ( values(1) )
;
//

Actual joblog:
*NONE Request 05/21/16 18:31:39.137583
QSPSBMJB *N QCMD
Message . . . . : -RUNSQLSTM SRCFILE(RSS_INLINE) SRCMBR(ONLY)
COMMIT(*NONE) NAMING(*SYS)
MCH3601 Escape 40 05/21/16 18:31:39.178571
< esNotExist 0000C8 QSQRCHK
From Program . . . . . . . : Ex2401PtrDoesNotExist
To module . . . . . . . . . : QSQRCHK
To procedure . . . . . . . : GEN_TNAME
Statement . . . . . . . . . : 35048
Message . . . . : Pointer not set for location referenced.
Cause . . . . . : A pointer was used, either directly or as a basing pointer, that has not been set to an address.
SQL0901 Diagnostic 50 05/21/16 18:31:39.178759
QSQCRTV QSYS *STMT QSQCRTV
From module . . . . . . . . : QSQCRTV
From procedure . . . . . . : CLEANUP
Statement . . . . . . . . . : 21424
To module . . . . . . . . . : QSQCRTV
To procedure . . . . . . . : CLEANUP
Statement . . . . . . . . . : 21424
Message . . . . : SQL system error.
Cause . . . . . : ... The previous message identifier was MCH3601. Internal error type 6101 has occurred. ...

Symptoms:
msgMCH3601 t/qsqrchk f/Ex2401PtrDoesNotExist tm/qsqrchk
t/gen_Tname stmt/35048
msgsql0901 t/qsqcrtv f/qsqcrtv fm/qsqcrtv fp/cleanup
sqlstate 58004 sqlcode -901 et6101 [rc6101 ec6101]


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.