Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

DB2 to VSAM convertion

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
rdr

New User


Joined: 26 May 2006
Posts: 35
Location: india

PostPosted: Tue Aug 05, 2008 5:39 pm    Post subject: DB2 to VSAM convertion
Reply with quote

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.
Back to top
View user's profile Send private message

Craq Giegerich

Senior Member


Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA

PostPosted: Tue Aug 05, 2008 5:47 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
ashimer

Active Member


Joined: 13 Feb 2004
Posts: 551
Location: Bangalore

PostPosted: Tue Aug 05, 2008 6:08 pm    Post subject:
Reply with quote

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 ...
Back to top
View user's profile Send private message
rdr

New User


Joined: 26 May 2006
Posts: 35
Location: india

PostPosted: Wed Aug 06, 2008 11:04 am    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
stodolas

Active Member


Joined: 13 Jun 2007
Posts: 632
Location: Wisconsin

PostPosted: Thu Aug 07, 2008 6:41 am    Post subject:
Reply with quote

ug, Going back to VSAM from DB2, yuck
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Aug 07, 2008 7:04 am    Post subject:
Reply with quote

Hello,

Has anyone explained how this decision was reached?
Back to top
View user's profile Send private message
rdr

New User


Joined: 26 May 2006
Posts: 35
Location: india

PostPosted: Mon Aug 11, 2008 5:06 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Updating a VSAM file with DISP=OLD sheersh JCL & VSAM 8 Tue Mar 14, 2017 6:14 pm
No new posts SORT VSAM file with each field one by... maxsubrat DFSORT/ICETOOL 6 Tue Mar 14, 2017 1:07 pm
No new posts VSAM RLS=NRI while doing IDCAMS sheersh JCL & VSAM 1 Tue Mar 07, 2017 1:55 pm
No new posts Fail to change physical VSAM filename... jacobdng CICS 7 Fri Jan 20, 2017 12:36 pm
No new posts how to recover an uncataloged VSAM da... archanamuthukrishnan All Other Mainframe Topics 4 Wed Jan 11, 2017 6:18 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us