When editing with sort and row limit the wrong rows are being shown in RC/Update
search cancel

When editing with sort and row limit the wrong rows are being shown in RC/Update


Article ID: 13047


Updated On:


RC/Update for DB2 for z/OS


Having 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,  the rows being shown are not the last nn rows in the table.


This can happen if Update Method 'P' or 'S' is used.

RUEDITO  20.0   ------------- RC/Edit Options ------------ yyyy/mm/dd hh:mm:ss
Command ==>

Option      => E                     Object  => T
Item Name   => table1             > Creator => authid1   > Where => N
SSID: ssid ---------------------------------------------------------- authid1
  Data Selection
    Where                ==> N          (Enter Data Query)
    Row Limit            ==>            (Blanks set no limit)
    Update Method        ==> D          (P - Positional, S or D - Searched)

  Edit Display Control
    Initial Edit Mode    ==> C            Char Field Max. Size ==> 70
    Show Deleted Rows    ==> N            Display DB2 Types    ==> N
    Trace DB2 Save I/O   ==> N            Display I/O Summary  ==> Y

  Positional Update Options             Searched Update Options
    (Ignored for Searched Mode)           Auto Refresh         ==> N
    Lock Table for Edit  ==> Y            Commit Level         ==> 50

 Generate a Test Count   ==> N          (Count of rows that would be selected)
 Save Defaults for Table ==> N          (Y/N)

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.

The Update Method prompt indicates the
    editing method to be used to update the
    data.  Valid options are:

    S - Searched Update.  Use when two or
    more people want to edit the same table
    at the same time.  Also, use Searched
    Update's SET command to make global
    changes to a column for all rows.

    D - Searched Update.  Same as S above,
    but may include an SQL ORDER BY on
    the SELECT cursor.

P - Positional Update.  Use when there
is NULL data, you want to lock the
table, or you need to update duplicate
rows individually.

Additional Information