RE: INZPFM replacement ???

midrange-l-request@xxxxxxxxxxxx wrote:

>   6. RE: INZPFM replacement ??? (Walden H. Leverich III)
>
>Just out of curiosity, why would you want to INZPFM a file? I understand
>what it does (I think -- it makes a file full of deleted rows) but for what
>reason. Many years ago, when disk was scarce and you wanted to make sure you
>had room for x rows, maybe, but today that is seldom a problem. 

Walden, although this is often true on a system-wide level, it might not be 
true for individual users. A small example -- Users can have storage limits 
set. By using INZPFM when a file is created, the space is counted at the very 
beginning against the owner's space limit. This can signal a problem at the 
beginning of a procedure rather than waiting until late in the execution when 
all kinds of stuff might need to be rolled back.

Tom Liotta

-- 
Tom Liotta
The PowerTech Group, Inc.
19426 68th Avenue South
Kent, WA 98032
Phone  253-872-7788 x313
Fax    253-872-7904
http://www.powertechgroup.com


__________________________________________________________________
McAfee VirusScan Online from the Netscape Network.
Comprehensive protection for your entire computer. Get your free trial today!
http://channels.netscape.com/ns/computing/mcafee/index.jsp?promo=393397

Get AOL Instant Messenger 5.1 free of charge.  Download Now!
http://aim.aol.com/aimnew/Aim/register.adp?promo=380455