How to convert VSAM 2 DB2?

greenspun.com : LUSENET : DBAzine : One Thread

Our system is currently having the DATA on VSAM files.We are using the EZT to retrive the data for any reports on client request.For this we used to run a program to which will give us a flat file and depending on that we generate the reports.

Now my question is,is there any way to convert this flat file in to a table (either DB2/ORACLE)so that we can write the SQL query to get our reports.

Ex:After running the program we will get the flat file like below.

12345 xxyyzz etc. 12346 xxyyzz Etc.

Then we will write the EZT to list the details.

Key(emp#) copy book 12345 xxyyzz where xx->salary field yy-DOB etc.. 12346 xxyyzz

Finally my intention is I want to map the data from the above flat file with a table(which was the copy book in cobol).

-- krishna (nandy0404@yahoo.com), June 03, 2004


Moderation questions? read the FAQ