MVSFORUMS.com

js01 · Posted: Fri Jul 10, 2009 2:31 pm Post subject: Maching records using sort

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:

kolusu · Posted: Fri Jul 10, 2009 4:01 pm Post subject:

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

js01 · Posted: Mon Jul 13, 2009 8:52 am Post subject:

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

kolusu · Posted: Mon Jul 13, 2009 11:09 am Post subject:

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

js01 · Posted: Mon Jul 13, 2009 12:37 pm Post subject:

thank you