In message
<6e8c6c3ab287df45837a5816ce37531d68d6544...@daconosbserver.daconosbs.loca
l>, David Jordan <[email protected]> writes
Hi Ray
Are you using UniVerse or UniData. I use dynamic files and never have
to resize them in UniVerse.
The OP said that the files keep on growing and shrinking - and that is
not good for dynamic files. Although I would ask why you have to keep
resizing and generally "maintaining" the files? You shouldn't have to do
that with dynamic files (unless, of course, you're short of disk space
and overflow wastes huge amounts).
I'd go with Adrian's suggestion and use MINIMUM.MODULUS. *However* you
did say the files regularly get emptied. Do you have an app that
processes the file and empties it? If it's disk space you're worried
about, just do a CLEAR.FILE inside your app once you've emptied the file
- I think you can do it as a basic statement rather than an execute.
You'll need to look at how to do it (it should be very simple) but I'd
be inclined to do the below on every file after it's processed
lock file
clearselect
select file
if count = 0 then clearfile
release
That's all your maintenance and disk freeing automated for you...
Cheers,
Wol
--
Anthony W. Youngman <[email protected]>
'Yings, yow graley yin! Suz ae rikt dheu,' said the blue man, taking the
thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said Nanny. The man
lowered the thimble. 'Pictsies!' Carpe Jugulum, Terry Pratchett 1998
Visit the MaVerick web-site - <http://www.maverick-dbms.org> Open Source Pick
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
