These keywords have no effect on the behavior of the sequence. The sequence always issues values to users in the order of their requests, as if the ORDER keyword were always specified. The ORDER and NOORDER keywords are accepted by the ALTER SEQUENCE statement, however, for compatibility with implementations of sequence objects in other dialects of SQL.
Related statements: CREATE SEQUENCE, DROP SEQUENCE , RENAME SEQUENCE, CREATE SYNONYM , DROP SYNONYM , GRANT, REVOKE, INSERT , UPDATE , and SELECT
For information about the syssequences system catalog table in which sequence objects are registered, see the IBM Informix Guide to SQL: Reference.
For information about initializing, generating, or reading values from a sequence, see NEXTVAL and CURRVAL Operators (IDS).