Re: Delete Capable Files?

[Marc Rauzier <marc.rauzier@xxxxxxxxx>]

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.