RP/TUXART Incorrect Conversion SQL DATE Instruction To TRUNC And MWDB2ORA.STR2DATE With Tuxedo ART Workbench
Last updated on JANUARY 19, 2018
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms