Skip to Content

AfterModify in the wrong place in geneated SQL; AlterTableHeader and Footer missing

Dec 14, 2016 at 10:39 AM


avatar image

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.

10 |10000 characters needed characters left characters exceeded

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 :(
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Dec 14, 2016 at 01:02 PM
10 |10000 characters needed characters left characters exceeded