Kevin,
At V7R3, PTF 65523 applied, which supersedes SI61252.
Still receiving the same CPF3202 in use error.
I saw this in the cover letter, but not sure where and how if I need to set this.
After this change is applied, the ADDPFTRG and CHGPFTRG commands can be used immediately after changing the
ALLOW_DDL_CHANGES_WHILE_OPEN QAQQINI option to '*YES'.
Paul
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Kevin Wright
Sent: Monday, February 12, 2018 5:05 PM
To: Midrange Systems Technical Discussion
Subject: RE: New RFE request - ADDPFTRG / RMVPFTRG while file is in use
Sorry about that typo - SI61252 for 730. SI61250 for 720.
A separate set as well from APAR SE65190:
R710 SI61231 PTF Cover Letter 6320
R720 SI61232 PTF Cover Letter 6306
R730 SI61233 PTF Cover Letter 7061
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:58 AM
To: 'Midrange Systems Technical Discussion' <midrange-l@xxxxxxxxxxxx>
Subject: RE: New RFE request - ADDPFTRG / RMVPFTRG while file is in use
Kevin,
Can you confirm that V7R3 PTF, I'm showing it is for WebQuery.
SI61262 - WQX-v220-HF1.2016 DB2 Web Query 2.2.0 Hotfix 1.
Paul
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Kevin Wright
Sent: Monday, February 12, 2018 4:40 PM
To: Midrange Systems Technical Discussion
Subject: 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
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
http://amzn.to/2dEadiD
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
http://amzn.to/2dEadiD
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
http://amzn.to/2dEadiD
midrange.com
