Re: DB2/400 Rerference file

[cmassoglia@xxxxxxxxxxxxxxx (Charles L. Massoglia)]

Execute DSPFFD *ALLUSR/*ALL OUTPUT(*OUTFILE) OUTFILE(YOURLIB/TEMPREF)
Then write a QUERY to select the field WHRFLD equal to the field in
question.  If the field is referenced anywhere, it will show up in the field
WHRFLD.

>In <56618D912F50D211BC3200A0C96F981F02E80F@mail.mchcp.org>, on 09/26/98 
>   at 11:49 AM, Mary Koetting <Mary_Koetting@mail.mchcp.org> said:
>
>>Is there any way to tell if a data field in a reference file is never
>>referenced?
>
>>We have a huge field reference file that needs cleaned up and other than
>>starting with an empty file and adding data fields as they are
>>referenced, I can't think of another way. It seems to be the only way but
>>with thousands of fields it could be a tremendous task.
>
>>S
>
>-- 
>-----------------------------------------------------------
>boothm@ibm.net
>Booth Martin
>-----------------------------------------------------------
>
>+---
>| This is the Midrange System Mailing List!
>| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
>| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
>| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
>| Questions should be directed to the list owner/operator: david@midrange.com
>+---
>
>


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 subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---