× 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.



You can also use (6.1 or greater) the qsys2.override_qaqqini() stored procedure.

~Zach
-----Original Message-----
From: systemidotnet-bounces@xxxxxxxxxxxx [mailto:systemidotnet-bounces@xxxxxxxxxxxx] On Behalf Of Steve Richter
Sent: Wednesday, November 16, 2011 3:17 PM
To: .net use with the System i
Subject: Re: [SystemiDotNet] Error on OPnqryf CPI432C while invoking SP from .NET

try the CHGQRYA command in the job that is running the stored procedure.
The QRYTIMLMT parm. You can run it from the .NET side within the same database connections at the stored procedure.

-Steve



On Wed, Nov 16, 2011 at 1:50 PM, S.Kavitha <kavi8586@xxxxxxxxx> wrote:

Hi,

** **

I wrote a Stored procedure to execute a CLP CLPPGMNM in AS400 V6R1
Environment. This SP is being called in .NET environment to Execute
CLPPGMNM. ****

Am able to execute the SP in iSeries/directly as a program. But when
executed from .NET, the job abends in MSGW. Below is the Error Msg
provided. ****

** **

All access paths were considered for file JOINLF3. ****

Additional access path reason codes were used. ****

All access paths were considered for file JOINLF3. ****

Additional access path reason codes were used. ****

File JOINLF3 processed in join position 1. ****

File JOINLF3 processed in join position 2. ****

Temporary result file built for query.
****

Query exceeds specified time limit or storage limit.
****

Error occurred during processing of command.
****

Function check. CPF9899 unmonitored by CLPGMNM at statement 2200, ****

instruction X'0011'. ****

CPF9899 received by CLPGMNM at 2200. (C D I R) ****

** **

** **

Message ID . . . . . . : CPI432C Severity . . . . . . . :
00 ****

Message type . . . . . :
Information ****

Date sent . . . . . . : 11/14/11 Time sent . . . . . . :
02:17:50 ****


****

Message . . . . : All access paths were considered for file JOINLF3.
****

Cause . . . . . : The query optimizer considered all access paths built
over ****

member JOINLF3 of file JOINLF3 in library < LibraryName>.
****

The list below shows the access paths considered. If file
JOINLF3in
****

library LibraryName is a logical file then the access paths specified
are ****

actually built over member PF1 of physical file PF1 in library ****

LibraryName. Following each access path name in the list is a reason
code which ****

explains how the optimizer considered the access
path. ****

LibraryName /JOINLF3 0, LibraryName /PF1 4, LibraryName /LF1onPF1
11, ****

LibraryName / LF2onPF1 11, LibraryName / LF3onPF1 11, LibraryName /
LF4onPF1 11, ****

LibraryName / LF5onPF1 17, LibraryName / LF6onPF1 11, LibraryName /
LF7onPF1 17, ****

** **

Note: JOINLF3 is the Join LF using PF1 and PF2. LF1onPF1 is the
Logical File on PF1.****

** **

Please let me know your suggestions/inputs on this. Thanks in Advance.



--
S.Kavitha
--
This is the .net use with the System i (SystemiDotNet) mailing list To
post a message email: SystemiDotNet@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/systemidotnet
or email: SystemiDotNet-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/systemidotnet.

--
This is the .net use with the System i (SystemiDotNet) mailing list To post a message email: SystemiDotNet@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/systemidotnet
or email: SystemiDotNet-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at http://archive.midrange.com/systemidotnet.
NOTICE: This electronic mail message and any files transmitted with it are intended
exclusively for the individual or entity to which it is addressed. The message,
together with any attachment, may contain confidential and/or privileged information.
Any unauthorized review, use, printing, saving, copying, disclosure or distribution
is strictly prohibited. If you have received this message in error, please
immediately advise the sender by reply email and delete all copies.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

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.