2131167 - Be able to prefix Netezza objects by DATABASE.SCHEMA – SAP PD

• Netezza tables and views can not be prefixed by schema and database.
• EnableDtbsPrefix = Yes in the Netezza resource file.
• Netezza supports the following syntax:

  CREATE TABLE DatabaseCode.SchemaCode.TableCode (
  　　 Columns);
  
  CREATE OR REPLACE VIEW DatabaseCode.SchemaCode.ViewCode as
  select　 Columns
  from　 DatabaseCode.SchemaCode.TableCode;

• SAP PowerDesigner supports the following syntax:
  

  CREATE TABLE TableCode (
     Columns);

  CREATE OR REPLACE VIEW ViewCode as
     ViewDefinition;

• SAP PowerDesigner (PD) 16.5
• SAP PowerDesigner (PD) 16.6
• Netezza 5.0

generate, view, sql, 779574, CR779574, CR#779574, enable many databases, EnableManyDatabases, NETEZZA50 , KBA , BC-SYB-PD , PowerDesigner , Product Enhancement