I am not sure is
(1) Drop table and re-create TABLE again,
or
(2) Delete from table every time (the table is created by SQL but not journaling)

which one is more efficiency(or faster) on iSeries. Thanks.

andrewwang1 (AT) yahoo (DOT) com wrote:

Beginning with (I think) v5r3 of i5/os, a DELETE with
no WHERE clause is equivalent to doing a CLRPFM
command. I have to think that's faster than a DROP /
CREATE sequence.

Hi,

when you want to delete all the records from the file it does a CLRPFM
actually. Should be faster than a DROP and CREATE.

Rgdz
Henk
<andrewwang1 (AT) yahoo (DOT) com> schreef in bericht
news:2070255007.1138255462688.JavaMail.wassrvr (AT) ltsgwas007 (DOT) sby.ibm.com...

This is valid ONLY if you are on V5R3...

Regards

Luis Rodriguez

CLRPFM is the best way to clear an As/400 PF/table for a long long time

nothing to do with V5R3 if that is what u r asking
luis.rodriguez (AT) romal (DOT) net wrote:

me wrote:

Beginning with v5r3, this is what a DELETE in SQL with
no WHERE clause does. A nice thing about it is it's a
cleaner interface (for the programmer) than having to
do a CALL to QCMDEXC or to the external C procedure
'system'.

I think it will depend on the number of records in the table. As records
increase, at some point I think the drop table will start being faster than
delete from, and the delete from will continue to take longer. Of course,
the optimizer may notice you are not journaling, see the delete without a
where clause, and just do a CLRPFM, which is just about the fastest way to
get rid of all records.

Then it further depends on how often you are doing it.

How much time do you want/need to save each day? Or on each transaction?

Motto: Don't sweat the small stuff. Put another way, if you have 1,000
records and do it once a day, it probably doesn't make any significant
difference how you do it.

Sam

<andrewwang1 (AT) yahoo (DOT) com> wrote