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, t
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.
>
>
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
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
>
> 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 conve
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 Kurth
Thanks for the information. The IMS data will have to
be cleansed before it is loaded into Oracle (8.1.? on
W/2000). So there will be some intermediate
files/tables that will be used for this purpose.
Will sqloader convert EBCDIC to ASCII?
Thanks,
Ken Janusz, CPIM
> We do not pull data d
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 convers
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
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
the
10 matches
Mail list logo