MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » June 2008

Re: Display Query File utility



fixed

One problem that we found when using this utility is that it would only work if system security level was 30 or below.

Have you changed this now to 40? Perhaps when upgrading to V5R3?

Colin
----- Original Message ----- From: "Steve Scheele" <Steve.Scheele@xxxxxxxxxxxxxxx>
To: <MIDRANGE-L@xxxxxxxxxxxx>
Sent: Thursday, June 05, 2008 5:51 AM
Subject: FW: Display Query File utility


G'day All,



I used to use a couple of really nifty little
utilities that I got from "System i NEWS" or "iSeries NEWS" or whatever
its' name was at the time called "Display Query Dependencies" (DSPQRYD)
and "Display Query Files" (DSPQRYF) for dumping *QRYDFN objects details
to files and reporting on them. I hadn't used these commands since
early last year when our system was at V5R2. I tried the latter
recently (we're now on V5R3) and I received no output other than the
following error message:



"An error has occurred with the
RTVQRYF program."



The joblog reveals the following:



436 - OVRDBF FILE(DSPQRYFTMP) TOFILE(SSCHEELE/DSPQRYFTST)


439 - CALL PGM(DSPQRYF01R)


Ownership of object QRYDMP in QTEMP type *USRSPC changed.


Ownership of object DMPFIL in QTEMP type *FILE changed.


File DMPFIL created in library QTEMP.


1 objects saved from library MAQPAP.


Object DMPFIL in QTEMP type *FILE deleted.


Receiver value too small to hold result.


448 - RCVMSG MSGTYPE(*EXCP) MSGDTA(&MSGDTA) MSGID(&MSGID)
MSGF(&MSGF)

MSGFLIB(&MSGFLIB)


450 - SNDPGMMSG MSGID(CPF9898) MSGF(QSYS/QCPFMSG) MSGDTA('An
error has

occurred with the RTVQRYF program') MSGTYPE(*ESCAPE)


An error has occurred with the RTVQRYF program.


An error has occurred with the RTVQRYF program.




I'm wondering if anyone else out there uses this
utility and has encountered this problem and if so what they did to fix
it. If not, any ideas what I might do to replicate the functionality I
had?



Steve Scheele

Systems Manager



CPI Group




######################################################################
This message may contain privileged and confidential information
intended only for the use of the recipient/s named above. If you are
not the intended recipient of this message you are hereby notified
that any use, dissemination, distribution or reproduction of this
message is prohibited. If you have received this message in error
please notify the sender immediately. Any views expressed in this
message are those of the individual sender and may not necessarily
reflect the views of the company. Whilst all internet e-mails are
scanned for known viruses, no liability will be accepted for any
damage caused by this email or its attachments due to viruses,
interference, interception, corruption or unauthorised access.
######################################################################
--
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.









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