Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Matching and un matching records

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
rswathi_1208

New User


Joined: 14 May 2010
Posts: 11
Location: chennai

PostPosted: Wed Jun 23, 2010 10:26 pm    Post subject: Matching and un matching records
Reply with quote

Hi,

I have two input files FileA of length 51 and FileB of length 10.
I want to compare these two files of lenght 1 to 10. I need to write the matching records in one file and not matching records in the another file. Please help.
Back to top
View user's profile Send private message

Skolusu

Senior Member


Joined: 07 Dec 2007
Posts: 2205
Location: San Jose

PostPosted: Wed Jun 23, 2010 10:42 pm    Post subject:
Reply with quote

rswathi_1208,

Check the smart DFSORT trick "Create files with matching and non-matching records" here

http://www.ibm.com/support/docview.wss?rs=0&uid=isg3T7000094
Back to top
View user's profile Send private message
William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3158
Location: Tucson AZ

PostPosted: Wed Jun 23, 2010 10:45 pm    Post subject:
Reply with quote

Just what kind of solution are you looking for, EZT or Sort?
Why haven't you answered Dick's question on your other thread?
Have you done any searching yet? This Sort subject has been asked and answered many times.
Back to top
View user's profile Send private message
rswathi_1208

New User


Joined: 14 May 2010
Posts: 11
Location: chennai

PostPosted: Thu Jun 24, 2010 12:51 am    Post subject:
Reply with quote

Yeah I do searched.But I couldnt get the exact thing what I need. So I have posted separately
Back to top
View user's profile Send private message
dick scherrer

Site Director


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

PostPosted: Thu Jun 24, 2010 1:02 am    Post subject:
Reply with quote

Hello,

Quote:
Yeah I do searched.But I couldnt get the exact thing what I need. So I have posted separately
If you provided the information to the questions asked in your original topic, you would probably have made more progress. . .

Usually, the "exact thing" will not be delivered on a silver plate. You will have to do much of the research and then the work yourself. . .
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Thu Jun 24, 2010 1:48 am    Post subject:
Reply with quote

swathi.r,

Please show an example of the records in each input file (relevant fields only) and what you expect for output. Explain the "rules" for getting from input to output. Give the starting position, length and format of each relevant field. Give the RECFM and LRECL of the input files. If file1 can have duplicates within it, show that in your example. If file2 can have duplicates within it, show that in your example.

Also run the following job and show the //SYSOUT messages you receive so I can see what level you're at:

Code:

//S1    EXEC  PGM=SORT         
//SYSOUT    DD  SYSOUT=*       
//SORTIN DD *                 
RECORD                         
//SORTOUT DD DUMMY             
//SYSIN    DD    *             
    OPTION COPY               
/*                             
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Join giving more records than expected Danielle.Filteau SYNCSORT 2 Thu Mar 09, 2017 3:28 am
No new posts TSO or command line utility to genera... kishpra JCL & VSAM 3 Thu Mar 09, 2017 1:11 am
No new posts Extract set of records matching on ac... bhaskar_kanteti DFSORT/ICETOOL 3 Mon Mar 06, 2017 7:19 am
No new posts Inserting records based on conditions vickey_dw DFSORT/ICETOOL 9 Wed Feb 22, 2017 1:33 pm
No new posts To Merge mutliple records into a sing... anandgbe DFSORT/ICETOOL 6 Wed Feb 22, 2017 8:49 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us