RE: New RFE request - ADDPFTRG / RMVPFTRG while file is in use

I only looked at 730, but there is PTF SI61262 which says that it adds ADDPFTRG & CHGPFTRG to the effects of ALLOW_DDL_CHANGES_WHILE_OPEN QAQQINI option being '*YES'. Doesn't mention RMVPFTRG.

Regards,

Kevin Wright | IBM i Developer, LPC
+61 2 8907 0284
LANSA
Blog | Facebook | LinkedIn | Twitter
 
There's a quiet revolution afoot: lansa.com/game-changer

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Steinmetz, Paul
Sent: Tuesday, 13 February 2018 8:24 AM
To: 'MIDRANGE-L (midrange-l@xxxxxxxxxxxx)' <midrange-l@xxxxxxxxxxxx>
Subject: New RFE request - ADDPFTRG / RMVPFTRG while file is in use

Would this be a valid RFE request?

Ability to ADDPFTRG / RMVPFTRG while file is in use.
Almost impossible to add/change/remove a trigger.
Need to be in restricted state.

Currently is a restriction.

- If the physical file or a dependent logical file or SQL view is opened in this or another job, a trigger cannot be added.
- If the physical file or a dependent logical file or Structured Query Language (SQL) view is opened in this or another job, the trigger cannot be removed.

- While this command is running, neither the physical file nor any dependent logical files can be opened.

Thank You