RE: Summary view of arbitrary number ofidentically-named-and-form atted physical files in separate libraries

James,

No easy way that I can think of.  Plus, since you want a logical keyed like
the physical, using an SQL view is out.  Going to have to code a DDS
logical.

However, my question is why are you doing this and how much use will the new
logical get?

Have you considered replacing the multiple physicals with a single physical?
You could create logicals in the separate libraries that select just the
subset of records that were in the library.  It likely you would not even
have to recompile any programs that use the file.  Though obviously, any
current logicals would need to go the new physical.

We've been using the above method to consolidate separate files for multiple
plants into a single file, with a new Plant Code field added.  Replacement
logicals allow current programs to remain unchanged, (except the maint prog.
obviously) while new programs use the new file.

HTH,
Charles


> -----Original Message-----
> From: James H. H. Lampert [mailto:jamesl@xxxxxxxxxxx]
> Sent: Wednesday, September 22, 2004 10:14 AM
> To: Midrange Systems Technical Discussion
> Subject: Re: Summary view of arbitrary number 
> ofidentically-named-and-formatted physical files in separate libraries
> 
> 
> Chuck Lewis wrote:
> 
> > Maybe I am missing what you want here, but how about:
> > WRKOBJ OBJ(*ALL/"your file name") OBJTYPE(*FILE)  ?
> > Or  were you wanting more detail than that ? You could use 
> that and get it
> > to a file, then read the file and do a DSPFD, etc. from there...)
> 
> No, I'm not the slightest bit interested in a list of filenames; the
> idea is to have every record from all of these
> identically-named-and-formatted files appear in what looks, 
> to RPG, like
> a single file, keyed on the same field as the physical. 
> Preferably with
> a way to tell which library's physical any given record came from.
> 
> -- 
> James H. H. Lampert
> Professional Dilettante
> http://www.hb.quik.com/jamesl
> http://members.hostedscripts.com/antispam.html
> http://www.thehungersite.com
> 
> Help America's Passenger Trains. http://www.saveamtrak.org
> 
> Read My Lips: No More Atrocities!
> 
> --
> 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.
>