Re:

[Ata510@xxxxxxx]

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