VSAM - Flat File comparison



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

Re: VSAM - Flat File comparison

Postby sudhirbabu149 » Fri Oct 28, 2011 12:44 pm

Thanks for your inputs Billy.

Will try and let you guys know the result.


Thanks.
sudhirbabu149
 
Posts: 7
Joined: Sat Oct 22, 2011 6:59 pm
Has thanked: 0 time
Been thanked: 0 time

Re: VSAM - Flat File comparison

Postby sudhirbabu149 » Sun Nov 06, 2011 12:29 pm

Hi Frank,

Thanks a lot and this worked well...
But a small doubt though...

here,

  JOIN UNPAIRED,F1
  REFORMAT FIELDS=(F1:1,4,?,F1:5)
  OPTION COPY
  OUTFIL FNAMES=MATCH,INCLUDE=(5,1,CH,EQ,C'B'),
    BUILD=(1,4,5)


as the 5th char is a B or 1, the BUILD should have been... (1,4,6), I suppose.
Is this right Frank..

Thanks again 8-)
sudhirbabu149
 
Posts: 7
Joined: Sat Oct 22, 2011 6:59 pm
Has thanked: 0 time
Been thanked: 0 time

Re: VSAM - Flat File comparison

Postby Frank Yaeger » Mon Nov 07, 2011 11:42 pm

as the 5th char is a B or 1, the BUILD should have been... (1,4,6), I suppose.
Is this right Frank..


Yes, that's correct. I didn't notice the extra character in the output.

I've corrected my post above.
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
User avatar
Frank Yaeger
Global moderator
 
Posts: 1079
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 15 times

Previous

Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post