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



<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" http://www.w3.org/TR/html4/strict.dtd";>
<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:p="urn:schemas-microsoft-com:office:powerpoint" xmlns:a="urn:schemas-microsoft-com:office:access" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema" xmlns:b="urn:schemas-microsoft-com:office:publisher" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet" xmlns:odc="urn:schemas-microsoft-com:office:odc" xmlns:oa="urn:schemas-microsoft-com:office:activation" xmlns:html="http://www.w3.org/TR/REC-html40"; xmlns:q="http://schemas.xmlsoap.org/soap/envelope/"; xmlns:rtc="http://microsoft.com/officenet/conferencing"; xmlns:d="DAV:" xmlns:repl="http://schemas.microsoft.com/repl/"; xmlns:mt="http://schemas.microsoft.com/sharepoint/soap/meetings/"; xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml"; xmlns:ppda="http://www.passport.com/NameSpace.xsd"; xmlns:ois="http://schemas.microsoft.com/sharepoint/soap/ois/"; xmlns:dir="http://schemas.microsoft.com/sharepoint/soap/directory/"; xmlns:ds="http://www.w3.org/2000/09/xmldsig#"; xmlns:dsp="http://schemas.microsoft.com/sharepoint/dsp"; xmlns:udc="http://schemas.microsoft.com/data/udc"; xmlns:xsd="http://www.w3.org/2001/XMLSchema"; xmlns:sub="http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/"; xmlns:ec="http://www.w3.org/2001/04/xmlenc#"; xmlns:sp="http://schemas.microsoft.com/sharepoint/"; xmlns:sps="http://schemas.microsoft.com/sharepoint/soap/"; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; xmlns:udcs="http://schemas.microsoft.com/data/udc/soap"; xmlns:udcxf="http://schemas.microsoft.com/data/udc/xmlfile"; xmlns:udcp2p="http://schemas.microsoft.com/data/udc/parttopart"; xmlns:wf="http://schemas.microsoft.com/sharepoint/soap/workflow/"; xmlns:dsss="http://schemas.microsoft.com/office/2006/digsig-setup"; xmlns:dssi="http://schemas.microsoft.com/office/2006/digsig"; xmlns:mdssi="http://schemas.openxmlformats.org/package/2006/digital-signature"; xmlns:mver="http://schemas.openxmlformats.org/markup-compatibility/2006"; xmlns:m="http://schemas.microsoft.com/office/2004/12/omml"; xmlns:mrels="http://schemas.openxmlformats.org/package/2006/relationships"; xmlns:spwp="http://microsoft.com/sharepoint/webpartpages"; xmlns:ex12t="http://schemas.microsoft.com/exchange/services/2006/types"; xmlns:ex12m="http://schemas.microsoft.com/exchange/services/2006/messages"; xmlns:pptsl="http://schemas.microsoft.com/sharepoint/soap/SlideLibrary/"; xmlns:spsl="http://microsoft.com/webservices/SharePointPortalServer/PublishedLinksService"; xmlns:st="" xmlns="http://www.w3.org/TR/REC-html40";><head><meta http-equiv="Content-Type" content="text/html; charset=us-ascii"><meta name="Generator" content="Microsoft Word 12 (filtered medium)"></head><body lang="EN-US" link="blue" vlink="purple"><br><div id="htc_header" style="">Hello everybody.&nbsp;<br></div>

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 JOINLF3 in 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.

As an Amazon Associate we earn from qualifying purchases.

This thread ...


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.