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

which are the following verb can be used to manipulate the value of an index name A) ADD B) MOVE C) SUBTRACT D) SET

3 Answers   Accenture,


suppose I have two tables a and b. Both tables are connected with ssn number as foreign key. I want to retrieve a column data from b table. How will you write a query?

0 Answers   IBM,


we cant write data into file using cl program then what is sndf

0 Answers  


difference between MSGSFL AND SFL?

1 Answers  


How do you use sub-string as a Pseudo-variable in PL/1? How can we use the variables?

1 Answers   IBM,






What is the difference between Verify & Index in PL/1?

2 Answers   IBM,


I want to increse the size of one existing dataset, can anyone tell me the TSO command throgh that I can edit it.

4 Answers   Xansa, HCL,


Hi all, I have >200 members per Dataset, I need to delete 2 lines from all members of a Dataset. To do Manually it is difficult. So please tell me simple method. is there any Tool or........

2 Answers  


How to move a field DT 9(8) of input file to DT 9(8) COMP-3 in output file in ezytrieve? in the output file entire dt is not moved.If any answer plz reply as soon as possible.

0 Answers  


Determine the total no of bytes in the following 01 rec1 . 02 a pic x(6). 02 b redefines a. 03 c occurs 6 times pic 9. 02 d occurs 4 times. 03 e pic x(5). 03 f pic 999. a)38. b)44 c)14 d)32

3 Answers   Accenture,


how do u start your process after conducting impact analysis ?

0 Answers   TCS,


what error do we get in prodution support and questions on production support

2 Answers  






Categories