Jeff, 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: email@example.com [mailto:firstname.lastname@example.org]On Behalf Of Neil Thursby Sent: Wednesday, February 20, 2002 3:40 AM To: JBAUSERS-L@midrange.com Subject: SYS21 - ICF04PHY size Jeff, 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, Neil. _____________________________________________________________________ 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: JBAUSERS-L@midrange.com To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/cgi-bin/listinfo/jbausers-l or email: JBAUSERS-Lemail@example.com Before posting, please take a moment to review the archives at http://archive.midrange.com/jbausers-l.