Fixes are available
APAR status
Closed as program error.
Error description
When an application issues the following SQL statement (which is valid for DB2), the GH JDBC driver outputs a parsing error to standard out (or the app server log, when running in WAS - see SystemOut-2,log attached): SELECT CURRENT DATE AS TODAY FROM SYSIBM.SYSDUMMY1 This prevents a database stub from being created for that application, as stub creation does not work. RIT can see the SQL and the result set in the recording studio, but when it creates a db stub, the table in question is not included in the stub and the application will receive an error when run against such stub. As can be seen from the attached log, the error occurs when parsing the "AS" token from the above SQL. If the statement is changed to SELECT CURRENT DATE FROM SYSIBM.SYSDUMMY1 then the error goes away. The following standard SQL: SELECT CURRENT_DATE AS TODAY FROM SYSIBM.SYSDUMMY1 also works.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * All users of Rational Integration Tester working with JDBC * * Virtualisation and SQL statements that use the following DB2 * * special registers: CURRENT DATE, CURRENT TIME, and CURRENT * * TIMESTAMP. * **************************************************************** * PROBLEM DESCRIPTION: * * JDBC proxy error in parsing "select current date as xxx" on * * DB2 * **************************************************************** * RECOMMENDATION: * * Upgrade to Rational Integration Tester v8.7.1.1 which * * includes a fix for this issue * ****************************************************************
Problem conclusion
A fix for this issue was provided in version 8.7.1.1 of Rational Integration Tester.
Temporary fix
Comments
APAR Information
APAR number
PI33728
Reported component name
RATL INTEGRA TE
Reported component ID
5725G79IT
Reported release
860
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2015-01-29
Closed date
2015-12-29
Last modified date
2015-12-29
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
RATL INTEGRA TE
Fixed component ID
5725G79IT
Applicable component levels
R800 PSN
UP
R801 PSN
UP
R850 PSN
UP
R851 PSN
UP
R860 PSN
UP
R870 PSN
UP
R871 PSY
UP
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSBLQQ","label":"Rational Test Workbench"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.6","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
17 October 2021