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