View previous topic :: View next topic
|
Author |
Message |
fareed
New User
Joined: 29 Mar 2006 Posts: 1
|
|
|
|
There is a timestamp field which is in 9's complement. We need to sort it.
Am not very great a sort and so but still can understand Sort Fields |
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
Please show me an example of the records in your input file and what you want for output. Show examples of the type of values you're working with and what they look like in 9's complement. Also, what is the RECFM and LRECL of your input file? |
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
You sent me the following information in a private message:
I need to sort on timestamp(79939139671438)
99999999999999 -- 9?s component
79939139671438 -- Value in the File
20060860328561 -- Actual value
Since each actual value is just the value in the file subtracted from 9's, you can just sort ZD descending:
Code: |
SORT FIELDS=(p,14,ZD,D)
|
where p is the starting position of the field.
If there's more to it than that, you need to explain further. |
|
Back to top |
|
|
|