Re: Database File Attributes

[Vern Hamberg <hambergv@xxxxxxxxxxxxxx>]

At 04:08 PM 8/26/97 -0500, Gary wrote:
>Is there any way that I can get a list of all files in a library that 
>are specified to re-use deleted records?  I don't want to have to look 
>at the database properties of each file separately. 
>Thanx in advance,
>Gary

Use the following command:

DSPFD FILE(library/*ALL)    
      TYPE(*ATR)            
      OUTPUT(*OUTFILE)      
      FILEATR(*PF)          
      OUTFILE(library/FDATR)

The field PHRUSE in the outfile will be 'Y' for reuse, 'N' for do not
reuse. You can run some kind of query or SQL, selecting on that field.

Cheers

Vernon Hamberg
Systems Software Programmer
Old Republic National Title Insurance Company
400 Second Avenue South
Minneapolis, MN 55401
(612) 371-1111 x480
+---
| 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
+---