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

SQLRPGLE and maximum number of files open for update

I read the archives about the maximum number of files.  This not an OPM
program.

I am working to de-identify the fields in a payroll application
(employee number, SSN, name, etc.) for the test environment.

My current version of the program has 6 files open for input (including
3 table files), 93 files open for update, 3 printer files, and 8 files
updated via SQL.

As soon as I add another logical file for update, the SQL pre-compiler
gives me error SQL0312 Variable x not defined or not usable.   

The program is also using rand / srand to generate phony SSN. It is
being compiled on a V5R3 system.

Is this the case where I will need multiple programs to handle 200+
files?

Thank you, 
Bonnie Lokenvitz
  Technology Consulting Inc
  320.679.2599

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.