Import into Oracle from Mainframe [message #71357] |
Tue, 22 October 2002 07:17 |
Mike T
Messages: 32 Registered: August 2002
|
Member |
|
|
I'm trying to import datasets from the mainframe into a Oracle database (on Unix). Currently, I'm FTPing the files down to our LAN (NT) and they look all garbled. Apparently that's due to the files being in EBCDIC format and containing packed fields and low values. Can SQL*Loader translate these files or do I have to do it elswhere (on mainframe, pc utility, unix utility, etc.)? Does anyone know of a simple process for moving Mainframe datasets to an Oracle Database?
Thanks in advance!
|
|
|
Re: Import into Oracle from Mainframe [message #71362 is a reply to message #71357] |
Tue, 22 October 2002 07:46 |
B
Messages: 327 Registered: August 1999
|
Senior Member |
|
|
did U use FTP in ascii mode ???
Ftp convert ASCII table, and normally U should already having a translated test. If it doesn't may be U should use a tools t convert it
|
|
|
|