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.