comparing two VSAM files

In this Mainframe Forum - You can post your queries on JCL, OS/390 JCL, MVS JCL, z/OS JCL, JES2 & JES3

Moderators: Frank Yaeger, DikDude, Moderator Group

Post Reply
srikanth176003
Member
Posts: 3
Joined: Wed Jun 24, 2009 8:46 pm

comparing two VSAM files

Post by srikanth176003 » Wed Jun 24, 2009 9:18 pm

i need o compare two VSAM files. iam giving one input file and it is modifying and giving an output file. now i have to compare t he output with input for one field value. please suggest me a JCL

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

Post by Natarajan » Thu Jun 25, 2009 11:23 am

You can use EASYTRIEVE for this purpose.
Natarajan
Chennai

srikanth176003
Member
Posts: 3
Joined: Wed Jun 24, 2009 8:46 pm

Comparison of two VSAM files

Post by srikanth176003 » Thu Jun 25, 2009 11:26 am

Thanks for the reply Natarajan,
Can u Please provide any sample JCL if possible.

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

Post by Natarajan » Fri Jun 26, 2009 10:48 am

Right now i am busy with my work to give full solution on this.
I can provide it in 2 to 3 days.


DFSORT guru's may provide some solution on this.....
Natarajan
Chennai

User avatar
Frank Yaeger
Moderator
Posts: 812
Joined: Sat Feb 18, 2006 5:45 am
Location: San Jose, CA
Contact:

Post by Frank Yaeger » Fri Jun 26, 2009 8:19 pm

The OP hasn't given enough information for me to help (I don't know what the input files look like or what exactly is expected for output).

Also, since the OP posted in the JCL Forum rather than in the DFSORT Forum, I assume he doesn't want a DFSORT solution.
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort

srikanth176003
Member
Posts: 3
Joined: Wed Jun 24, 2009 8:46 pm

Comparison of two VSAM files

Post by srikanth176003 » Sat Jun 27, 2009 3:54 pm

Thanks Natarajan. I will search in the path which you mentioned and please try to post the solution whenever you are free.

Hi Frank.. Thanks for the reply. we are updating one INDICTOR field in the input VSAM file and the updated records are writing into the output VSAM file. now we need to compare both the i.p & o/p whether the INDICATOR field getting updated or not.

please let me know if you need more information. :roll:

User avatar
dbzTHEdinosauer
Moderator
Posts: 981
Joined: Mon Oct 02, 2006 8:31 pm

Post by dbzTHEdinosauer » Sat Jun 27, 2009 5:13 pm

Frank wrote:I don't know what the input files look like or what exactly is expected for output).
Dick Brenholtz
JCL, SQL and code in programs have an irritating habit of doing what you say,
not what you meant.

User avatar
Frank Yaeger
Moderator
Posts: 812
Joined: Sat Feb 18, 2006 5:45 am
Location: San Jose, CA
Contact:

Post by Frank Yaeger » Sat Jun 27, 2009 10:45 pm

And:
Also, since the OP posted in the JCL Forum rather than in the DFSORT Forum, I assume he doesn't want a DFSORT solution.
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort

User avatar
arcvns
Member
Posts: 28
Joined: Sat May 30, 2009 10:19 pm
Location: Chennai, India

Post by arcvns » Wed Jul 01, 2009 8:09 am

srikanth176003,

Which sort poduct do you use- DFSORT or SyncSort? You can find this information in the SYSOUT of any sort run.
we are updating one INDICTOR field in the input VSAM file and the updated records are writing into the output VSAM file. now we need to compare both the i.p & o/p whether the INDICATOR field getting updated or not.
Which process is doing the VSAM update here. Why not write this information in another file while you perform an update rather than doing a comparison after the whole update process. You need to provide more details on the process involved.
Arun

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