RE: Deleteing companies

Can I get a copy of the CL programs that you use to delete companies. We set
a "Test World" in separate libraries and no longer use environments or test
companies in our "Production World". I have been deleting data in large or
strategic files in our production world and have been toying with the idea
of purging all files. If I could get your programs, I would not have to
reinvent that process.

Thanks!!!
Tim Pfeifer
Director of Information Systems
Chief Automotive Systems, Inc.
pfeifert@chiefautomotive.com



-----Original Message-----
From: owner-jbausers-l@midrange.com
[mailto:owner-jbausers-l@midrange.com]On Behalf Of
Jeff_Klipa/Harvard@harvardind.com
Sent: Friday, September 01, 2000 11:47 AM
To: JBAUSERS-L@midrange.com
Subject: Re: Deleteing companies


I'm assuming you want to remove all trace of the deleted companies from all
files in all libraries...  Note: you should not remove the Z1 company
because some applications do not allow you to create new companies only
copy from existing and Z1 comes shipped with the package and makes a fine
test company...  And there are several files where you will find records
with blanks in the CONO field...  You should never delete these either...
If these records are not there several of the programs will fail to run
correctly...

We have some rather sophisticated CL programs that use some static
file/field definitions that we stored in physical files in conjunction with
SQL commands that allow us to copy and or purge entire companies from every
file in every library in the JBA package...  We can specify the target
libraries and even the target company number, so we can cross environments
or worlds as needed...

Once you delete the records then you need to reorg those files libraries in
order to recover any disk space...

Don't neglect all of the IPG files libraries either...  There can be
considerable record counts in the authority files that are company
specific...

Good luck...  And be careful...  You should always have a fresh and
complete backup of everything prior to running any kind of purge routine...

:-)  You kids don't try this at home...   ;-)






"Margaret Slayton" <mslayton@ambrake.com> on 09/01/2000 12:07:50 PM

Please respond to JBAUSERS-L@midrange.com



  To:          JBAUSERS-L@midrange.com

  cc:          (bcc: Jeff Klipa/Harvard)



  Subject      Deleteing companies
  :







We have numerous companies set up in our test environment.  Has anyone ever
deleted any companies?  If you have, can you give me some pointers on how
to do this.  Thanks
+---
| This is the JBA Software Users Mailing List!
| To submit a new message send your mail to JBAUSERS-L@midrange.com.
| To subscribe to this list send email to JBAUSERS-L-SUB@midrange.com.
| To unsubscribe from this list send email to
JBAUSERS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: doug333@aol.com.
+---



+---
| This is the JBA Software Users Mailing List!
| To submit a new message send your mail to JBAUSERS-L@midrange.com.
| To subscribe to this list send email to JBAUSERS-L-SUB@midrange.com.
| To unsubscribe from this list send email to JBAUSERS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: doug333@aol.com.
+---

+---
| This is the JBA Software Users Mailing List!
| To submit a new message send your mail to JBAUSERS-L@midrange.com.
| To subscribe to this list send email to JBAUSERS-L-SUB@midrange.com.
| To unsubscribe from this list send email to JBAUSERS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: doug333@aol.com.
+---