SAP Knowledge Base Article - Preview

3279954 - Column's default value is not adapted when the target DBMS is changed - SAP PD

Symptom

  • Default value of table columns can be a reserved value defined in the DBMS resource file (see Script\Sql\Keywords\ReservedDefault).
  • Whereas it expresses the same meaning, the default value may differ depending on the targeted DBMS.
  • The value is preserved as is when the target DBMS is changed.
  • As an example, getdate() defined in a MSS Physical Data Model (PDM) should be replaced automatically by SYSDATE in an Oracle PDM.


Read more...

Environment

  • SAP PowerDesigner 16.7
  • Various DBMS

Product

SAP PowerDesigner 16.7

Keywords

system, time, timestamp, timezone, CR827471, CR#827471, 827471 , KBA , BC-SYB-PD , PowerDesigner , Known Error

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.