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



Correction - API doesn't produce an output file - user space, I think Chuck said, so it'll be a bit faster than output files - and using pointers, it can be processed really fast - I know you know this, Rich, just putting up the idea for the archives.

Vern

On 8/5/2014 8:15 AM, Vernon Hamberg wrote:
Yeah, APIs might do better. Are they interested only in files with more than one member? Or those that CAN have more than one member? Another DSPFD option (or the file description API) could retrieve based on that MAXMBRS value, to perhaps shorten the list to be checked. And both the APIs and DSPFD again will produce output files for both flat and hilly (heh) files.


On 8/5/2014 7:58 AM, Richard Schoen wrote:
I'm pretty sure the current method they use is DSPFD.

They were complaining about the process taking hours because they have thousands of files with thousands of members which can take up to 10hrs to list.

My technical curiosity was telling me there must be a better way, but if these are flat tables and they won't show up in the SQL, it probably wouldn't work for them.

Regards,

Richard Schoen | Director of Document Management Technologies, HelpSystems
T: + 1 952-736-5800
F: + 1 952-736-5801
RJS Software Systems | A Division of HelpSystems
richard@xxxxxxxxxxxxxxx
www.rjssoftware.com

------------------------------

message: 2
date: Mon, 04 Aug 2014 23:17:11 -0500
from: Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>
subject: Re: Need to get quick database member list for multimember
files

Flat files can have multiple members - just created one like that. Does
that affect how you might do this?

DSPFD will give the members for flat files or otherwise. Is the customer
already using the *OUTFILE option of DSPFD?

Cheers
Vern

On 8/4/2014 10:51 PM, Richard Schoen wrote:
Thanks all for the feedback.

Part of the reason for this request was we had a customer asking about listing PF members because they store EDI multimember physical files and said it takes hours to list them out.

If they are flat, then the question sounds moot.

If not it sounds like Robs technique might work.

It seemed to me there had to be a better way than DSPFD.

Regards,
Richard Schoen | Director of Document Management Technologies, HelpSystems
T: + 1 952-736-5800
F: + 1 952-736-5801
RJS Software Systems | A Division of HelpSystems
richard@xxxxxxxxxxxxxxx
www.rjssoftware.com





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.