My Oracle Support Banner

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

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
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.