Symptom
- An alias is defined for a sequence in IBM DB2.
- SAP PD generates:
CREATE ALIAS alias-name FOR sequence-name
- The correct syntax is:
CREATE ALIAS alias-name FOR SEQUENCE sequence-name
Read more...
Environment
- SAP PowerDesigner (PD) 16.6
- SAP PowerDesigner (PD) 16.7
- IBM DB2 Version 11 for z/OS
- IBM DB2 Version 12 for z/OS
Product
SAP PowerDesigner 16.6 ; SAP PowerDesigner 16.7
Keywords
db2mvs, synonym, wrong, right, incorrect, SQL, 811519, CR811519, CR#811519 , KBA , BC-SYB-PD , PowerDesigner , Problem
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.