MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » August 2014

Re: Need to get quick database member list for multimember files



fixed

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









Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot 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 here. If you have questions about this, please contact