RE: Fwd: ILE and locked file

I have found that when I have tried a DELETE * From TABLEA. That TABLEA needs to be exclusively allocated (or at least not in use)


-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Reeve
Sent: Friday, July 22, 2022 4:35 PM
To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: Fwd: ILE and locked file

I'd think TRUNCATE TABLE would do a CLRPFM. DELETE FROM seems to be a set operation (which doesn't exclude a set including all records). Check the journal receiver and you'll get your answer.

--reeve

On Fri, Jul 22, 2022 at 12:55 PM Craig Richards <craig@xxxxxxxxxxxxxxxx>
wrote:

I remember reading at
one time that DELETE FROM would attempt to do a CLRPFM

This document has some nice info on Fast Deletes in DB2:

https://www.ibm.com/support/pages/system/files/inline-files/Get%20Up%2
0to%20Speed%20on%20SQL.pdf

regards,
Craig Richards
--
This is the RPG programming on IBM i (RPG400-L) mailing list To post a
message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
related questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com

--
This is the RPG programming on IBM i (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: https://amazon.midrange.com