PD 16.5 DBMS ORACLE 11g AlterHeader Script doesn't work

[Former Member]

Hi there,

I am running PD 16.5 and using ORACLE 11g DBMS.

I need to add a preamble to the ALTER script and with MSSQL I used File/AlterHeader. Now with 11g, I had to create it, but it doesn't work.

Anyone with similar problems?

[former_member185199 · Accepted solution]

Hi Nick,

i can confirm this for Powerdesigner 16.1.0.3821 EBF13

I´ve put an testtext in alterheader and in header and the alterheader is not generated:

/*==============================================================*/
/* DBMS name:      ORACLE Version 11g                           */
/* Created on:     24.09.2014 13:41:50                          */
/*==============================================================*/

-- THIS IS A TESTTEXT HEADER

DROP TABLE SRC_WSH_X_DEPOTSTEUERUNG CASCADE CONSTRAINTS;

with alter database:

/*==============================================================*/
/* DBMS name:      ORACLE Version 11g                           */
/* Created on:     24.09.2014 15:18:53                          */
/*==============================================================*/

HERE SHOULD BE THE ALTER TEXT

ALTER TABLE SRC_WSH_X_DEPOTSTEUERUNG
   RENAME COLUMN QUELLE TO QUELLE1;

you should raise a bug report for that.

regards

dj

[Former Member · Accepted solution]

Thank you dj,

After searching SAP's site I couldn't find a way to report a bug.

Do you have any idea?

Cheers,

Nick

[PeterBlignaut · Accepted solution]

You can log an incident from here: Knowledge Base Incidents | SAP Support Portal

Regards, Peter