
SQL ERROR -104 WHEN "!!" IS USED TO CONCATENATE STRINGS
Problem Details
19.0
AVAILABLE
CLOSED PROBLEM
Feb 13, 2017
Mar 09, 2017
Mar 08, 2021
Problem Description
PROBLEM DESCRIPTION:
The CA SYSVIEW Performance Management Option for DB2 for z/OS (IDB2)
explain feature ends with SQL error -104 when the explained statement
contains "!!" as the string concatenation operator.
SYMPTOMS:
The following message is displayed on the terminal:
DSNT408I SQLCODE = -104, ERROR: ILLEGAL SYMBOL "!". SOME SYMBOLS THAT MIGHT
BE LEGAL ARE: AT MICROSECONDS MICROSECOND SECONDS SECOND MINUTES
MINUTE HOURS
DSNT418I SQLSTATE = 42601 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNHPARS SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = 3 0 0 -1 52 502 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'00000003' X'00000000' X'00000000' X'FFFFFFFF'
X'00000034' X'000001F6' SQL DIAGNOSTIC INFORMATION.
IMPACT:
The statement cannot be explained.
CIRCUMVENTION:
None.
PRODUCT(S) AFFECTED:
CA SYSVIEW Performance Management Option for DB2 for z/OS Version 19.0
CA SYSVIEW Performance Management Option for DB2 for z/OS Version 18.0
Related Solutions
APAR No | Title | Release | OS |
---|---|---|---|
RO94743 | DB2 TOOLS CONSOLIDATED UPDATE #7 | 19.0 | z/OS |
RO94749 | DB2 TOOLS CONSOLIDATED UPDATE #7 | 19.0 | z/OS |
RO94739 | DB2 TOOLS CONSOLIDATED UPDATE #7 | 19.0 | z/OS |
RO94744 | DB2 TOOLS CONSOLIDATED UPDATE #7 | 19.0 | z/OS |
RO94731 | DB2 TOOLS CONSOLIDATED UPDATE #7 | 19.0 | z/OS |
RO94727 | DB2 TOOLS CONSOLIDATED UPDATE #7 | 19.0 | z/OS |
RO94747 | DB2 TOOLS CONSOLIDATED UPDATE #7 | 19.0 | z/OS |
RO94734 | DB2 TOOLS CONSOLIDATED UPDATE #7 | 19.0 | z/OS |
RO94745 | DB2 TOOLS CONSOLIDATED UPDATE #7 | 19.0 | z/OS |
RO94740 | DB2 TOOLS CONSOLIDATED UPDATE #7 | 19.0 | z/OS |
RO94748 | DB2 TOOLS CONSOLIDATED UPDATE #7 | 19.0 | z/OS |
RO94738 | DB2 TOOLS CONSOLIDATED UPDATE #7 | 19.0 | z/OS |
RO94736 | DB2 TOOLS CONSOLIDATED UPDATE #7 | 19.0 | z/OS |
RO94737 | DB2 TOOLS CONSOLIDATED UPDATE #7 | 19.0 | z/OS |
RO94746 | DB2 TOOLS CONSOLIDATED UPDATE #7 | 19.0 | z/OS |
RO94735 | DB2 TOOLS CONSOLIDATED UPDATE #7 | 19.0 | z/OS |
RO94732 | DB2 TOOLS CONSOLIDATED UPDATE #7 | 19.0 | z/OS |
RO94728 | DB2 TOOLS CONSOLIDATED UPDATE #7 | 19.0 | z/OS |
RO94741 | DB2 TOOLS CONSOLIDATED UPDATE #7 | 19.0 | z/OS |
RO94733 | DB2 TOOLS CONSOLIDATED UPDATE #7 | 19.0 | z/OS |
RO94742 | DB2 TOOLS CONSOLIDATED UPDATE #7 | 19.0 | z/OS |
RO94729 | DB2 TOOLS CONSOLIDATED UPDATE #7 | 19.0 | z/OS |
RO94730 | DB2 TOOLS CONSOLIDATED UPDATE #7 | 19.0 | z/OS |