RE: Fwd: ILE and locked file

I can't state this with certainty, but I vaguely recall reading about a workaround to avoid the exclusive allocate:
DELETE * FROM TABLEA WHERE 1=1

Roger Harman
COMMON Certified Application Developer - ILE RPG on IBM i on Power



-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Therrien, Paul via RPG400-L
Sent: Friday, July 22, 2022 2:03 PM
To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Cc: Therrien, Paul <ptherrien@xxxxxxxxxxx>
Subject: 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://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.ibm.com%2Fsupport%2Fpages%2Fsystem%2Ffiles%2Finline-files%2FGet%2520Up%25252&amp;data=05%7C01%7C%7C519b7bfc15be48ba27e308da6c25a83a%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637941206245749864%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&amp;sdata=LLAYFXpZsRvrYFHc5TMO%2Fub1gxZykiwgF68Zdv5qfbo%3D&amp;reserved=0
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://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.midrange.com%2Fmailman%2Flistinfo%2Frpg400-l&amp;data=05%7C01%7C%7C519b7bfc15be48ba27e308da6c25a83a%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637941206245749864%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&amp;sdata=0AM5QU0AlRWDLmfWKUNI6gqIm0ENR%2FIX2XvmUKnhoYM%3D&amp;reserved=0
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Farchive.midrange.com%2Frpg400-l&amp;data=05%7C01%7C%7C519b7bfc15be48ba27e308da6c25a83a%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637941206245749864%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&amp;sdata=gSfZY0TDgt7yrPLROpV1kWiuVXBuCA%2BaS8uj%2FkmRQAc%3D&amp;reserved=0.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
related questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Famazon.midrange.com%2F&amp;data=05%7C01%7C%7C519b7bfc15be48ba27e308da6c25a83a%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637941206245749864%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&amp;sdata=sPVZZ7V23wRMtBrkEqhpBB1KGySrenvVWgdJmmvsE%2Fs%3D&amp;reserved=0

--
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://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.midrange.com%2Fmailman%2Flistinfo%2Frpg400-l&amp;data=05%7C01%7C%7C519b7bfc15be48ba27e308da6c25a83a%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637941206245749864%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&amp;sdata=0AM5QU0AlRWDLmfWKUNI6gqIm0ENR%2FIX2XvmUKnhoYM%3D&amp;reserved=0
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Farchive.midrange.com%2Frpg400-l&amp;data=05%7C01%7C%7C519b7bfc15be48ba27e308da6c25a83a%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637941206245749864%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&amp;sdata=gSfZY0TDgt7yrPLROpV1kWiuVXBuCA%2BaS8uj%2FkmRQAc%3D&amp;reserved=0.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Famazon.midrange.com%2F&amp;data=05%7C01%7C%7C519b7bfc15be48ba27e308da6c25a83a%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637941206245749864%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&amp;sdata=sPVZZ7V23wRMtBrkEqhpBB1KGySrenvVWgdJmmvsE%2Fs%3D&amp;reserved=0