Navigating around an EDIT screen with fine control within RC/Update

Products

• RC/Update for DB2 for z/OS

Issue/Introduction

RC/Update for Db2 for z/OS (RCU) provides a full screen editing function. While editing data there are various fine control facilities available to navigate
around the screen which become particularly useful when dealing with tables that contain large numbers of columns and/or tables with large number of rows.
There are also facilities to handle working with columns which contain a larger number of bytes/characters.

Resolution

When editing data using RC/Edit: Searched Column Mode 

The screen can be moved from left to right with PF10/PF11 or by entering a number in the command line in conjunction with PF10/PF11 to move that number of columns
to the left or right. The use of the letter "M" in the command line in conjunction with PF10/PF11 will position to the start or end of the row.

To go to a particular row from the start of the table a number is entered in the command line in conjunction with PF8/PF7 to move that number of rows up or down the table.
To move over a number of display columns enter a number again in the command line and use PF10/PF11. At that point you can change to column mode to look at the data
in a column report if you wish.

 

When in RC/Edit: Searched Form Mode

Move up and down the list of columns in one record using PF7/PF8 or enter a number in the command line in conjunction with PF7/PF8 to jump that many columns up or down.
Using the letter "M" in the command line in conjunction with PF7/PF8 will take you to the start or end of the row.

While still in Form Mode move from this record to the next with PF10/PF11 or again using a number in the command line in conjunction with PF10/PF11 to jump that number of
records. Use "M" in the command line in conjunction with PF10/PF11 to jump to the start or the end of the table in Form mode.

 

If there is a long char column then it will show a maximum of 70 chars in Column Mode but change to FORM mode and any long fields will display a ">" at the end.

B4.DESCRIPTION Y ------------------------------------------------->

The > on the end indicates that you can position your cursor in the field and scroll PF10/PF11 in it.

And here too a number or "M" in the command line can be used and while positioning your cursor inside the column field data to move around inside this long column.

While in Column or Form mode while positioning your cursor at a long column to be examined, enter "EXPLODE" in the command line to expand that one field into an ISPF edit session all of its own.

RUEDITC  Rxx    ----- RC/Edit: Searched Column Mode   ---- yyyy/mm/dd hh:mm:ss
COMMAND ===> explode                                          SCROLL ===> CSR
For Table   => creator.table_name                       >  Row number=> 1 OF 1
Edit Mode   => C                                 Max Char  => 070
SSID: ssid -----------FETCH STATUS: COMPLETE-------------------------- authid
OPT  S DESCRIPTION                                                             N
___  I ((cursor in here))----------------------------------------------------- Y
******************************* BOTTOM OF DATA *********************************

And the next screen will show an edit session where data can be entered just for that column.

Table Name   => table_name          > Column Name     => DESCRIPTION 
Table Creator=> authid>               Column Type     => CHAR(100)
DB2 SSID     => ssid                  Column Length/50=> 002 
            ----+----1----+----2----+----3----+----4----+----5
     ****** ****************** Top of Data ******************* 
     000001
     000051
     ****** ***************** Bottom of Data *****************

Note that only CHARACTER, VARCHAR, and LONGVAR columns may be exploded.

So, there are various options for moving effectively around data rows while editing with fine control.