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



Possibly, but I think the creating/deleting of objects for that short of a timeframe seems overly expensive, systemwise. Much more of a hit than adding/removing members.

Mike Cunningham wrote:
Could some of these processes use QTEMP libraries? Instead of adding a member you could copy the base file without data (crtdupobj) and do an override to qtemp. Or you could create a library with the name you would have given the member and do the same as you do now except the override would change the library and not the member

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Jeff Crosby
Sent: Friday, April 25, 2008 1:05 PM
To: Midrange Systems Technical Discussion
Subject: Re: Advice needed on a multimember DDS file to be converted to DDL

Let's just do everything twice, huh?

Jeff Crosby wrote:
As I have noted at least once before, I have gone through and converted
over 360 DDS defined PF to be DDL defined. Plus all the associated LF
to Indexes/Views. I am now doen to the last 2 PF, the order header and
order detail (ORHDR and ORDTL, respectively). I saved these for last
because they would be the hardest.

They are both multimember and have associated LF, also multimember.
There are 2 permanent members, 1 for current days orders and 1 for
advance orders. There are also hundreds of transient members
added/removed daily, normally removed within seconds of being added.
What happens is the sales people (called a DSR in the business)
transmits an order from their laptop, a unique member is added to the
files, the order gets placed into that member, gets processed, and the
results transmitted back to the DSR immediately. By putting each of
these orders into it's own member, it is kept logically separate. After
the results are transmitted to the DSR, the order gets moved to the
advance order member and the transient member is removed. There are no
performance issues whatsoever with this approach.

There are 66 (!) RPG programs that touch one or both of these files. A
CL wrapper with OVRDBF is what points RPG to the correct member. Many
of these CLs also have OPNQRYF in them. I am hitting my head against
the wall trying to come up with an elegant way to do all this. I'm sure
I have to add a MEMBER field to the files. But I'm trying to find a way
that I don't have to rewrite it all.




--
Jeff Crosby
UniPro Foodservice/Dilgard
260-422-7531
Opinions expressed are my own and not necessarily those of my company. Unless I say so.


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.



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.