IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Matching and un matching records


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
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
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
Reply with quote

rswathi_1208,

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

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: 3156
Location: Tucson AZ

PostPosted: Wed Jun 23, 2010 10:45 pm
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
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

Moderator Emeritus


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

PostPosted: Thu Jun 24, 2010 1:02 am
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 Developer


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

PostPosted: Thu Jun 24, 2010 1:48 am
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts Compare 2 files and retrive records f... DFSORT/ICETOOL 0
No new posts Compare 2 files(F1 & F2) and writ... JCL & VSAM 8
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Pulling a fixed number of records fro... DB2 2
No new posts Join multiple records using splice DFSORT/ICETOOL 5
Search our Forums:

Back to Top