Oracle-L: AW: COBOL TO ORACLE

From: Stefan Jahnke <Stefan.Jahnke_at_bov.de>
Date: Wed, 01 Oct 2003 00:09:32 -0800
Message-ID: <F001.005D18CB.20031001000932@fatcity.com>

I'm basically doing the same: We're using PL1 programs to do an "unload" of VSAM files by hand. That actually takes care of multiple record structures and the like. It's a poor-man's normalisation of VSAMs ;). Then, just load the data as it is into a staging DB (Oracle), transform it and push it into the production DB (also Oracle).

What I don't understand about the original eMail is the COBOL to Oracle part, but relating to the data ?! I guess moving the HOST based data was meant ?

And regarding to connecting to VSAM or the like directly from Designer (via reading the copy books for instance), ... it either doesn't exist or we didn't find it ;). I opt for the first.

PS: Having to use Oracle Designer is about as cool as crucification.

Stefan

-----Ursprüngliche Nachricht-----
Von: Govindan K [mailto:gkatteri_at_omanmail.com] Gesendet: Mittwoch, 1. Oktober 2003 02:04 An: Multiple recipients of list ORACLE-L Betreff: Re: COBOL TO ORACLE

>Is there a tool available to move data from COBOL to ORACLE directly? One
way to do is get COBOL >data on a flat file and then use SQL*Loader to insert into ORACLE tables.

If you are using SQL*Loader make sure to check the log after load. For larger loads i would suggest
direct load.

>The second question is did anyone use DESIGNER to connect to COBOL to
create an ERD and then >transform into ORACLE tabels script?

I wonder how a tool will take care of Implicit Redefinition/Multiple Record Structures unless the
Developer/DBA mentions them somewhere.

HTH
GovindanK

<-----Original Message----->

From: Muqthar Ahmed
Sent: 9/30/2003 12:16:28 PM
To: ORACLE-L_at_fatcity.com

Hi,

Thanks
Muqthar Ahmed
DBA Author: Muqthar Ahmed
INET: Muqthar.Ahmed_at_decoratetoday.com

Get Your 10MB account for FREE at http://mail.arabia.com ! <http://ads.arabia.com/?SHT=text_email_english> Access MILLIONS of JOBS NOW!

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stefan Jahnke
  INET: Stefan.Jahnke_at_bov.de

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Wed Oct 01 2003 - 03:09:32 CDT