RE:

["Lacelle, Marc" <LACELLE@xxxxxxxxx>]

I know I should not comment on other peoples suggestions, afte all
l-midrange is a forum for exchanging information.

I still prefer deleting the "PZ" for one reason. SPACE. The lesser records
the more room we have. Every night we backup our  data libraries. So worst
comes to worst, we will restore if needed. (it's never happened).

> ----------
> From:         Ata510@aol.com[SMTP:Ata510@aol.com]
> Reply To:     BPCS-L@midrange.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
+---