RE: SQL DELETE with file not journaled

From my simple testing I would surmise that you are not seeing what you think you are seeing for the first delete. Something might be changing the environment enough to allow the first delete action to complete, maybe?

My tests indicate that on 7.3 at least, you are prevented from deleting with commit on a un journaled table. I could not get your scenario to occur even in QTEMP. I always get CPF7304, CPF4328 and SQL7008 (reason code 3).

I would set up a performance monitor or STRDBMON over the table being updated and see which program is actually deleting.

-Matt


-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of jm
Sent: Tuesday, January 23, 2018 11:25 AM
To: rpg400-l@xxxxxxxxxxxx
Subject: SQL DELETE with file not journaled


Team,

Why is it that we are able to SQL delete records against a file that is NOT journal and program compiled with default COMMIT = *CHG and no SQL SET statement in program and no WITH NC. In addition, after running the program with all records being deleted we then run same program against file with now 0 records we then get the message file must be journaled. Why didn't we get this message the first time??? I would expect the message the first time or all the time not the 2nd time against an empty file.

Thanks
joe

--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.midrange.com_mailman_listinfo_rpg400-2Dl&d=DwIGoQ&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=wgq2KO1Tl8HswJht2RKpmz7qvL2YDU_M-VhnRH6r43I&m=rIt9T-8B_FZ0I5XYvLJdW4GwUPfGzkAWS4XcqiKB1SA&s=a7HlFmE-zNdUeoejInJmE-9sZlvWrcRQNfb1gvtWiTA&e=
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at https://urldefense.proofpoint.com/v2/url?u=https-3A__archive.midrange.com_rpg400-2Dl&d=DwIGoQ&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=wgq2KO1Tl8HswJht2RKpmz7qvL2YDU_M-VhnRH6r43I&m=rIt9T-8B_FZ0I5XYvLJdW4GwUPfGzkAWS4XcqiKB1SA&s=iqzrbIW3_gtmkINzRThogqvSiAM6PyxPi8AgQgIaK3U&e=.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: https://urldefense.proofpoint.com/v2/url?u=http-3A__amzn.to_2dEadiD&d=DwIGoQ&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=wgq2KO1Tl8HswJht2RKpmz7qvL2YDU_M-VhnRH6r43I&m=rIt9T-8B_FZ0I5XYvLJdW4GwUPfGzkAWS4XcqiKB1SA&s=xEFLq6Bkc1nOmcQpTWe4LKUYwjjjVseimxdgFoAI2-o&e=