When editing with sort and row limit, the wrong rows are being shown.

Document ID : KB000013047
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

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.

 

Answer:

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.

 

Additional Information:

For more information, please refer to the RC/Update for DB2 for z/OS manual: Searched and Positional Methods