SAP Knowledge Base Article - Preview

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

Symptom

  • 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?

Read more...

Environment

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

Product

SAP PowerDesigner 16.5 ; SAP Sybase PowerAMC 15.3 ; Sybase PowerAMC 16.5 ; Sybase PowerDesigner software 15.3

Keywords

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.