Re: HELP! Packed data and different OS's

In article <3cqain$253_at_reeve.research.aa.wl.com> crawfom_at_aa.wl.com writes:
>
>I have a file that resides on an IBM. It contains a field
>whose type is packed decimal. I cannot change this file,
>or unpack it where it currently resides. I must first FTP
>it to a Unix box. Of course, it cannot be SQL*Loaded
>directly because SQL*Loader cannot handle packed data from
>a different OS than the one under which it is running. Does
>anyone out there have any info that can help? Believe me,
>it's critical! Thanks,

Well this is what we did when we migrated off th IBM to a SPARC. We used PC support to export the IBM EBDIC flat file to a ASCII file on a PC (actually Netware) file system, then ftp'ed it to the unix box. Once there SQL*Loader did the rest!

Philip

--
+---------------------------------+-------------------------------------------+
|Philip Chee: philip_at_aleytys.pc.my| This is a work of fiction.Any resemblance |
|Tasek Cement Berhad              |  to persons living or dead is completely  |
|P.O.Box 254, 30908 Ipoh, MALAYSIA| coincidental. The creator of this article |
|Voice: +605-551-011              |    has asserted its moral right to be     |
|  Fax: +605-566-142              |          identified as the author.        |
 +-------------------Eigi-Eru-Enn-Allir-Jomsvikingar-Daudir!-------------------+