IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

ODBC connection to VSAM files


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Fathy Soliman

New User


Joined: 12 Aug 2008
Posts: 1
Location: Egypt

PostPosted: Wed Aug 13, 2008 2:56 pm
Reply with quote

Need technical procedure to connect to VSAM files and work with it as db2 tables usnig SQL/DML, from my searches i found many products that can do the job like Websphere classic connect 9.1 and db2 connect, Can anyone till me How technically could it be done both from servers side (Zos ver 1.4) and from client side (windows) ? and is there a freeware ODBC for this ?
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


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

PostPosted: Wed Aug 13, 2008 10:21 pm
Reply with quote

Hello,

I am not aware of any products that access vsam files using db2 sql/dml.

While you may connect to vsam remotely, i am not aware of any software to do this for free.

If you explain your requirement (not how you want to solve it), someone may have a suggestion.
Back to top
View user's profile Send private message
stodolas

Active Member


Joined: 13 Jun 2007
Posts: 632
Location: Wisconsin

PostPosted: Thu Aug 14, 2008 5:57 am
Reply with quote

tcExpress and tcAccess are 2 products that may help.

I know one of them does map VSAM to SQL notation from a Windows machine. Someone has to manually map the copybook for each VSAM to an column name to be used via SQL though.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Write line by line from two files DFSORT/ICETOOL 7
No new posts Access to non cataloged VSAM file JCL & VSAM 18
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Merge two VSAM KSDS files into third ... JCL & VSAM 6
No new posts Joinkeys - 5 output files DFSORT/ICETOOL 7
Search our Forums:

Back to Top