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

Jim, I may be off base here, but here is what I envision might work with SQL
on V5R2:

CREATE TABLE qgpl/t1 (library,field1,field2,field3) AS ( 
  SELECT CAST('library1' AS CHAR(10)), a.* FROM library1/file1 a
    UNION ALL 
  SELECT CAST('library2' AS CHAR(10)), b.* FROM library2/file1 b
  ORDER BY 3) 
WITH DATA 

This will obviously need tweaking to work for your situation.  
You probably don't need the ORDER BY clause, if you follow this CREATE with
ALTER TABLE and add a primary key that fits your needs.
Key to this solution is UNION ALL feature of SQL.
HTH.

Elvis


-----Original Message-----
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