avinash sengar
New User
Joined: 13 May 2010 Posts: 16 Location: hyderabad
|
|
|
|
I have a flat file that need to be sorted on below order
1.Medicaid ID - ascending order
2. Trasaction_number - ascending order
3.Transaction_type - ascending order(We need to order by 004,024,021,001,030)
can we achieve it by using any sort jcl?
(becoz the order we need for transaction type is not in ascending order)
its a kind of additional order we require.
please suggest me how we can achieve this using DFSORT in jcl
Code: |
Medicaid Trans No Trans Type
1234 1 1
1234 1 1
1234 1 4
1234 1 21
1234 1 21
1234 1 24
1234 1 30
1234 1 30
1234 2 1
1234 2 4
5678 1 1
5678 1 24
5678 1 30
5678 1 30
5678 2 30 |
After Update
Code: |
Medicaid Trans No Trans Type
1234 1 4
1234 1 24
1234 1 21
1234 1 21
1234 1 1
1234 1 1
1234 1 30
1234 1 30
1234 2 4
1234 2 1
5678 1 24
5678 1 1
5678 1 30
5678 1 30
5678 2 30 |
|
|