Thanks for the information. How does your mainframe guy
get the data out of IMS?
Thanks,
Ken
We do not pull data directly from IMS but load it in batch jobs. Our
mainframe guy either dumps the data report-style (ASCII) or copies records
in native EBCDIC to files on the mainframe. We ftp
Thanks for the help. How did you create the flat files?
How did you get the data out of IMS and into the flat
files? TCP/IP or SQL Loader or what?
Thanks,
Ken
I did it by creating flat files containing only character data (no packed
fields),
and using sqlloader to load the data.
I
Thanks for the help. Oracle will be located on a W/2000
box.
Could you go into more detail on how one exports data
from IMS on the mainframe to flat textfiles?
Thanks,
Ken
If you export the IMS data out to flat textfiles,
and then transfer them via ftp in ASCII mode, the
We do not pull data directly from IMS but load it in batch jobs. Our
mainframe guy either dumps the data report-style (ASCII) or copies records
in native EBCDIC to files on the mainframe. We ftp them to the Oracle side
(binary mode to EBCDIC files) and use sql loader to move into Oracle. On
If you export the IMS data out to flat textfiles,
and then transfer them via ftp in ASCII mode, the
conversion will be done automagically for you.
Alternatively if on Unix the dd utility will
do the conversion for you.
HTH YMMV!
[EMAIL PROTECTED] wrote:
I may be moving data from an IMS db
Thanks for the info. The Oracle DB will be on W/2000.
Ken Janusz, CPIM
If you export the IMS data out to flat textfiles,
and then transfer them via ftp in ASCII mode, the
conversion will be done automagically for you.
Alternatively if on Unix the dd utility will
do the conversion for
I did it by creating flat files containing only character data (no packed
fields),
and using sqlloader to load the data.
I think the only thing Oracle didn't know how to convert was the verticle bar
( | )
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mike J
If you export the IMS data out to flat textfiles,
and then transfer them via ftp in ASCII mode, the
conversion will be done automagically for you.
Alternatively if on Unix the dd utility will
do the conversion for you.
One problem that we encountered with using dd to convert EBCDIC to
yes, if you set the character set to ebcdic (CHARACTERSET WE8EBCDIC500) so
that it can read the incoming file
-Original Message-
Sent: Friday, August 17, 2001 11:50 AM
To: Multiple recipients of list ORACLE-L
Thanks for the information. The IMS data will have to
be cleansed before it