RP/TUXART Incorrect Conversion SQL DATE Instruction To TRUNC And MWDB2ORA.STR2DATE With Tuxedo ART Workbench
(Doc ID 2347902.1)
Last updated on MAY 07, 2020
Applies to:Oracle Tuxedo Application Rehosting Workbench - Version 12.2.2 and later
Information in this document applies to any platform.
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.
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