Re: Summary view of arbitrary number ofidentically-named-and-formatted physical files in separate libraries

Oh, Oh, that nasty 'keyed on the same field as the physical'.  That will 
be a problem with the suggested SQL view.  However if you use SQL to 
access the file it should use the other files access paths.

Rob Berendt
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





"James H. H. Lampert" <jamesl@xxxxxxxxxxx> 
Sent by: midrange-l-bounces@xxxxxxxxxxxx
09/22/2004 09:14 AM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
cc

Fax to

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.