DB2 to VSAM convertion

rdr · New User Joined: 26 May 2006 Posts: 35 Location: india

Hi All,

If I am converting the DB2 code which is having the JOIN statements in it and I want to convert it to VSAM statement how can I go about it.

Thanks & Regards,
RDR.

Craq Giegerich · Posted: Tue Aug 05, 2008 5:47 pm

You can't unless you are going to convert the DB2 tables to VSAM files. Don't even think about trying to bypass DB2 to get at the tables.

ashimer · Posted: Tue Aug 05, 2008 6:08 pm

if you are trying to replicate the scenario of fetching data from 2 tables by joining them then you will have to read one VSAM file and use the keys to get the rest details form the other file ...

rdr · New User Joined: 26 May 2006 Posts: 35 Location: india

Hi Craq,

Yes we are going to have VSAM file structure corresponding to that of DB2 view. And as Ashmir told we can use Primary key to read the file and write into A New File.

Thanks & Regards.
RDR.

stodolas · Posted: Thu Aug 07, 2008 6:41 am

ug, Going back to VSAM from DB2, yuck

dick scherrer · Posted: Thu Aug 07, 2008 7:04 am

Hello,

Has anyone explained how this decision was reached?

rdr · New User Joined: 26 May 2006 Posts: 35 Location: india

Hi All,

There are few legacy DB2 Tables which are not going to be updated in future.
There is a change in Key feild of these tables.
The key lenght is going to be increased in case of VSAM for selected DB2 view.
These VSAM data are needed further down in the batch system.
So new copy book has to be created for the same.

Regards,
Rdr.