MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Maching records using sort

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Utilities
View previous topic :: View next topic  
Author Message
js01
Beginner


Joined: 13 Oct 2005
Posts: 84
Topics: 32
Location: INDIA

PostPosted: Fri Jul 10, 2009 2:31 pm    Post subject: Maching records using sort Reply with quote

Hi,

i want a record that has same word in both files and remaning should be in other files , could you please help me on this

example:

INF1:
Code:

AA SS YYYYYY12839
BA XS ZZZZZ14339
Q1 AS XXXXXX12839

INF2:
Code:

12 WWASDSDASDYYYYYYY9898
YT ASADFFDXXXXXX232
TT ERERFT DERETTTTRER


OUTPUT SHOULD BE

OUT1: (MATCHING RECORDS)
Code:

AA SS YYYYYY12839   ==> 'YYYYYY' MACTHED IN BOTH FILES
Q1 AS XXXXXX12839 ==>  'XXXXX'  MACTHED IN BOTH

OUT2 : (NOT MACTHED FROM INF1)
Code:

BA XS ZZZZZ14339

OUT3 : (NOT MACTHED FROM INF2)
Code:

TT ERERFT DERETTTTRER
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose

PostPosted: Fri Jul 10, 2009 4:01 pm    Post subject: Reply with quote

js01,

Looks like the matching key both files is a variable field? ie it can occur anywhere in the record? Is that right?

Sort products do not have the capability of looking up and matching the key anywhere in the record.
_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
js01
Beginner


Joined: 13 Oct 2005
Posts: 84
Topics: 32
Location: INDIA

PostPosted: Mon Jul 13, 2009 8:52 am    Post subject: Reply with quote

Hi Kolusu,

Yes , you are right ..the matching key can anywhere in the rec , but record length is fixed its 100.

if not possible ,can you please provide a solution if the key at specific position like

1) infile1

AA SS YYYYYY12839
BA XS ZZZZZ14339
Q1 AS XXXXXX12839

2) infile2

12 YYYY9898
YT XXXX232
TT TTTTRER
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose

PostPosted: Mon Jul 13, 2009 11:09 am    Post subject: Reply with quote

js01,

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
_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
js01
Beginner


Joined: 13 Oct 2005
Posts: 84
Topics: 32
Location: INDIA

PostPosted: Mon Jul 13, 2009 12:37 pm    Post subject: Reply with quote

thank you
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> 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


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group