1883024 - How to avoid quotes around a column default value - SAP PD

• When specifying a database built-in function as column default, PoweDesigner (PD) adds quotes around the default.
• We have the following Teradata 13 sql statement:

create table TABLE_1
(
   COLUMN_1             CHAR(1)              default _UNICODE '0000'XC not null,
   COLUMN_2             CHAR(10)
);

Note: the default value for column_1 is _UNICODE '0000'XC.

• If I create the same table in PowerDesigner, the default value is enquoted:

create table TABLE_1
(
   COLUMN_1             CHAR(1)              default '_UNICODE ''0000''XC' not null,
   COLUMN_2             CHAR(10)
);

• How do I prevent PowerDesigner from enquoting the column default value?

• SAP PowerDesigner (PD) 16.5
• SAP PowerAMC 16.5
• SAP Sybase PowerDesigner 15.3
• SAP Sybase PowerAMC 15.3

PDM, "Single quotes", ReservedDefault, current_timestamp, "resource file" , KBA , BC-SYB-PD , PowerDesigner , How To