Sort Technique



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

Sort Technique

Postby syannigeri » Fri Dec 25, 2009 8:42 pm

Hi,

Can i know the sort card for the below,

I have records as follows...

Num1 status
111 A
111 A
111 d
222 d
222 d
333 a
444 a
444 a
444 a

What i need is,
1. In one file, I need all the Coloums of Num1 for which Status is same( i.e 222 & 333 & 444),
2. In another file i need, all coloums of num1 for which status is different(I.e 111)

Let me know how to write this sort step.

Thanks
Shankarhgouda
syannigeri
 
Posts: 20
Joined: Tue Dec 22, 2009 11:27 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Sort Technique

Postby Frank Yaeger » Sat Dec 26, 2009 11:10 pm

What is the RECFM and LRECL of the input file?

What is the starting position, length and format of each input field?

It's not clear what exactly you want for output. Please show the expected output files for your example input and explain the rules for getting from input to output with respect to the example.
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


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post