so view should be created in the current library (*CURLIB) for the job.
As an aside the current schema does NOT match the *CURLIB.
The *CURLIB is set by executing the CHGCURLIB CL command. The current
library is added to the library before the user part of the library list.
Unqualified specified objects are created in the QGPL library when System
Naming is used, except a CURRENT SCHEMA is set.
For setting the CURRENT SCHEMA the SET CURRENT SCHEMA or SET SCHEMA command
must be performed.
If a CURRENT SCHEMA is explicitly set, the library list is no longer
searched, instead all unqualified specified objects are taken from the
CURRENT SCHEMA, which not even have to be in the library list.
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
-----Ursprüngliche Nachricht-----
Von: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von
CRPence
Gesendet: Sunday, 22.5 2016 02:10
An: midrange-l@xxxxxxxxxxxx
Betreff: failing CREATE VIEW with unqualified long-name using VALUES clause
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]
--
Regards, Chuck
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at
http://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
midrange.com
