Re: qadb reference files

On Thursday 19 February 2004 16:31, Jim Franz wrote:
> Is there any system reference file with the member
> names with in files. Wanting to create quick
> check of where source members are located.
> dspfd *mbrlist to outfile way too slow.
> I looked in all the QADB* ref files and found all the
> files but no member names.

Hi Jim

We use a logical over QADBXRF which selects only source files.

A          R QSRCFILE                  PFILE(QADBXREF)
A            DBXFIL
A            DBXLIB
A            DBXTYP
A          K DBXLIB
A          K DBXFIL
A          S DBXFIL                    CMP(GT '          ')
A            DBXTYP                    CMP(EQ 'S')

A program then loops through the logical, doing a CHKOBJ for the member  
in each source file:

CHKOBJ OBJ(&DBXLIB/&DBXFIL) OBJTYPE(*FILE) MBR(&MEMBER) AUT(*ALL)

If you don't get a CPF98xx error, then you've found a match on member 
name. The command & programs we have around it are trivial, but I can 
post them to you if you're interested.

Regards, Martin
-- 
martin@xxxxxxxxxx  AIM/Gaim: DBG400dotNet  http://www.dbg400.net   /"\
DBG/400 - AS/400 & iSeries Open Source/Free Software utilities     \ /
Debian GNU/Linux | ASCII Ribbon Campaign against HTML mail & news   X
                                                                   / \