how to limit SyncSort comparision ?

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
uthami
Member
Posts: 5
Joined: Thu Aug 06, 2009 9:35 pm

how to limit SyncSort comparision ?

Post by uthami » Fri Aug 07, 2009 6:24 pm

I have two big files to be compared using SyncSort utility. But i need to compare only the first ten lines of both files. Please help me to achieve this..

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

Post by arcvns » Sat Aug 08, 2009 2:21 pm

uthami,

You can do file comparison using the JOIN feature available in SyncSort. But it's not quite clear what exactly you're expecting in output here. Please provide a few more details.

1)RECFM/LRECL of input as well as output files
2)Starting position and length of key field in the input files.
3)Do you have duplicates in the key field for input-1?
4)Do you have duplicates in the key field for input-2?
5)If matched, what fields you want in the output and from which files?

It would be better if you can provide some sample records from both the input files and the expected output using "Code" tags.
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