Re: unable to get data into oracle

In <3n9p0m$6u9_at_calweb.calweb.com>, rdugaue_at_web1.calweb.com (Robert Du Gaue) writes:
>: Hi
>: I am trying to download data into oracle database from db2 database.
>: Unfortunately sql*loader is not able to properly unpack the packed decimal
>: data.
>: Is there a way to unpack the packed decimal data in db2 before creating a
>: unload file.
>
>I'm having simular problems trying to get data from a Tandem Enscribe file
>into an Oracle database on a DEC Unix enviroment. After examining the data via
>a hex dump, I've verified that comp fields on the Tandem have their MSB/LSB
>flipped from what the unix machine wants. IE a pic 9(02) comp field with
>a value of 1 looks like : 0100 on the Tandem. When the data is ftped to the
>Dec platform that same 0100 now equates to 256. Not good considering alot
>of our data records have comp fields with varying sizes! Oracle support was
>no help and basically said I'll need to correct the data bnefore running it
>through their sqlloader. This will severely impact our conversion estimates.
>Is there an easy way to do this or has anyone wrritten something that can
>assist us in our conversion? *ANY* help would be appreciated!

The only way I have been able to get data from DB2 into an Oracle system is to run a DB2/QMF query dumping all of the needed data into an ascii file, then loading the ascii file into Oracle via SQL*LOADER.

M.Landa Received on Mon Apr 24 1995 - 00:00:00 CEST