Hi,
I assume Oracle is running on a different hardware box than IBM mainframe.
You can use IDCAMS utilities on MVS such as EXPORT or REPRO to export a VSAM
file into a Flat file then use SORT utility to sort this flat file...Then
use 3270 emulator's tools to ftp this flat file to your pc or the unix box
which Oracle is running on. If you know the record structure of the VSAM
file you exported then it is only a trivial work to write a SQL to read this
file into Oracle table...The other method would be: writing a COBOL program
to read from VSAM to write to a Flat file...
Andrew E.
If you know the record stucture
"NetComrade" <andreyNSPAM_at_bookexchange.net> wrote in message
news:3f21aabd.347726714_at_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 Sun Jul 27 2003 - 05:04:49 CDT
