In the Database definition file for Oracle, I've added a number of items , which will cause XML wrappers to appear in SQL generated from a PDM. Most of these work as expected, with the exception of
"Script \ Objects \ Table \ AfterModify"
This statement ALWAYS appears immediately after the statement output from BeforeModify, and therefore before the 'alter table' statement that it's meant to follow. Very annoying.
Am I the only one that suffers from this?
I've also tried using AlterTableHeader and AlterTableFooter, but they don't appear at all.
My DBMS is Oracle 12c.
Thanks to Arnaud from SAP, I know the following:
- I've misinterpreted the purpose of Table.AfterModify, and the symptoms presented.
* Table.AfterModify is only triggered by a subset of 'modify' events, such as an ALTER statement to add a column
* In the SQL PD generated, the Table.AfterModify item appears immediately after the able.BeforeModify item; I assumed it had been generated too early, but I was wrong - I now think that PD wrongly outputs the pair of items sometimes.
- AlterTableHeader and AlterTableFooter are no longer used, they've been hanging around since PD v6 - shame the documentation doesn't say so :(
