Browse/edit more than 70 characters for "Char Field Max. Size" field is needed in RC/Update

Products

• RC/Update for DB2 for z/OS

Issue/Introduction

Sometimes when editing table data there are columns that are longer than the display width on the screen. Being able to expand these
columns to their full width in a full screen mode can enable more effective editing of the data.

On the RC/Update for Db2 for z/OS (RCU) Browse , more than 70 chars for "Char Field Max. Size" field is needed. The task requires about 600 characters.

   Initial Browse Mode  ==> C  (C - Column Mode, F - Form Mode)   
   Char Field Max. Size ==> 70 (1 thru 70 , 1 thru 256 )   
   Display DB2 Types    ==> N  (Y/N/U)

Resolution

When using Browse or Edit in RC/Update, data fields that are longer than 256 characters can be displayed by using the EXPLODE command.

When displaying the row in your table on the screen, issue the EXPLODE command on the command line AND then place your cursor on the field that is longer
than 256 characters before pressing enter. This will then display the RC/Edit/Browse Explode Facility screen which will display the data in increments of 50 characters.

RUEDITC  20.0   ----- RC/Edit: Positional Column Mode ---- yyyy/mm/dd hh:mm:ss
COMMAND ===> EXPLODE                                          SCROLL ===> CSR

For Table   => AUTHID1.PLAN_TABLE              > Row number=> 1 OF 24
Edit Mode   => C                                 Max Char  => 070
SSID: ssid ---------------------------------------------------------- authid1
OPT S REMARKS
___   THISISATESTOFHOWLONGTHISFIELDCANBETOSEEIFITWILLDISPLAYPASTTHEMAXIMUMLE

It will look something like this: (Field length is 760 characters in this example)

RUEDITE  20.0   -------- RC/Edit Explode Facility -------- yyyy/mm/dd hh:mm:ss
COMMAND ===>                                                  SCROLL ===> CSR

Table Name   => PLAN_TABLE          > Column Name     => REMARKS             >
Table Creator=> authid1   >           Column Type     => VARCHAR(762)
DB2 SSID     => ssid                  Column Length/50=> 015

            ----+----1----+----2----+----3----+----4----+----5
     ****** ****************** Top of Data *******************
     000001 THISISATESTOFHOWLONGTHISFIELDCANBETOSEEIFITWILLDIS
     000051 PLAYPASTTHEMAXIMUMLENGTHOF256CHARACTERSBECAUSETHEL
     000101 ENGTHOFTHEFIELDISDEFINEDASVARGRA600SOHOWISTHISGOIN
     000151 GTODISPLAYWHENITISLONGERTHANTHE256CHARCTERS
     000201 THISISATESTOFHOWLONGTHISFIELDCANBETOSEEIFITWILLDIS
     000251 PLAYPASTTHEMAXIMUMLENGTHOF256CHARACTERSBECAUSETHEL
     000301 ENGTHOFTHEFIELDISDEFINEDASVARGRA600SOHOWISTHISGOIN
     000351 GTODISPLAYWHENITISLONGERTHANTHE256CHARCTERS
     000401 THISISATESTOFHOWLONGTHISFIELDCANBETOSEEIFITWILLDIS
     000451 PLAYPASTTHEMAXIMUMLENGTHOF256CHARACTERSBECAUSETHEL
     000501 ENGTHOFTHEFIELDISDEFINEDASVARGRA600SOHOWISTHISGOIN
     000551 GTODISPLAYWHENITISLONGERTHANTHE256CHARCTERS
     000601 THISISATESTOFHOWLONGTHISFIELDCANBETOSEEIFITWILLDIS
     000651 PLAYPASTTHEMAXIMUMLENGTHOF256CHARACTERSBECAUSETHEL
     000701 ENGTHOFTHEFIELDISDEFINEDASVARGRA600SOHOWISTHISGOIN
     000751 1234567890
     ****** ***************** Bottom of Data *****************