RP/TUXART Incorrect Conversion SQL DATE Instruction To TRUNC And MWDB2ORA.STR2DATE With Tuxedo ART Workbench
(Doc ID 2347902.1)
Last updated on FEBRUARY 10, 2025
Applies to:
Oracle Tuxedo Application Rehosting Workbench - Version 12.2.2 and laterInformation in this document applies to any platform.
Symptoms
Oracle Tuxedo Application Rehosting Workbench 12.2.2 Red Hat Enterprise 7 Linux x86-64
The wrong conversion is done from ART WORKBENCH during the transformation process from original DB2 database query to ORACLE database query.
Original: EXEC SQL ... DATE(MYPARAM) = DATE(:ABCD.MYPARAM) ... END-EXEC.
Converted: EXEC SQL... TRUNC(MYPARAM) = MWDB2ORA.STR2DATE(:ABCD.MYPARAM) ... END-EXEC.
MYPARAM is a "TIMESTAMP (6)" in Oracle database but is a "PIC X(26)" in DB2 database.
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |