How do I limit the number of rows returned by RC/Browse and RC/Edit?

book

Article ID: 51438

calendar_today

Updated On:

Products

CA RC/Migrator CA Endevor SCM Interface DB2 Administration CA RC Compare for DB2 for z/OS CA RC Extract for DB2 for z/OS CA RC/Query CA RC Secure for DB2 for z/OS CA RC Update for DB2 for z/OS CA Bind Analyzer for DB2 for z/OS CA Detector CA SQL-Ease for DB2 for z/OS CA Sysview Performance Management Option for DB2 for z/OS CA Database Detector for DB2 for z/OS CA Plan Analyzer for DB2 for z/OS CA Subsystem Analyzer for DB2 for z/OS

Issue/Introduction

Description:

By default there is no limit to the number of rows returned by RC/Browse and RC/Edit, and so all rows are returned. How can this default be changed to limit the number of rows returned?

Solution:

The Row Limit field on the RC/Browse or RC/Edit Options screens allows you to set a ceiling on the number of rows that are retrieved for your browse or edit session.

The default for this field is set to 'no limit'.

There are two ways to change this Row Limit default:

  1. Set the row limit for RC/Edit and RC/Browse using the EDROWLIM parameter in the RCEDIT PARMLIB member.
         EDROWLIM (99)            /* SELECT ROW LIMIT VALUE                  */
                                  /*    VALID VALUES ARE 1-99999999          */
                                  /*    BLANK INDICATES NO ROW LIMIT APPLIED */
  2. Set the row limit system wide by using the ROWLIMIT parameter in the DEFAULTS PARMLIB member.
         ROWLIMIT   (55)          /* SELECT ROW LIMIT TO BE APPLIED.   */
                                  /* VALID VALUES ARE 1-99999999. A    */
                                  /* BLANK INDICATES THAT NO ROW LIMIT */
                                  /* WILL BE APPLIED.                 .*/

Note: To activate the DEFAULTS PARMLIB member you will need to add the following parameter to the relevant SETUP(xx) PARMLIB member as below:

DECPOINT (.)
DEFAULTS (YES) <== add the DEFAULTS parameter
CASEMIX  (NO)

The DEFAULTS PARMLIB member settings will override the RCEDIT PARMLIB member settings.

Environment

Release:
Component: RCQ