Page 1 of 1

Sort Technique

PostPosted: Fri Dec 25, 2009 8:42 pm
by syannigeri
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

Re: Sort Technique

PostPosted: Sat Dec 26, 2009 11:10 pm
by Frank Yaeger
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.