|
With some advice from support, we wrote an rpg to delete records from pcp01 by transaction date. We currently keep a years worth of data. MOST importantly, you need to also delete the associated records in pcp02 and pcp06, using the transaction number from pcp01 as the key field. We have been running this monthly for two years now with no troubles.
Lee Sherburn
Genesis 5 Technology, Inc
lsherburn@genesis5.com
-----Original Message-----
From: Harrison, Marcia [mailto:MHarrison@lear.com]
Sent: Tuesday, July 25, 2000 9:14 AM
To: 'JBAUSERS-L@midrange.com'
Subject: PCP01 File
Does any one have information on how to purge/delete records from the PCP01
file?
Lear Corporation
Marcia Harrison
24467 W. Ten Mile Rd.
Southfield Mi. 48034
*Phone: 248.368.8794
*Fax: 248.368.8952
*Pgr: 800.643.3812
+---
| This is the JBA Software Users Mailing List!
| To submit a new message send your mail to JBAUSERS-L@midrange.com.
| To subscribe to this list send email to JBAUSERS-L-SUB@midrange.com.
| To unsubscribe from this list send email to JBAUSERS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: doug333@aol.com.
+---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
