MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » June 2014

Re: Problem creating a view



fixed

-----CRPence <CRPbottle@xxxxxxxxx> wrote: -----
To: midrange-l@xxxxxxxxxxxx
From: CRPence <CRPbottle@xxxxxxxxx>
Date: 03/13/2014 01:09PM
Subject: Re: Problem creating a view

FWiW: The most complete contextual information [outside of the SQL
request itself per the CREATE VIEW statement not being a CL
command-request; i.e. not being a request-message] is available from the
spooled output either from a DSPJOBLOG OUTPUT(*PRINT) taken with the
specified JOB() having LOG(4 0 *SECLVL) in effect...

I am resurrecting this thread because it has again reared it's ugly head. Once again, the view does not exist (though it did just yesterday), and I am currently unable to recreate it, or any of the dependent views (which also do not currently exist).

Here is the job log:

*NONE Request 06/12/14 16:44:20.871236 QUICMD QSYS 0543 QUICMD QSYS 0543
Message . . . . : -RUNSQLSTM SRCSTMF('/home/mmurphy/SQL
Source/Buckhorn/ocrmhv.sql') COMMIT(*NONE) NAMING(*SQL)
CPF6968 Escape 40 06/12/14 16:44:20.960475 QJOSNDJE QSYS 06F9 QDBCRTME QSYS 05CB
Message . . . . : Journal entry cannot be associated with file OCRMHV.
Cause . . . . . : The specified journal entry cannot be associated with file
OCRMHV in library BKNTEST because of one of the following: -- File OCRMHV in
library BKNTEST is not a data base file. -- File OCRMHV in library BKNTEST
is a logical file that is not journaled. Recovery . . . : Correct the
error and try your request again.
CPF9999 Escape 40 06/12/14 16:44:20.960944 QMHUNMSG *N QSQCRTV QSYS *STMT
To module . . . . . . . . . : QSQCRTV
To procedure . . . . . . . : QSQCRTV
Statement . . . . . . . . . : 11527
Message . . . . : Function check. CPF6968 unmonitored by QDBCRTME at
statement *N, instruction X'05CB'.
Cause . . . . . : An escape exception message was sent to a program which
did not monitor for that message. The full name of the program to which the
unmonitored message was sent is QDBCRTME . At the time the message was sent
the program was stopped at higher level language statement number(s) *N. If
more than one statement number is shown, the program was a bound program.
Optimization does not allow a single statement number to be determined. If
*N is shown as a value, it means the actual value was not available.
Recovery . . . : See the low level messages previously listed to locate
the cause of the function check. Correct any errors, and then try the
request again.
SQL0901 Diagnostic 50 06/12/14 16:44:20.988277 QSQCRTV QSYS *STMT QSQCRTV QSYS *STMT
From module . . . . . . . . : QSQCRTV
From procedure . . . . . . : CLEANUP
Statement . . . . . . . . . : 21089
To module . . . . . . . . . : QSQCRTV
To procedure . . . . . . . : CLEANUP
Statement . . . . . . . . . : 21089
Message . . . . : SQL system error.
Cause . . . . . : An SQL system error has occurred. The current SQL
statement cannot be completed successfully. The error will not prevent
other SQL statements from being processed. Previous messages may indicate
that there is a problem with the SQL statement and SQL did not correctly
diagnose the error. The previous message identifier was K b . Internal
error type 4266 has occurred. If precompiling, processing will not continue
beyond this statement. Recovery . . . : See the previous messages to
determine if there is a problem with the SQL statement. To view the
messages, use the DSPJOBLOG command if running interactively, or the WRKJOB
command to view the output of a precompile. An application program
receiving this return code may attempt further SQL statements. Correct any
errors and try the request again.
SQL9010 Diagnostic 30 06/12/14 16:44:21.013534 QSQSCHEM QSYS 1780 QUIMNDRV QSYS 0610
Message . . . . : RUNSQLSTM command failed.
Cause . . . . . : Errors were found while processing the source for the
RUNSQLSTM command. The listing print file is *N in *N. Recovery . . . :
Review the messages on the listing. Either correct the problems or specify
a higher severity on the ERRLVL parameter. Try the request again. Technical
description . . . . . . . . : The RUNSQLSTM command found errors with a
severity greater than the requested ERRLVL.
*NONE Request 06/12/14 16:44:25.703937 QUICMD QSYS 0543 QUICMD QSYS 0543
Message . . . . : -dspjoblog output(*print)

From QRECOVERY.QSQ901S
FAILRSN: 4266
STMTTEXT: create or replace view ocrmhv/nas/nselect * from ocrh/nunion all /nselect * from ocmh
VRM: V7R1M0
DBGROUP: SF99701 23
MSGS:
MESSAGE: SQL0901 F/QSQCRTV-MODULE/QSQCRTV-PROCEDURE/CLEANUP-STMT/21089 T/QSQCRTV-MODULE/QSQCRTV-PROCEDURE/CLEANUP-STMT/21089
MESSAGE: CPF9999 F/QMHUNMSG-INS/0000 T/QSQCRTV-MODULE/QSQCRTV-PROCEDURE/QSQCRTV-STMT/11527
MESSAGE: CPF6968 F/QJOSNDJE-INS/06F9 T/QJOSNDJE-INS/06F9
MESSAGE: SQL7910 F/QSQXIT-MODULE/QSQXIT-PROCEDURE/QSQXIT-STMT/9500 T/QSQXIT-INS/9500
MESSAGE: CPI3E04 F/QRWSARDB-MODULE/QRWSARDB-PROCEDURE/DISCMSG-STMT/24711 T/QSQXIT-MODULE/QSQXIT-PROCEDURE/QSQXIT-STMT/9163
MESSAGE: SQL9010 F/QSQSCHEM-INS/1780 T/QSQSCHEM-INS/1780
MESSAGE: SQL7956 F/QSQRUN3-MODULE/QSQINS-PROCEDURE/CLEANUP-STMT/31359 T/QSQRUN3-MODULE/QSQINS-PROCEDURE/CLEANUP-STMT/31359
MESSAGE: SQL7913 F/QSQSBAS-MODULE/QSQHDCLS-PROCEDURE/SQHRDCLS-STMT/4029 T/QSQSBAS-MODULE/QSQCLSCR-PROCEDURE/SQCLOSE-STMT/6766
MESSAGE: SQL7912 F/QSQRUN3-MODULE/QSQOPEN-PROCEDURE/SNDINFOMSG-STMT/38036 T/QSQRUN3-MODULE/QSQINS-PROCEDURE/SQL_Insert-STMT/10699
MESSAGE: CPI434B F/QQQQUERY-MODULE/QQQQUERY-PROCEDURE/CLEANUP-STMT/32703 T/QSQRUN3-MODULE/QSQOPEN-PROCEDURE/FULL_OPEN-STMT/36645
MESSAGE: CPI4339 F/QQQSRVI1-MODULE/QQQAINI-PROCEDURE/GETMSGTXT-STMT/10481 T/QQQSRVE1-MODULE/QQQGINI-PROCEDURE/QQGETINIOPTIONS-STMT/1235
MESSAGE: CPI4329 F/QQQIMPLE-MODULE/QQQIMPLE-PROCEDURE/QQQSNDPMSG-STMT/2397 T/QSQRUN3-MODULE/QSQOPEN-PROCEDURE/FULL_OPEN-STMT/36645
MESSAGE: CPI4323 F/QQQVAP-MODULE/QQQVAP-PROCEDURE/QQQSNDPMSG-STMT/2844 T/QSQRUN3-MODULE/QSQOPEN-PROCEDURE/FULL_OPEN-STMT/36645
MESSAGE: CPI434A F/QQQQUERY-MODULE/QQQQUERY-PROCEDURE/QQQQUERY-STMT/13701 T/QSQRUN3-MODULE/QSQOPEN-PROCEDURE/FULL_OPEN-STMT/36645
MESSAGE: CPI4339 F/QQQSRVI1-MODULE/QQQAINI-PROCEDURE/GETMSGTXT-STMT/10481 T/QQQSETUP-MODULE/QQQSETUP-PROCEDURE/SETQIS-STMT/12485
MESSAGE: SQL7967 F/QSQRUN1-MODULE/QSQPREP-PROCEDURE/CLEANUP-STMT/11082 T/QSQRUN1-MODULE/QSQPREP-PROCEDURE/CLEANUP-STMT/11082
MESSAGE: SQL0901 F/QSQCRTV-MODULE/QSQCRTV-PROCEDURE/CLEANUP-STMT/21089 T/QSQCRTV-MODULE/QSQCRTV-PROCEDURE/CLEANUP-STMT/21089
MESSAGE: CPF9999 F/QMHUNMSG-INS/0000 T/QSQCRTV-MODULE/QSQCRTV-PROCEDURE/QSQCRTV-STMT/11527
MESSAGE: CPF6968 F/QJOSNDJE-INS/06F9 T/QJOSNDJE-INS/06F9
MESSAGE: CPI4323 F/QQQQUERY-MODULE/QQQQUERY-PROCEDURE/QQQSNDPMSG-STMT/4761 T/QDBCRTFI-MODULE/QDBCRTFI-PROCEDURE/QQQUERY_MACROS-STMT/40784
MESSAGE: CPI4339 F/QQQSRVI1-MODULE/QQQAINI-PROCEDURE/GETMSGTXT-STMT/10481 T/QQQSETUP-MODULE/QQQSETUP-PROCEDURE/SETQIS-STMT/12485
MESSAGE: CPI4339 F/QQQSRVI1-MODULE/QQQAINI-PROCEDURE/GETMSGTXT-STMT/10481 T/QQQSETUP-MODULE/QQQSETUP-PROCEDURE/SETQIS-STMT/12485
MESSAGE: SQL790F F/QSQXCUTE-MODULE/QSQXCUTE-PROCEDURE/CLEANUP-STMT/28939 T/QSQXCUTE-MODULE/QSQXCUTE-PROCEDURE/CLEANUP-STMT/28939
MESSAGE: SQL7971 F/QSQCONN-MODULE/QSQCONN-PROCEDURE/CLEANUP-STMT/22469 T/QSQCONN-MODULE/QSQCONN-PROCEDURE/CLEANUP-STMT/22469
MESSAGE: SQL7969 F/QSQCONN-MODULE/QSQCONN-PROCEDURE/MESSAGE_IN_JOBLOG-STMT/15781 T/QSQXCUTE-MODULE/QSQXCUTE-PROCEDURE/QSQXCUTE-STMT/12506
MESSAGE: CPI4339 F/QQQSRVI1-MODULE/QQQAINI-PROCEDURE/GETMSGTXT-STMT/10481 T/QQQSRVE1-MODULE/QQQGINI-PROCEDURE/QQGETINIOPTIONS-STMT/1235
MESSA





Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot 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 here. If you have questions about this, please contact