Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 385
  • Last Modified:

how to convert data generated by mainframe to oracle db/

how do i convert the data generated by Unisys A7-411 Mainframe to oracle database?  

thanks so much!
0
altair1975
Asked:
altair1975
  • 2
  • 2
  • 2
1 Solution
 
leolkkCommented:
mainframe! that means it is not a RDBMS database. Maybe convert mainframe data into text file and then using SQL*loader to upload text files into Oracle database. Certainly, tables in ORacle should be defined first.
0
 
altair1975Author Commented:

i already know how to convert from text file to oracle.  but from the data generated by mainframe to text file, that i still don't know how.  will anyone help?

thanks so much!
altair
0
 
lyonstCommented:
Hi,

You could start here ...

http://www.uvsoftware.ca/datacnv3.htm

Hope it helps ?

Cheers,

T.
0
Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

 
lyonstCommented:
Hi,

You can also have a look at

http://www-db.stanford.edu/~ullman/fcdb/oracle/or-load.html

Or you could look at SQL*LOADER which is described here ..

http://www.orafaq.org/faqloadr.htm#WHATIS

SQL*Loader is a bulk loader utility used for moving data from external files into the Oracle database. Its syntax is similar to that of the DB2 Load utility, but comes with more options. SQL*Loader supports various load formats, selective loading, and multi-table loads.

Cheers,

T.

0
 
leolkkCommented:
my experience is that "I need to write program" to change data from Progress database to text file record by record.

0
 
altair1975Author Commented:
thanks!  i'll be doing the conversion in details on Sep.  the references u gave will surely help
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

  • 2
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now