How do I display more table data on screen when browsing or editing?
RC/Update, Edit (RC/Edit) or Browse (RC/Browse) will display more than 80 columns in width on screen if some emulator and ISPF settings are adjusted. This will allow a user to see a wider screen of data returned from a table.
Note that the change to 132 column display is not available in any other of the DB2 tools and only in RCU Browse and Edit.
It reverts back to 80 column display upon re-entry to previous screens.
Release: R20
Component: RCU
Change your 3270 emulator to use IBM-3279-5-E . You will see 132 bytes in width. This only happens on the data display screen when in RC/Update, RC/Browse or RC/Edit in Column Mode.
Example Emulator settings. These will change the terminal type to a format that can display a wide screen up to 132 columns.
Emulator | Terminal Type | Model ID |
TPX | IBM-3279-5-E | n/a |
Reflection | IBM 3270 Terminal | Model 5 27x132 Extended |
ISPF Options: These will complement the wide screen used by the emulator by giving ISPF the correct terminal type and that it will be displaying data.
ISPF,
0 ISPF PARMS,
SCREEN FORMAT to "1" for DATA.
Terminal Characteristics
Screen format 1 1. Data
,
Terminal TYPE "3278".
Terminal Type 3 1. 3277 2. 3277A 3. 3278
When BROWSING a table a wide screen will be displayed with 132 columns.
RUBROWC 20.0 ----------------------------------- RC/Browse: Column Mode ----------------------------------- yyyy/mm/dd hh:mm:ss
COMMAND ===> SCROLL ===> CSR
For Table => SYSIBM.SYSCOPY > Row number=> 1 OF 192716
Browse Mode => C Max Char => 070
SSID: ssid ----------FETCH STATUS: COMPLETE------------------------------------------------------------------------------ authid
DBNAME TSNAME DSNUM ICTYPE ICDATE START_RBA FILESEQNO DEVTYPE IBMREQD
DSNRLST DSNRLS01 0 C 100413 EL.... 0 N
DSNRGFDB DSNRGFTS 0 C 100413 EL.... 0 N
DSNOPTDB DSNOPTTS 0 C 100413 EL...n 0 N
DSNOPTDB DSNOPTT8 0 C 100413 EL.0e. 0 N
DSNOPTDB DSNMQLTS 0 C 100413 EL.1.. 0 N
DSNADMDB DSNADMTS 0 C 100413 EL.... 0 N
DSNATPDB DSNATPTS 0 C 100413 EL.... 0 N
When EDITING a table a wide screen will be displayed with 132 columns.
RUEDITC 20.0 ------------------------------- RC/Edit: Positional Column Mode ------------------------------ yyyy/mm/dd hh:mm:ss
COMMAND ===> SCROLL ===> CSR
For Table => authid.PLAN_TABLE > Row number=> 1 OF 2
Edit Mode => C Max Char => 070
SSID: ssid -------------------------------------------------------------------------------------------------------------- authid
OPT S QUERYNO QBLOCKNO APPLNAME PROGNAME
___ 300 0 < > <SELECT >
___ 311 1 < > UTAFUSQ9