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 CREATE SEQUENCE statement for compatibility with implementations of sequence objects in other dialects of SQL.
Related statements: ALTER SEQUENCE, DROP SEQUENCE , RENAME SEQUENCE, CREATE SYNONYM , DROP SYNONYM , GRANT, and REVOKE
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 a sequence and generating or reading values from a sequence, see NEXTVAL and CURRVAL Operators (IDS).