SAP Knowledge Base Article - Preview

2392742 - extra space char added to view's SQL query when X'4C' is used - SAP PD

Symptom

  • An additional space character is added before the first single quote when the DIAGNOSE code X'4C' is used in the view's SQL query.
  • This issue happens as soon as user edits the code.
  • As an example, 

SELECT IMBREQD, X'4C' FROM SYSIBM.SYSDUMMY1

has been modified to

SELECT IMBREQD, X '4C' FROM SYSIBM.SYSDUMMY1

  • Executing SELECT IMBREQD, X '4C' FROM SYSIBM.SYSDUMMY1
    returns an SQLERROR on the SELECT command:

SQLCODE = -104, ERROR: ILLEGAL SYMBOL "'4C'". SOME SYMBOLS THAT MIGHT BE LEGAL ARE: MICROSECONDS
MICROSECOND SECONDS SECOND


Read more...

Environment

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

Product

SAP PowerDesigner all versions

Keywords

db2mvs, blank, statement, 803609, CR803609, CR#803609 , 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.