Hi
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:[EMAIL PROTECTED]
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 suggestdirect 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 theDeveloper/DBA mentions them somewhere.HTHGovindanK
<-----Original Message----->
From: Muqthar Ahmed
Sent: 9/30/2003 12:16:28 PM
To: [EMAIL PROTECTED]
Subject: Re: COBOL TO ORACLE
Hi,
Thanks
Muqthar Ahmed
DBA
Author: Muqthar Ahmed
INET: [EMAIL PROTECTED]
.
_______________________________________________________________
Get Your 10MB account for FREE at http://mail.arabia.com !
Access MILLIONS of JOBS NOW!