Tool for VSAM connection and File comparison

Post your questions related to VSAM

Moderator: Moderator Group

Post Reply
Aravindgk
Member
Posts: 2
Joined: Wed Sep 08, 2010 11:23 am

Tool for VSAM connection and File comparison

Post by Aravindgk » Wed Sep 08, 2010 11:39 am

In one of our projects, we are testing data integrity of extract files. The extract files are created from Mainframe VSAM files by batch programs. Testing is being done by comparing Extract file data with VSAM data. Testing environment is Windows environment where we use Hummingbird Terminal Emulator and TSO/ISPF and File-Aid to view data on screen and compare the same.



We are looking to automate this data/file comparison process. Is there any way/tool through which we can connect to Mainframe environment from Windows environment, fetch VSAM and Extract File data, compare the data and write results to an output file?

User avatar
Natarajan
Moderator
Posts: 537
Joined: Fri Oct 10, 2008 12:57 pm
Location: chennai
Contact:

Post by Natarajan » Thu Sep 16, 2010 2:35 pm

Using VB.net , you can connect to mainframes and get the files you want.
(or) you can use FTP tool to get the data to windows.
Natarajan
Chennai

Aravindgk
Member
Posts: 2
Joined: Wed Sep 08, 2010 11:23 am

Post by Aravindgk » Thu Sep 16, 2010 3:30 pm

How do we connect using VB.Net? Which FTP tool? Can you explain in detail?

Thanks,
Aravind

User avatar
Natarajan
Moderator
Posts: 537
Joined: Fri Oct 10, 2008 12:57 pm
Location: chennai
Contact:

Post by Natarajan » Thu Sep 16, 2010 3:56 pm

I dont have much knowledge on VB.net, i know, in some of the project in our company they does VB programming to connect to mainframe to get the data.

From mainframes using FTP utility , we can FTP /NDM the files to other systems.
we may need to use that method to transfer the file mainframe to other systems.
Natarajan
Chennai

nsaleh
Member
Posts: 1
Joined: Fri Nov 05, 2010 5:35 am

Post by nsaleh » Fri Nov 05, 2010 5:46 am

Microsoft's Host Integration Server (HIS) includes OLEDB and ADO.NET providers for Host File access to access datasets and flat files on the z/OS and i5/OS.

You can get more details at: http://www.microsoft.com/biztalk/en/us/ ... ation.aspx

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others