Ordering of rows within a Db2® object is not guaranteed

The relational model on which Db2® is based does not require data within a Db2® table to be in any specific order. This is not to say that data in a Db2® object is not stored in a particular order as this is certainly the case. In addition, a number of methods can be used (for example, CLUSTERING) to influence the way rows are stored in a Db2® table. In terms of the FM/Db2 editor, these considerations apply:

• Data is read from Db2® in the order Db2® delivers it to FM/Db2. Unless there is an ORDER BY clause for the data entered explicitly (on the Column Selection/Edit panel) or implicitly (for example, when processing a VIEW and the VIEW includes an ORDER BY clause), no assumptions should be made about the relative positions of any two rows.
• Moving rows from one position to another in a File Manager/Db2 Edit session has no effect on the way FM/Db2 stores the data in the table.
• When the editor is operating in "large mode", moving rows from one position to another is disabled.