The display of long columns in Form Mode in RC/Edit and RC/Browse has changed on r11.5

Products

• RC Compare for DB2 for z/OS
• Bind Analyzer for DB2 for z/OS
• SQL-Ease for DB2 for z/OS
• SYSVIEW Performance Management Option for DB2 for z/OS
• Plan Analyzer for DB2 for z/OS
• Subsystem Analyzer for DB2 for z/OS

Issue/Introduction

Description

When using RC/Edit or RC/Browse in Form Mode on r11, any column that was greater than 50 characters in length was displayed on multiple lines:

  RUBROWF  R11    ---------- RC/Browse: Form Mode ---------- 2009/01/14 04:51:5
  COMMAND ===>                                                  SCROLL ===> CSR 
  For Table   ==> USERID.PTSYS_DEFAULT_0100   Row number==> 1 OF 1            
  Browse Mode ==> F                            Max Char  ==> 070               
  SSID: D81A ----------FETCH STATUS: COMPLETE-------------------------- USERID 
  ##.COLUMN NAME       NULL   DATA FOR ROW # 1 
  A1.USERID                   AA 
  A2.DESCRIPTION              AA 
  A3.GLOBAL_DEFAULTS          AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA 
                            AAAAAAAAAAAAAAAAAAAA 
  A4.SG_DEFAULTS              AA 

On r11.5 the display has changed:

  RUBROWF  R11.5  ---------- RC/Browse: Form Mode ---------- 2009/01/14 04:54:56 
  COMMAND ===>                                                  SCROLL ===> CSR 
                                                                              
  For Table   => USERID.PTSYS_DEFAULT_0100   >    Row number=> 1 OF 1          
  Browse Mode => F                                 Max Char  => 070            
  SSID: D81A ----------FETCH STATUS: COMPLETE-------------------------- USERID 
  ##.COLUMN NAME        NULL  DATA FOR ROW # 1 
  A1.USERID                   AA 
  A2.DESCRIPTION              AA 
  A3.GLOBAL_DEFAULTS          AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA > 
  A4.SG_DEFAULTS              AA 

Why has the display been changed on r11.5 and how do I display the entire column field?

Solution

The changes to the display of column data on r11.5 are part of the changes made for Long Name support and in particular Enhanced Scroll Services. Enhanced Scroll (ES) is used to manage display and scrolling.

These enhancements are documented in the r11.5 Release Summary, ISPF Display Interface Enhancements, Field and Column Level Scrolling:

To accommodate DB2 V8 long name objects, field and column level scrolling has been implemented. The scrollable fields are identified on the screens by the less than (<) or greater than (>) symbols next to the field. To scroll the field, place the cursor in the field and use the left or right PF keys to view the data.

The EXPLODE or EXPAND commands can be used to edit or view the entire field contents.

Enter the EXPLODE command on the command line and place the cursor anywhere within the column data and press ENTER:

  RUBROWE  R11.5  ------- RC/Browse Explode Facility ------- 2009/01/14 05:05:5 
  COMMAND ===>                                                  SCROLL ===> CSR 

  Table Name   => PTSYS_DEFAULT_0100 >  Column Name     => GLOBAL_DEFAULTS    > 
  Table Creator=> USERID  >            Column Type     => VARCHAR(490)        
  DB2 SSID     => D81A                  Column Length/50=> 009                 
                                                                             
         ----+----1----+----2----+----3----+----4----+----5 
         ******************* Top of Data ******************** 
         AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA 
         AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA 
         AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA 
         AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA 
         ****************** Bottom of Data ****************** 

Further details on the Scrolling and Expanding enhancements can be found in the r11.5 (SP2 and above) RC/Update User Guide. Refer to Chapter 4, Scrolling and Expanding Fields.

Environment

Release:
Component: RCQ