Home -> Usenet -> comp.databases.oracle -> Data conversion from IBM to UNIX

Data conversion from IBM to UNIX

From: Ewald Ziervogel <zedez_at_safmarine.co.za>
Date: 1995/09/11
Message-ID: <431i9c$iq8_at_aztec.co.za>#1/1 






We are in  the process of moving some systems from an IBM/MVS DB2
database to Unix/Oracle.  We have uncovered a major problem (for us)
which I am sure has been solved by others.



Some of our data fields are held on the DB2 database as binary, and
when transfered to the UNIX platform the conversion from EBCDIC to
ASCII screws them up!



Also the Oracle load utility will ignore any data fields containing
nulls (x'0000' for eg), with disasterous results. 



Neither Oracle (locally), IBM or HP can cast any light on this
problem.



Has anyone transfered binary data from IBM to UNIX and if so how can
the above be avoided?



Any comments most welcome.
Received on Mon Sep 11 1995 - 00:00:00 CEST












Original text of this message