How can we extract data from IMS DB and load it onto oracle
database by converting it.Pls someone help me

Answers were Sorted based on User's Feedback



How can we extract data from IMS DB and load it onto oracle database by converting it.Pls someone ..

Answer / vijay kumar reddy

by using the cursor we can take the data from ims data base
and store it in a flat file.then using the application
program read the records from flat file and insertb in
oracle,

Is This Answer Correct ?    0 Yes 0 No

How can we extract data from IMS DB and load it onto oracle database by converting it.Pls someone ..

Answer / ankur shahi

We can read a data from IMS DB by through application
program then through SFTP we can convert that data into flat
file and load it into oracle.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More IBM MainFrame AllOther Interview Questions

what is copybooks ? structure of copybook and fillers in copybook ? purpose of using copybook ?

2 Answers   Tech Mahindra,


Define where and its usage?

0 Answers  


What is the function of the verb initialize?

0 Answers  


This was on MQseries. What does MQ queue Manager do? what are the different types of queues? do you know about remote queues etc. How do you delete records from queues? how do you empty queues?

1 Answers  


What is the function of currentdata option in bind?

0 Answers  






suppose I have 1000 rows in a db2 table. I want to update first 100 records, how do I do it?

0 Answers   IBM,


what is the msg id for   OPNQRYF?

1 Answers  


what are the present versions of all mainframe modules?can any body let me know pls

1 Answers  


List the type of locks and explain each of them.

0 Answers  


suppose if you added a coloumn to db2 table, How would it be the Impact analysis?

0 Answers  


which of the following is not true about search verb A) every search stmt must contain the AT END clause B) any no of WHEN clause can be used with this verb C) this verb can only applied to a table which is defined with the OCCURS clause and INDEXED phases. D) WHEN condition is satisfied

2 Answers   Accenture,


How to compare two files by using sort?

0 Answers  


Categories