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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.