Performance -- RPG400-L

Subject: Performance
From: Eugen.Baum@xxxxxxx
Date: Wed, 29 Jun 2005 15:25:44 -0400
List-archive: <http://archive.midrange.com/rpg400-l>
List-help: <mailto:rpg400-l-request@midrange.com?subject=help>
List-id: RPG programming on the AS400 / iSeries <rpg400-l.midrange.com>
List-post: <mailto:rpg400-l@midrange.com>
List-subscribe: <http://lists.midrange.com/mailman/listinfo/rpg400-l>, <mailto:rpg400-l-request@midrange.com?subject=subscribe>
List-unsubscribe: <http://lists.midrange.com/mailman/listinfo/rpg400-l>, <mailto:rpg400-l-request@midrange.com?subject=unsubscribe>

Hello everyone.

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.

any suggestion



Thank You.

As an Amazon Associate we earn from qualifying purchases.

Follow-Ups:

Re: Performance , Carel Teijgeler
Re: Performance , Tony Carolla

This mailing list archive is Copyright 1997-2025 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.