I run a SQL every evening that deletes all records with a DFLG04 = '0', '1'
or '2'. We get about 600 + hits everyday and this keeps the file cleaned
out. Don't delete any DFLG04 = '  ' (blank) as those are active users. I
then run the CLNUSRALC and this process seems to work well.

Mex Davis
MIS Manager
Bekum America Corp.

-----Original Message-----
From: []On
Behalf Of Neil Thursby
Sent: Wednesday, February 20, 2002 3:40 AM
Subject: SYS21 - ICF04PHY size

Thanks for the suggestion.  I tried running CLNUSRALC, but it had no
effect. Actually, it ran in about 2 seconds flat!    I also tried
running the error report, with option to clear the file after printing,
but again no change!

Just wondered if you have any other ideas.   Anyone ever tried SQL on
this file?

Thanks again,


This transmission and any attachments are confidential and are intended
solely for the named addressee (s). If you are not the addressee, please do
not read, copy, use or disclose this transmission and please notify us
immediately by telephone on
+44 (0) 1670 594848 or by reply.  Please then delete this transmission from
your system.

Although we have taken steps to ensure that his email and attachments are
free from viruses, we advise that in keeping with good computing practice
the recipient must ensure that they in fact are virus free.

No contracts may be concluded on behalf of Fone Logistics LTD by means of
email communications.
This is the GEAC/JBA System 21 Users (JBAUSERS-L) mailing list
To post a message email:
To subscribe, unsubscribe, or change list options,
or email:
Before posting, please take a moment to review the archives

This thread ...


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

This mailing list archive is Copyright 1997-2020 by 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].