Re: Delete Capable Files?

Le 28/03/2023 à 18:51, Rich Loeber a écrit :

I have an activity log file that I would like to be able to purge on demand but otherwise disallow record deletes. I suppose I could purge to a different file and the copy the records back.

Just a thought if you do not need to update records : use a journal in place of your log file, then use SNDJRNE command or QJOSJRNE API to add entries. Your purge activity would then be deleting the receivers. To query the journal, you can still use DISPLAY_JOURNAL table function.

Rich Loeber
Kisco Systems LLC
https://www.kisco.com

________________________________


On 3/28/2023 12:38 PM, George Smith wrote:

I would figure that the thought would be so it couldn't be turned off maliciously so records could be removed.

George Smith

From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx><mailto:midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Rich Loeber
Sent: Tuesday, March 28, 2023 11:34 AM
To: midrange-l@xxxxxxxxxxxxxxxxxx<mailto:midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: Delete Capable Files?

Now I'm wondering if there is a way to programmatically turn this feature on and off. I don't see it as an option on the CHGPF command. Rich Loeber Kisco Systems LLC https://www.kisco.com ____________
External (rich@xxxxxxxxx<mailto:rich@xxxxxxxxx><mailto:rich@xxxxxxxxx><mailto:rich@xxxxxxxxx>)
Report This Email<https://protection.inkyphishfence.com/report?id=c2tvdXQtZnJ1aXQtb2YtdGhlLWVhcnRoL2dzbWl0aEBmb3RlLmNvbS83NjYzMjVlNjEwNTQyZDIyZjEzYzYxNWI3MTg2NDMwMC8xNjgwMDIxMjc4LjU1#key=15ebb3a17631c05e73db7c218126cf11><https://protection.inkyphishfence.com/report?id=c2tvdXQtZnJ1aXQtb2YtdGhlLWVhcnRoL2dzbWl0aEBmb3RlLmNvbS83NjYzMjVlNjEwNTQyZDIyZjEzYzYxNWI3MTg2NDMwMC8xNjgwMDIxMjc4LjU1#key=15ebb3a17631c05e73db7c218126cf11> FAQ<https://getskout.com/emailprotectionfaq/><https://getskout.com/emailprotectionfaq/> Skout Email Protection<https://getskout.com/emailprotection/><https://getskout.com/emailprotection/>


Now I'm wondering if there is a way to programmatically turn this feature on and off. I don't see it as an option on the CHGPF command.



Rich Loeber

Kisco Systems LLC

https://www.kisco.com<https://shared.outlook.inky.com/link?domain=www.kisco.com&t=h.eJxVjcsOgyAUBX_FsC7ykqtx5a-0CIWIxcAlLJr-e8uy2zOZOW9ScyTrQDziVVbGWmvjEYpJo0knuQ3k6LQcqSJ1uQakyVH0ltp7Rs-e5QzoN5fQdoHNAEpqC4LrSe5SOqEMCP2YxQKT4pwJWDiXQs7LqHXv297Pwfjt73b_za8a4-cLK2EwZA.MEUCIQCB7PG6uHOH3DoLPkkUW5R4b1-3ojES46uhxBdTxmfdzQIgSgAbTT106ZngbgOgOm9n2_p-KlKIcNN01GHegOWrBPc><https://shared.outlook.inky.com/link?domain=www.kisco.com&t=h.eJxVjcsOgyAUBX_FsC7ykqtx5a-0CIWIxcAlLJr-e8uy2zOZOW9ScyTrQDziVVbGWmvjEYpJo0knuQ3k6LQcqSJ1uQakyVH0ltp7Rs-e5QzoN5fQdoHNAEpqC4LrSe5SOqEMCP2YxQKT4pwJWDiXQs7LqHXv297Pwfjt73b_za8a4-cLK2EwZA.MEUCIQCB7PG6uHOH3DoLPkkUW5R4b1-3ojES46uhxBdTxmfdzQIgSgAbTT106ZngbgOgOm9n2_p-KlKIcNN01GHegOWrBPc>



________________________________



On 3/28/2023 12:05 PM, Marc Rauzier wrote:

Le 28/03/2023 à 18:00, Rich Loeber a écrit :

In the S/36 days, I recall that a file could be created so that records could not be deleted from them. I'm looking for a way to do this using a PF in DDS, but I'm not seeing it. Is this just not an option in IBM i DB2 for a physical file?



CRTPF ALWDLT(*NO) ?





Rich Loeber

Kisco Systems LLC

https://www.kisco.com<https://shared.outlook.inky.com/link?domain=www.kisco.com&t=h.eJxVjcsOgyAUBX_FsC7ykqtx5a-0CIWIxcAlLJr-e8uy2zOZOW9ScyTrQDziVVbGWmvjEYpJo0knuQ3k6LQcqSJ1uQakyVH0ltp7Rs-e5QzoN5fQdoHNAEpqC4LrSe5SOqEMCP2YxQKT4pwJWDiXQs7LqHXv297Pwfjt73b_za8a4-cLK2EwZA.MEUCIQCB7PG6uHOH3DoLPkkUW5R4b1-3ojES46uhxBdTxmfdzQIgSgAbTT106ZngbgOgOm9n2_p-KlKIcNN01GHegOWrBPc><https://shared.outlook.inky.com/link?domain=www.kisco.com&t=h.eJxVjcsOgyAUBX_FsC7ykqtx5a-0CIWIxcAlLJr-e8uy2zOZOW9ScyTrQDziVVbGWmvjEYpJo0knuQ3k6LQcqSJ1uQakyVH0ltp7Rs-e5QzoN5fQdoHNAEpqC4LrSe5SOqEMCP2YxQKT4pwJWDiXQs7LqHXv297Pwfjt73b_za8a4-cLK2EwZA.MEUCIQCB7PG6uHOH3DoLPkkUW5R4b1-3ojES46uhxBdTxmfdzQIgSgAbTT106ZngbgOgOm9n2_p-KlKIcNN01GHegOWrBPc>

--

This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list

To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx<mailto:MIDRANGE-L@xxxxxxxxxxxxxxxxxx><mailto:MIDRANGE-L@xxxxxxxxxxxxxxxxxx><mailto:MIDRANGE-L@xxxxxxxxxxxxxxxxxx>

To subscribe, unsubscribe, or change list options,

visit: https://lists.midrange.com/mailman/listinfo/midrange-l<https://shared.outlook.inky.com/link?domain=lists.midrange.com&t=h.eJw1zEsOgyAUheGtGMZFHgoaR26FIgiRRwOXUdO9t7Tp9Pw53xO1EtA2IAfwqBshwVeoY_RHUek0o86RROVDVOmbfLKZ_CsO6Dagq9_rlRtgW5oHnC0GZ7BRBRw5a_Tgdpvhhy1STlwYyaiY-cG5ZZOWTNwXtsp5opQwuVLKGV_WUYjum-4Xr91--apzV_p8fObUQni9AeWnPRA.MEQCICD2l9vgvgw1r28bbILL_fQ-K0w5x5_OnGawDV7llas8AiAiY4wEye-0-TxXvvFmjS831bXhLIBD60yfKnfJ1tkg4A><https://shared.outlook.inky.com/link?domain=lists.midrange.com&t=h.eJw1zEsOgyAUheGtGMZFHgoaR26FIgiRRwOXUdO9t7Tp9Pw53xO1EtA2IAfwqBshwVeoY_RHUek0o86RROVDVOmbfLKZ_CsO6Dagq9_rlRtgW5oHnC0GZ7BRBRw5a_Tgdpvhhy1STlwYyaiY-cG5ZZOWTNwXtsp5opQwuVLKGV_WUYjum-4Xr91--apzV_p8fObUQni9AeWnPRA.MEQCICD2l9vgvgw1r28bbILL_fQ-K0w5x5_OnGawDV7llas8AiAiY4wEye-0-TxXvvFmjS831bXhLIBD60yfKnfJ1tkg4A>

or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx<mailto:MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx><mailto:MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx><mailto:MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx>

Before posting, please take a moment to review the archives

at https://archive.midrange.com/midrange-l.<https://shared.outlook.inky.com/link?domain=archive.midrange.com&t=h.eJw1jEsOgyAUAK9iWJevgsaVV7F8hIDSwKObpndvSdPlTDLzQq0ktA7IAzzqSuletA9PS85gyn4dluh80j_gRNBtQLEHNeYG2JUWAGeHwVts9wKeHvUM4DeX4RfPSo1CWsWZnIQRwvFRKy7vM1_UNDJGuVoYE1zMC5Gy_23_l6D9FkPVuV-6Nl99tZTeH8iKN0w.MEUCIQC6pjnfNgSp5WDeMFaPrjPkz8FbJXL0XDbpbWgyMrjv1AIgKab7n2bAmyAgg_79xAOo7hnqd27uv83Tjj-jemrK__w><https://shared.outlook.inky.com/link?domain=archive.midrange.com&t=h.eJw1jEsOgyAUAK9iWJevgsaVV7F8hIDSwKObpndvSdPlTDLzQq0ktA7IAzzqSuletA9PS85gyn4dluh80j_gRNBtQLEHNeYG2JUWAGeHwVts9wKeHvUM4DeX4RfPSo1CWsWZnIQRwvFRKy7vM1_UNDJGuVoYE1zMC5Gy_23_l6D9FkPVuV-6Nl99tZTeH8iKN0w.MEUCIQC6pjnfNgSp5WDeMFaPrjPkz8FbJXL0XDbpbWgyMrjv1AIgKab7n2bAmyAgg_79xAOo7hnqd27uv83Tjj-jemrK__w>



Please contact support@xxxxxxxxxxxxxxxxxxxx<mailto:support@xxxxxxxxxxxxxxxxxxxx><mailto:support@xxxxxxxxxxxxxxxxxxxx><mailto:support@xxxxxxxxxxxxxxxxxxxx> for any subscription related questions.