Re: Purge of General Ledger Data.

["Clare Holtham" <Clare.Holtham@xxxxxxxxxxxxxx>]

Hi Cesar,
We have written a product ('Archiving for BPCS') that will allow you to
archive the GL files with all their BPCS dependencies, into a separate
library where users can still inquire on the data if they wish. Our product
also allows you to archive other areas of BPCS such as Orders. For details,
please e-mail me offline!
all the best,
Clare Holtham
Director
Small Blue Ltd
IBM Certified AS/400 Systems Professional
E-Mail: Clare.Holtham@btinternet.com
Mobile: +44 (0)7960 665958

----- Original Message -----
From: "Cesar Iracheta Mata" <iracheta@wyny.com.mx>
To: <bpcs-l@midrange.com>
Sent: Friday, June 07, 2002 11:47 PM
Subject: Purge of General Ledger Data.


> Hi
>
> I want compact(purge) the General Ledger Data.
>
> The option is to use staments SQL. Is correct?
>
> If I want delete the data of year 2000(for example), in SQL, I will delete
> the the records of files:GHH, GLH and GXR(principal) than are equal to
> 2000(year=2000). Is correct?
>
> BPCS will works ok?
> Not problem in CEA?
> Not error in Module?
>
> Please advice any comments.
>
>
> Regards
>
>
> Cesar Iracheta Mata
> Suelas WYNY
>
>
>
> _______________________________________________
> This is the SSA's BPCS ERP System (BPCS-L) mailing list
> To post a message email: BPCS-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/bpcs-l
> or email: BPCS-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/bpcs-l.
>
>