Home      Mainframe Forum      Mainfarme Tutorials      IBM Manuals      Mainframe Interview Questions      Mainframe Books      IT News     SiteMap     Downloads


     
 
MAINFRAME - TIP OF THE DAY : Sometimes it might be helpful to see only 1 or a few records in HEX (rather than the entire file w/ HEX ON). When VIEWing or EDITing a file use the line command HX to show that line in HEX. To show 3 records, enter HX3. To turn the hex off enter HX (for 1) or HX3 (for 3). Or in the Command area, enter HEX OFF.

Google
 
Web mainframegurukul.com

SORT for 2 files

 
Post new topic   Reply to topic    mainframegurukul.com Forum Index -> DFSORT , ICETOOL & Utilities
  View previous topic :: View next topic  
Author Message
Masquerador_93
Member


Joined: 25 Oct 2016
Posts: 4

Answer was approved by Question owner.
Useful Post
0 votes
Not an useful post
Greate Post!! Salute Author
0 salutes

PostPosted: Tue Oct 25, 2016 9:39 pm    Post subject: SORT for 2 files Reply with quote

Hi I need to compare two files using SORT utility like...

File 1
id name no time date address bala
1 sdbskafjo 456 12 12302009 nejfirejt 1000
2 narjweop 678 24 12312010 dfngijreo 2000
4 mnjdjhdj 956 08 12082012 asefgrg 950

File2
id name no time date address bala
1 sdbskafjo 456 12 12302009 nejfirejt 200
2 narjweop 678 24 12312010 dfngijreo 300
3 abcdefgh 362 15 12302010 asdafggf 80


Now I want the o/p as..

id name Time no date address bala
1 sdbskafjo 12 456 12302009 nejfirejt 800
2 narjweop 24 678 12312010 dfngijreo 1700
4 mnjdjhdj 956 08 12082012 asefgrg 950
3 abcdefgh 362 15 12302010 asdafggf 80

Here we have to rearrange one of the column field in the output (like time & no have been interchanged) and also the difference between the last column for a match has to be obtained.
Comparison is done between all the columns (id, name, no , time,date and address) except the bala column.
Back to top
View user's profile Send private message
Click here, If this post answer your question. <-- Click on right mark icon. If this post answer your question.

Masquerador_93
Member


Joined: 25 Oct 2016
Posts: 4

Answer was approved by Question owner.
Useful Post
0 votes
Not an useful post
Greate Post!! Salute Author
0 salutes

PostPosted: Tue Nov 08, 2016 2:59 pm    Post subject: Reply with quote

Somebody please help me with this!!!
Back to top
View user's profile Send private message
Click here, If this post answer your question. <-- Click on right mark icon. If this post answer your question.
magesh_j
Member


Joined: 31 Aug 2016
Posts: 16

Answer was approved by Question owner.
Useful Post
0 votes
Not an useful post
Greate Post!! Salute Author
0 salutes

PostPosted: Thu Nov 17, 2016 9:53 pm    Post subject: Reply with quote

Start using code tag like below
Code:

1 SDBSKAFJO 456 12 12302009 NEJFIREJT 1000
2 NARJWEOP  678 24 12312010 DFNGIJREO 2000
4 MNJDJHDJ  956 08 12082012 ASEFGRG   950

Code:

1 SDBSKAFJO 456 12 12302009 NEJFIREJT 200     
2 NARJWEOP  678 24 12312010 DFNGIJREO 300     
3 ABCDEFGH  362 15 12302010 ASDAFGGF  80     


what should be the output if there is a mismatch in any of the column.

Thanks
Magesh
Back to top
View user's profile Send private message
Click here, If this post answer your question. <-- Click on right mark icon. If this post answer your question.
Masquerador_93
Member


Joined: 25 Oct 2016
Posts: 4

Answer was approved by Question owner.
Useful Post
0 votes
Not an useful post
Greate Post!! Salute Author
0 salutes

PostPosted: Wed Nov 23, 2016 6:33 pm    Post subject: Reply with quote

Hi Magesh


Code:

1 SDBSKAFJO 456 12 12302009 NEJFIREJT 800
2 NARJWEOP  678 24 12312010 DFNGIJREO 1700
4 MNJDJHDJ  956 08 12082012 ASEFGRG   950
3 ABCDEFGH  362 15 12302010 ASDAFGGF  80 


Mismatch in any of the column will be a new entry in the output file.

Thanks.

you must also UNCHECK the Disable BBCODE
Back to top
View user's profile Send private message
Click here, If this post answer your question. <-- Click on right mark icon. If this post answer your question.
Masquerador_93
Member


Joined: 25 Oct 2016
Posts: 4

Answer was approved by Question owner.
Useful Post
0 votes
Not an useful post
Greate Post!! Salute Author
0 salutes

PostPosted: Mon Jan 02, 2017 4:21 pm    Post subject: Reply with quote

Any help with this one??!!
Back to top
View user's profile Send private message
Click here, If this post answer your question. <-- Click on right mark icon. If this post answer your question.
Display posts from previous:   
Post new topic   Reply to topic    mainframegurukul.com Forum Index -> DFSORT , ICETOOL & Utilities All times are GMT + 5 Hours
Page 1 of 1



 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Cobol Tutorial
This cobol tutorial covers most of the important topics like STRING, UNSTRING, COMP, COMP-3.....
DB2 Tutorial
DB2 Tutorial focuses on DB2 COBOL Programming. Explains in simple language. Some Chapters are locked, Forum members have free access to these chapters
CICS Tutorial
This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming...
JCL Tutorial
This is most popular JCL tutorial from mainframegurukul. It does contain important jcl ....
SORT Tutorial
This Tutorial covers all important aspects of DFSORT. Has more SORT examples
INTERVIEW Questions
This page covers important interview questions
Mainframe Jobs
Mainframe Jobs posted by members of mainframegurukul forum
FaceBook Page
MainframeGurukul FaceBook Page
LinkedIn Page
MainframeGurkul Linkedin Page

This widget requires Flash Player 9 or better







Go to top of the page
 

Online ABEND Reference ||  JCL References ||  COBOL References ||  VSAM References ||  Tutorials by Drona Series ||  SQL tutorial ||  BOOKS  ||  DB2 INTERVIEW QUESTIONS ||  COBOL INTERVIEW QUESTIONS  ||  JCL INTERVIEW QUESTIONS ||  JCL2 INTERVIEW QUESTIONS ||  VSAM INTERVIEW QUESTIONS ||  CICS INTERVIEW QUESTIONS  ||  Online tutorials ||  Online ABEND Reference ||  JCL References ||  COBOL References ||  VSAM References ||  Tutorials by Drona Series ||  SQL tutorial ||  BOOKS  ||  SiteMap  ||  Expeditor Tutorial  ||  FILE-AID Tutorial  ||  Changeman Tutorial  ||  COBOL   ||  DB2   ||  JCL  ||  CICS  ||  VSAM  ||  DB2 Interview Questions ( 110 )   || Simple JCL Tutorials  || JCL Tutorial from MainframeGurukul.com   || Simple JCL Tutorial - Chapter1 ;|| Mainframe Forum - Tutorials  || Mainframe Tutorials || Mainframe CICS tutorial|| Mainframe COBOL Tutorial

Drona Educational Forums - Mainframe Cobol DB2 CICS Board
Powered by phpBB