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




In the data provider set the connection time out value to 0 (zero)

http://www.itjungle.com/fhg/fhg071305-story03.html




-----Original Message-----
From: systemidotnet-bounces@xxxxxxxxxxxx [mailto:systemidotnet-bounces@xxxxxxxxxxxx] On Behalf Of S.Kavitha
Sent: Wednesday, November 16, 2011 1:51 PM
To: systemidotnet@xxxxxxxxxxxx
Subject: [SystemiDotNet] Error on OPnqryf CPI432C while invoking SP from .NET

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.



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.