creating new field using sort.

Rambhupal.chaudari · New User Joined: 30 Mar 2007 Posts: 25 Location: Hyderabad

Hi ALL,

Please help me in achieving below query.

I/p file format :-
EMP.no EMPname Salary
1 Ram 1000
2 Sam 200
1 Ram 900
3 Tom 200
4 Jam 100
2 Sam 1200

If you find any duplicates (Key fields are Emp No and Emp Name), the Indicator should be set to 'Y', otherwise, 'N'. The output should be in ascending order of Key.

O/P file format :-
EMP.no EMPname Salary Indicator
1 Ram 1900 Y
2 Sam 1400 Y
3 Tom 200 N
4 Jam 100 N

I want to get the above output file from given input, Using sort utility, with any number of steps.

I got the output with out the new field 'indicator'.

Please let me know any suggestions.

Thanks,
Ram.

Escapa · Posted: Thu Mar 25, 2010 4:41 pm

Rambhupal.chaudari · New User Joined: 30 Mar 2007 Posts: 25 Location: Hyderabad

Hi Sambhaji,

Here is my sysin , just to sum sal field.

Skolusu · Posted: Thu Mar 25, 2010 9:46 pm

Rambhupal.chaudari,

Use the following DFSORT JCL

Rambhupal.chaudari · New User Joined: 30 Mar 2007 Posts: 25 Location: Hyderabad

Thank you very much Skolusu,

Its really nice logic. Amazing ..

thnks again,
Ram..