The following rules and behaviors differentiate the REPLACE ORDERING and CREATE ORDERING statements:
- If you specify REPLACE ORDERING, and the specified ordering exists, the system replaces it with the new definition.
- If the specified ordering does not exist and the associated UDT does not have a defined ordering, then the system creates the specified ordering.
- If the REPLACE ORDERING statement specifies an ordering for a UDT with which an existing ordering is associated, the system returns an error to the requestor because you can specify only one ordering per UDT.