View previous topic :: View next topic
|
Author |
Message |
naive
New User
Joined: 26 Apr 2005 Posts: 46 Location: LA
|
|
|
|
Hullo
we are sorting a dataset based on 'timestamp'. This dataset is created by unloading a DB2 table (format TIMESTMP). We need to get the latest timestamp in the DS.
The format of the timestamp field is like '2006-03-31-19.59.09.000002'.
Now this I think will be treated as a normal CH field by SORT.
Aim: To sort the DS on descending order based on this field
Question: Will we get accurate results if we use
SORT FIELDS=(xx,26,CH,D) ? xx=starting pos of the field |
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
Yes, you will. |
|
Back to top |
|
|
naive
New User
Joined: 26 Apr 2005 Posts: 46 Location: LA
|
|
|
|
Thankx Frank for coming to the rescue!! (as usual) |
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
When in doubt, try it out. |
|
Back to top |
|
|
|