RE:

["David Shea" <dshea@xxxxxxxxxxxx>]

If you would like to archive the PZ records instead of just deleting them
(in case you need them back) you could use ARCTOOLS to archive them as
easily as the SQL approach to deleting them.  Check out
http://www.arctools.com for more information.  There are several BPCS shops
using this software, but I don't know if they are using it for this
particular purpose.

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Purge and Archive your AS/400 Data Without Programming with ARCTOOLS (tm)
DCSoftware, Inc.
(508) 435-8243
(508) 435-4498 (fax)
http://www.arctools.com
mailto:info@arctools.com
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

-----Original Message-----
From:   owner-bpcs-l@midrange.com [mailto:owner-bpcs-l@midrange.com] On Behalf
Of Ata510@aol.com
Sent:   Monday, May 10, 1999 7:47 PM
To:     BPCS-L@midrange.com
Subject:        Re:

You should not delete records from this file based only upon PZ status
unless
you never reprint anything. - For example -  how long do you want to retain
the ability to reprint particular kinds of documents? When you delete the PZ
records - you can't reprint them anymore. The PZ documents are what you can
see from the document reprint program. The other records have not been
printed at all yet. You should decide upon a number of days to keep this
history and delete by PZ and some date qualification, I would instead
recommend.


In a message dated 5/3/99 8:18:11 AM Central Daylight Time,
LACELLE@rcmint.ca
writes:


> s funny you ask. I just called SSA on that one. This is a reprint file
>  for purchase orders and requisitions. It's for kept for historical
reasons.
>  Back up the file and purge records with a "PZ". You can do this using
SQL.
>
>       DELETE FROM XXXXX/ZPD WHERE PDID = 'PZ'
>
>       XXXXX Being the data library where you ZPD lives.
>
>       REMEMBER BACK UP you ZPD file first.
>
>       Marc Lacelle
>       Royal Canadian Mint
>
+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---

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