Skip to Content

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

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.

Add comment
10|10000 characters needed 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 :(
  • Follow
  • Get RSS Feed

1 Answer

  • Dec 14, 2016 at 01:02 PM
    Add comment
    10|10000 characters needed characters exceeded