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

Re: Help improve performance of RPG program - Long Post

 >> Alan,

>> Why not create procedures instead of functions for the OPENIFS, CLOSEIFS, &
>> WRITEIFS headers?.  Then you could use:

>> CALL OPENIFSFORNEW('/home/yourdirectory/transmit.txt')
>> CALL WRITEIFSHEADER('File info')
<< CALL WRITEIFSHEADER('field header record')
.>>..dummy update statement here to convert the detail data
>> CALL CLOSEIFS()

>> Paul

Not clear to me how this would help. Where would the data come from? A stored 
procedure is just a program. If you had 1.5 million records, you would have to 
run the call statement 1.5 million times! You would have to have something like 
he currently does to get the data. Using the UDF and SQL statements means you 
can retrieve the data and write it all in one statement. To write that 1.5 
million records would take exactly one SQL statement!

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow-Ups:
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.