RE: Fastest way to delete records.

[Quazy <quazy@xxxxxxxxxxxx>]

Tried that, but it took about 30 minutes just to do the select and 20 
minutes to write 1 million of the selected records.

As first I need to write them to a new file before I delete them.  (forgot 
to mention that)

So I would have to use two different SQL statements.


I was hopeing to imporove on this time.


At 01:32 PM 2/7/01 -0800, you wrote:
>SQL or qmqry.
>
> > -----Original Message-----
> > From: Quazy [mailto:quazy@SoftHome.net]
> > Sent: Wednesday, February 07, 2001 1:04 PM
> > To: rpg400-l@midrange.com
> > Subject: Fastest way to delete records.
> >
> >
> > 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
+---