Symptom
- An alias is defined for a table, a view, or a sequence in IBM DB2.
- Dropping this alias, PD generates:
DROP ALIAS alias-name;
- The correct syntax is:
DROP ALIAS alias-name FOR TABLE;
DROP ALIAS alias-name FOR SEQUENCE;
Read more...
Environment
- SAP PowerDesigner (PD) 16.6
- IBM DB2
Product
SAP PowerDesigner 16.6
Keywords
db2mvs, synonym, wrong, right, incorrect, SQL, 813321, CR813321, CR#813321 , KBA , BC-SYB-PD , PowerDesigner , Bug Filed
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.