Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> VSAM files to Oracle (or other RDMS)

VSAM files to Oracle (or other RDMS)

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Fri, 25 Jul 2003 22:15:30 GMT
Message-ID: <3f21aabd.347726714@nyc.news.speakeasy.net>


Is there are a good document describing how to convert files from VSAM
(mainframe) to Oracle?

Are there are any straightforward caveats? My understanding is, there is a possibility to have rows in VSAM files that are different in structure from other rows. How does one get around that?
What would be the best method of extraction? (Pro*Cobol?) What are the best 'practices' to convert the files into decent relational tables?
Are there are any books available?
The best info would be for somebody who knows VSAM well, but Oracle
(or any relational DB) not so much, beyond concepts.
Any pointers, links, success/horror stories are greatly appreciated.

Thanks in advance
.......
We use Oracle 8.1.7.4 on Solaris 2.7 boxes remove NSPAM to email Received on Fri Jul 25 2003 - 17:15:30 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US