SAP Knowledge Base Article - Preview

2263505 - The data in the ENDING AT clause is not enclosed by parentheses when adding or altering a DB2 partition - SAP PD

Symptom

  • The data in the ENDING AT clause is not enclosed by parentheses when altering an existing partition of a DB2 table, or when adding a partition to a DB2 partitioned table.
  • As an example, SAP PowerDesigner generates:
    alter table tablename
       alter partition partname ending at value;
  • Executing the SQL script generated by SAP PowerDesigner leads to an SQLERROR:
    SQLCODE = -104, ERROR: ILLEGAL SYMBOL "newValue". SOME SYMBOLS THAT MIGHT BE LEGAL ARE: (


Read more...

Environment

  • SAP PowerDesigner (PD)
  • IBM DB2 for z/OS

Product

SAP PowerDesigner all versions

Keywords

partitioning, partitionning, parenthesis, brackets, 794183, CR794183, 794275, CR794275, 797543, CR797543 , 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.