RE: QRYOPTLIB

IBM ships a QAQQINI in library QSYS, but by default, the system tries to look 
for the QAQQINI file in QUSRSYS.  Using the CHGQRYA QRYOPTLIB() allows you to 
specify a specific version of QAQQINI in another library....

If you have never checked, WRKF *ALL/QAQQINI to see if the ini file is in 
QUSRSYS.  If not, you should use CRTDUPOBJ to copy the QSYS version to QUSRSYS.

hth,
Eric

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Hayes, Joe
Sent: Monday, November 20, 2006 1:07 PM
To: Midrange Systems Technical Discussion
Subject: RE: QRYOPTLIB


Actually, this is a J2EE system deployed to WAS 6.0.2.11 on I5 V5R4. 
Data Access is through jt400.
I haven't done anything that would lead to the creation of a QAQQINI
file that I know of.

Also, it's working fine on one system and not working on another.  I
think that we're just going to contact IBM.  My guess is that it's a
crazy config that we just can't find, or that it's a PTF problem.

Thanks :)

Joe


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Luis Rodriguez
Sent: Monday, November 20, 2006 12:48 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: QRYOPTLIB

Joseph,

Not on your request list but, maybe I can help...

Are you using an user-defined QAQQINI file? If so, how was
it generated? Please be aware that IBM warns again copying
this object with any other method than a CRTDUPOBJ, due to
the triggers attached to the file.

Hope this helps,

Regards,

Luis Rodriguez

--- midrange-l-request@xxxxxxxxxxxx wrote:

------------------------------

message: 3
date: Mon, 20 Nov 2006 11:01:01 -0600
from: "Hayes, Joe" <joe.hayes@xxxxxxxxxx>
subject: QRYOPTLIB


Joe, Chris, Rob, &Elvis

In searching the archives, I see that a problem was
discussed that
revolved around an error stating the following:

List or expression not valid for parameter QRYOPTLIB.
Error found on CHGQRYA command.
Errors found in command.
Trigger program or external routing detected and error.

I cannot find if/how it was ever resolved, and am
currently
experiencing.  Does anyone remember this or how it was
addressed?

Much appreciated.


Joseph Hayes 

Luis Rodriguez

IBM Certified Systems Expert
eServer i5 iSeries Technical Solutions


 
________________________________________________________________________
____________
Sponsored Link

Compare mortgage rates for today. 
Get up to 5 free quotes. 
Www2.nextag.com