I have specified a descending sort order on a column in the Extended Data Query facility (WHERE) and entered a row limit on the 'RC/Edit Options' panel.
However, the rows being shown are not the last nn rows in the table.
This can happen if you use Update Method 'P' or 'S'
Only Update Method 'D' will generate an ORDER BY in the SELECT statement.
With Update Method 'P' or 'S' data will be selected in the order DB2 provides and then sorted internally.
For more information, please refer to the RC/Update for DB2 for z/OS manual: Searched and Positional Methods
Was this information helpful?