|
View previous topic :: View next topic
|
| Author |
Message |
sadashiv.a.bhosure
New User
Joined: 01 Feb 2007
Posts: 15
Location: india
|
|
|
|
Hi,
I am facing problem while sorting & matching sorted files.
for ex.
file1 : contain left align alphnumeric number
file1 : contain right align number
suppose file1,file2 contain
1
1
2
15 data, after sorting file1 file on above field o/p file contain sorted data as 1,1,15,2
and after sorting file2 on above field it gives 1,1,2,15 hence two output file does not matches.
Could anyone please help me how to handle this situaion...... |
|
| Back to top |
|
 |
sadashiv.a.bhosure
New User
Joined: 01 Feb 2007
Posts: 15
Location: india
|
|
|
|
| Code: |
filed 1 field2 (left align alphanumeric number).
abcde 1
xyaaa 2
xyaaa 15
xyaaa 1
|
I want to sort above file on filed1 and field2 simaltaneously.
O/p should be
| Code: |
abcde 1
xyaaa 1
xyaaa 2
xyaaa 15
|
I want treat left align alphnumeric number as an integer. |
|
| Back to top |
|
|
guptae
Moderator
Joined: 14 Oct 2005
Posts: 1208
Location: Bangalore,India
|
|
|
|
Hi there,
Try this DFSORT statement:
| Code: |
//SYSIN DD *
SORT FIELDS=(1,5,CH,A,6,2,UFF,A)
/*
|
|
|
| Back to top |
|
|
sadashiv.a.bhosure
New User
Joined: 01 Feb 2007
Posts: 15
Location: india
|
|
|
|
| Thank you very much Ekta.... |
|
| Back to top |
|
|
sadashiv.a.bhosure
New User
Joined: 01 Feb 2007
Posts: 15
Location: india
|
|
|
|
| It's working fine Thanks a lot. |
|
| Back to top |
|
|
sadashiv.a.bhosure
New User
Joined: 01 Feb 2007
Posts: 15
Location: india
|
|
|
|
| Hi Ekta, Can you tell me what is the meaning of 'UFF' ? |
|
| Back to top |
|
|
guptae
Moderator
Joined: 14 Oct 2005
Posts: 1208
Location: Bangalore,India
|
|
| Back to top |
|
|
|
|
