Sort a FB file with two sort conditions.



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

Sort a FB file with two sort conditions.

Postby Surabhi » Thu May 18, 2017 12:07 pm

Hello,

I have a FB input file as mentioned below :-

Type         Code
10000      12345
11000      12345
30000      12345
20000      12345
11000      45624
25000      45624
34000      33669
30000      33669
 

I have a requirement, if first 5 bytes (1,5) of Type is 30000, then for the corresponding code all types should be written to the output file.

Output file:-
Type         Code
10000      12345
11000      12345
30000      12345
20000      12345
34000      33669
30000      33669
 

Could anyone help me with this.

Thank you.

code' d
Surabhi
 
Posts: 44
Joined: Thu Sep 10, 2015 7:51 pm
Has thanked: 3 times
Been thanked: 0 time

Re: Sort a FB file with two sort conditions.

 

Re: Sort a FB file with two sort conditions.

Postby NicC » Thu May 18, 2017 3:48 pm

I do not see any sort conditions here but one selection condition. And no code tags used - why?
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 2634
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisys (almost)
Has thanked: 4 times
Been thanked: 95 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post