Re: BPCS-L digest, Vol 1 #258 - 4 msgs

[TLuce@xxxxxxxx]

This is a multipart message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
Renato,

ZPD file gets cleared with the ORD900 - Order Purge Program (actual
program is ORD904B in the stream).  It deletes the ZPD records associated
with the customer orders that are getting purged.  We just changed our
settings to retain only 2 years worth of customer order data based upon
Entered Date and we are seeing amazing results across the board.  Files
which get purged with ORD900 are:

ECH, ECL, ECS, EDS, IPP (another one that gets big), KAO, PDA, PDF, PDB,
and ZPD.

Note:  ORD900 needs a performance index put against the ZPD with PDORDR as
the key.  Without this index, the program is very slow.

Timothy C. Luce, MBA, CPIM
Director of Application Development
ESAB - North America
tluce@esab.com


Original Message:

Message: 1
Date: Mon, 22 Apr 2002 14:50:45 -0300
To: bpcs-l@midrange.com
From: rkonda@ig.com.br
Cc:
Subject: ZPD File
Reply-To: bpcs-l@midrange.com

Hi Everybody,

Does Anybody know how I could clear the ZPD file ? or Could I clear this
file deleting inactive records only ? We=B4re 6004 version.
thanks in advance.
Renato