|
Sorry, my stupidity. At 11:22 AM 2/8/01 -0500, you wrote: >Why would duplicate keys in such a logical be a problem? Just don't specify >UNIQUE. > >Dave Shaw >Spartan International, Inc. >Spartanburg, SC >--- >If you would like to subscribe to the MAPICS-L mailing list send email to >MAPICS-L-SUB@midrange.com or go to www.midrange.com and follow the >instructions. > >-----Original Message----- >From: Quazy [mailto:quazy@SoftHome.net] >Sent: Thursday, February 08, 2001 9:14 AM >To: RPG400-L@midrange.com >Subject: Re: Fastest way to delete records. > > >sounds good, but I can't create a logical on timestamp alone. As then I >would have many duplicate keys. as there are 40,000 employee numbers each >with many timestamps. > >At 01:49 PM 2/7/01 -0800, you wrote: > >Hmm... > >create a logical on the time stamp. > > > >Open Combined Full procedural this file > >Do while not LR > > if TimeStamp <= ToTimeStamp > > Delete Record > > else > > SetOn LR > > EndIf > >End Do > > > >Can anyone think of a faster way? > > > >Regards, > > > >Jim Langston > > > > > >Quazy wrote: > > > > > > I have a file with about 10 million records. It is keyed on Company #, > > > Employee #, and Time stamp. > > > > > > I need to delete all records that have a time stamp before a certain >time > > > period. > > > > > > Any suggestions on the fastest approach? > > > Speed is a very important factor. > > > > > > +--- > > > | This is the RPG/400 Mailing List! > > > | To submit a new message, send your mail to RPG400-L@midrange.com. > > > | To subscribe to this list send email to RPG400-L-SUB@midrange.com. > > > | To unsubscribe from this list send email to >RPG400-L-UNSUB@midrange.com. > > > | Questions should be directed to the list owner/operator: > > david@midrange.com > > > +--- > >+--- > >| This is the RPG/400 Mailing List! > >| To submit a new message, send your mail to RPG400-L@midrange.com. > >| To subscribe to this list send email to RPG400-L-SUB@midrange.com. > >| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com. > >| Questions should be directed to the list owner/operator: >david@midrange.com > >+--- > >+--- >| This is the RPG/400 Mailing List! >| To submit a new message, send your mail to RPG400-L@midrange.com. >| To subscribe to this list send email to RPG400-L-SUB@midrange.com. >| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com. >| Questions should be directed to the list owner/operator: >david@midrange.com >+--- >+--- >| This is the RPG/400 Mailing List! >| To submit a new message, send your mail to RPG400-L@midrange.com. >| To subscribe to this list send email to RPG400-L-SUB@midrange.com. >| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com. >| Questions should be directed to the list owner/operator: david@midrange.com >+--- +--- | This is the RPG/400 Mailing List! | To submit a new message, send your mail to RPG400-L@midrange.com. | To subscribe to this list send email to RPG400-L-SUB@midrange.com. | To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com. | Questions should be directed to the list owner/operator: david@midrange.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.