Re: Accessing files In QTEMP

Doesn't that also apply to SQL DELETE?

And in reply to Richard, the idea was that there would be a WHERE clause on
the SQL DELETE to select the job/user/jobnbr or whatever key is used to
replace the multi-member method.

Peter Dow
Dow Software Services, Inc.
909 425-0194 voice
909 425-0196 fax

From: "Chris Bipes" <chris.bipes@cross-check.com>
> Try to clear a member on a triggered file.


> From: Richard Jackson [mailto:richardjackson@richardjackson.net]
> It depends :)  If the SQL delete is phrased "delete from file" (no where
> clause) it goes pretty fast - unless the file is journaled.  The clear
will
> probably be faster unless you need to keep the 500,001-th record and you
> have to recover it from backup or some such silliness.  When a clear is
> used, the journal records a message "file cleared" and separate journal
> entries are not written for each database record.
>

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