Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

AS/400 (MAPICS) TO ORACLE

ElMikeJan 23 2013

This is the problem.

I'm passing a table from AS/400(MAPICS) to Oracle using ODI. The problem is that the data is all wrong. The different values for a column should be:

IND
SIN
SIS
SUD

And I'm getting:

C9D5C4
E2C9E2
E2C9D5
E2E4C4

Obviously it's a problem with the character set, but I don't know how to solve it.

The scenario is as follow:
Oracle Data Integrator Version 11.1.1
Oracle Database: 11g
Driver to connect to AS400: weblogic.jdbc.db2.DB2Driver (IBM DB2 Datadirect Driver)
Using LKM SQL to SQL
Using IKM SQL Control Append

The datatype at the source is char(3), but I get an error message saying that I need a char(6) in the target, so I changed to char(6) but I get that wrong data.

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 20 2013

Added on Jan 23 2013

#business-intelligence-applications, #data-integrator, #odi, #system-management-and-integration

0 comments

753 views