RP/TUXART Incorrect Conversion SQL DATE Instruction To TRUNC And MWDB2ORA.STR2DATE With Tuxedo ART Workbench

(Doc ID 2347902.1)

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.

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.

Cause

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