Numeric Ordering
Mandatory.
Specify, for numeric key columns only, additional details about how the key is to be ordered.
Default=Unsigned.
Rules
Allowable values are:
S |
(Signed) indicates the numeric columns should be stored taking into account their signs (+ or -). |
U |
(Unsigned) indicates the numeric column should be stored without taking into account their signs. The numeric column is to be treated just like a character column. |
A |
(Absolute value) indicates that the numeric column 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 columns are always U (unsigned) columns. If you specify something other than U for a character column, it will be automatically changed to U.