Re: Problem: MVS/DB2 Unload data to AIX/ORACLE.

In article dated Thu, 29 Aug 1996 12:53:38 GMT, Håkon Eide (hei_at_sn.no) wrote:
> We're in the process of moving a large database from IBM/MVS DB2 to
> IBM/AIX ORACLE v. 7.1.3.
> We're using the DB2 unload-utility to dump DB2-data, then ftp to move
> them over to the RS6000. This ruins all SMALLINT (and probably FLOATS
> as well), SQL*Loader is unable to interpret this correctly.

I can't remember the specifics, but we did this a while back. We downloaded the file from the mainframe as EBCDIC and used sql*loader to read the file as EBCDIC by choosing the right character set option.

--
 _--_|\  John Verhoeven (johnv_at_acix.DIALix.oz.au or johnv_at_DIALix.oz.au)
/      \ >>>> Writing programs in assembler is like digging post <<<<
*_.--._/ >>>> holes with a teaspoon:  it takes a long time, but  <<<<
      v  >>>> you have complete control over all the dirt.       <<<<