Re: "System Wide Catalog" on AS/400

>At 02:06 PM 8/8/97 -0700, you wrote:
>>Hello All,
>>
>>I recently received a flyer for a Y2K presentation by Skip Marshesani
>>and in one of the overview sections they mention "System Wide
>>Catalog"...
>>
>>What is this ?
>>
>>Thanks,
>>
>>Chuck
>>
Vernon Hamberg wrote:
>>
>This is for SQL. It is a set of 'logicals' in library QSYS2 that are built
>over various QADB* files in QSYS. They are dynamically maintained by the
>system.
>
>They're the same as the SQL catalog files created when you CREATE
>COLLECTION, 'tho those are local to the collection.
>
The system wide catalog is more than just for SQL.  You can QUERY or write
RPG programs against the following system files.

   QADBIFLD contains a list of all fields for all PFs and LFs.  (DSPFFD
information.)

   QADBKFLD contains the keys for all PFs and LFs.  (DSPFD TYPE(*ACCPTH)
information.)

   QADBFDEP contains all PFs and LFs whose existence depends on another
file.  (DSBDBR information.)

   QADBXREF contains a list of all PFs and LFs.

These files do NOT contain information from DSPFs or PRTFs.


Charlie Massoglia, Massoglia Technical Consulting, Inc.
PO Box 1065, Okemos, MI 48854, USA
517-676-9700  Fax: 517-676-1006  EMAIL: cmassoglia@voyager.net


* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the Midrange System Mailing List!  To submit a new message,   *
* send your mail to "MIDRANGE-L@midrange.com".  To unsubscribe from     *
* this list send email to MAJORDOMO@midrange.com and specify            *
* 'unsubscribe MIDRANGE-L' in the body of your message.  Questions      *
* should be directed to the list owner / operator: david@midrange.com   *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *