SAP Knowledge Base Article - Preview

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

Symptom

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


Read more...

Environment

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

Product

SAP PowerDesigner 16.5 ; SAP PowerDesigner 16.6 ; Sybase PowerAMC 16.5

Keywords

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

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.