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


  1.  Home
  2. RPG400-L
  3. June 2005

Re: Performance

Eugen,

Where do those numbers come from? Two different files? One file? 

I would place those two SQL statements in one programme, perhaps joining the 
files, based on the custNo.
And perhaps change the concept and use a native I/O operation (chain) may make 
a difference as well.

Just my thoughts.

Regards,
Carel Teijgeler 

*********** REPLY SEPARATOR  ***********

On 29-6-05 at 15:25 Eugen.Baum@xxxxxxx wrote:

>I have to get some numbers for our customers.
>
>I created loop thrue master file and for each record
>
>call 'GET01'
>parm           custNo
>parm           number1
>
>call 'GET02'
>parm           custNo
>parm           number2
>
>where GET01 and GET02  SQLRPGLE programs
>
>When I debugged those SQL programs individually they are working fast and 
>using existing ODP
>but from main program it's working very slow.

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.