Skip to Content
avatar image
George McGeachie

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

Dec 14, 2016 at 10:39 AM | 83 Views

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.

SAP PowerDesigner | oracle | pdm | database generation | altertableheader | database definition
Add comment
10|10000 characters needed characters exceeded

  • George McGeachie
    Dec 14, 2016 at 12:05 PM

    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 :(
  • Get RSS Feed

1 Answer

  • avatar image
    Arnaud LAURENT
    Dec 14, 2016 at 01:02 PM

    See KBA 2404558 - https://launchpad.support.sap.com/#/notes/2404558

    Add comment
    10|10000 characters needed characters exceeded