Re: Advice needed on a multimember DDS file to be converted to DDL

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.