Numeric Ordering
Mandatory.
Specify, for numeric key fields only, additional details about how the key is to be ordered.
Default=Unsigned.
Rules
Allowable values are:
|
S |
(Signed) indicates the numeric fields should be stored taking into account their signs (+ or -). |
|
U |
(Unsigned) indicates the numeric field should be stored without taking into account their signs. The numeric field is to be treated just like a character field. |
|
A |
(Absolute value) indicates that the numeric field should be stored by its absolute value. Note that this is not the same (and does not always produce the same order) as the U option. |
Tips & Techniques
- Character fields are always U (unsigned) fields. If you specify something other than U for a character field, it will be automatically changed to U.