#1 2008-05-21 22:44:23

itc_man
Member
Registered: 2008-04-16
Posts: 11

Oracle to db2

I have a column VARCHAR2 in Oracle and in DB2 I have VARCHAR FOR BIT DATA... When I run the ETL JOB the data gets loaded and LOOKS like it is in HEX format.

How to i make sure the data is in ASCII....thx

Last edited by itc_man (2008-05-21 22:44:55)

Offline

#2 2008-05-22 00:55:18

itc_man
Member
Registered: 2008-04-16
Posts: 11

Re: Oracle to db2

if I change the datatype to Java..byte[]..I am able to insert data into db2....Otherwise. I get error..."com.ibm.db2.jcc.a.SqlException: Illegal Conversion"...But the data in in HEX format.....

Offline

Board footer

Powered by FluxBB