On the RC/Update Browse option, more than 70 characters for "Char Field Max. Size" field is needed.

Document ID : KB000011164
Last Modified Date : 14/02/2018
Show Technical Document Details
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.

Question:

On the RC/Update Browse option, more than 70 chars for "Char Field Max. Size" field is needed. The client requires about 600 characters.

Browse Control

   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)
Environment:
Z/OS
Answer:

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 you are 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.

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

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

Table Name   => PLAN_TABLE          > Column Name     => REMARKS             >
Table Creator=> AUTHID    >           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
     000552 THISISATESTOFHOWLONGTHISFIELDCANBETOSEEIFITWILLDIS
     000553 PLAYPASTTHEMAXIMUMLENGTHOF256CHARACTERSBECAUSETHEL
     000554 ENGTHOFTHEFIELDISDEFINEDASVARGRA600SOHOWISTHISGOIN
     ****** ***************** Bottom of Data *****************


 

 
Additional Information: