- 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
- SAP PowerDesigner (PD) 16.6
- IBM DB2 for z/OS
db2mvs, blank, statement, 803609, CR803609, CR#803609 , KBA , BC-SYB-PD , PowerDesigner , Bug Filed
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.