×

Good News Everybody!

The new search engine is LIVE!

Please report any problems to david (at) midrange.com.




I believe that if you define your files with SQL then the default is to
Reuse deleted records . . . . . . . . . . . : REUSEDLT *YES
If you type in CRTPF then the default is to:
Reuse deleted records . . . . . . . . . . . : REUSEDLT *NO
And most vendor supplied applications will use CRTPF and DDS (or Data
Description Specifications). You WILL have to learn DDS.

Reuse is normally not a problem unless your application relies on arrival
sequence. Which I've seen in some multiformat EDI applications and a rare
history log or two that didn't set up an otherwise unique key.

There's also a command called RGZPFM which will compress out deleted
records and will sort the file too if you use the optional KEYFILE
parameter.


Rob Berendt

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2026 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.