Re: Deleteing companies

May I get a copy  of the CL programs that you use to delete companies. It would
be much appreciated.

Tim Pfeifer wrote:

> 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.
> +---
>
> +---
> | 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.
> +---

+---
| 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.
+---