RC/Browse Component

RC/Browse is a restricted form of RC/Edit and lets users view or browse data in DB2 tables without editing. The data can be viewed in column or form mode. Standard ISPF editor commands such as FIND and RFIND are supported. The extended view browse support feature permits editing of most joined views. There is also an EXPLODE mode available for viewing data in long character columns.
carcudb2
RC/Browse is a restricted form of RC/Edit and lets users view or browse data in DB2 tables without editing. The data can be viewed in column or form mode. Standard ISPF editor commands such as FIND and RFIND are supported. The extended view browse support feature permits editing of most joined views. There is also an EXPLODE mode available for viewing data in long character columns.
RC/Browse provides a significant ISPF-like data editor to browse information stored in DB2 tables. Some of the capabilities of the RC/Browse include:
  • Access to DB2 data in tabular (column) or form mode. Browsing is beneficial for viewing DB2 catalog or production tables.
  • Support for most DB2 data types including LONG VARCHAR, TIME, DATE, TIMESTAMP, TIMESTAMP with TIMEZONE, and floating-point.
  • An EXPLODE option for browsing data greater than 256 characters. The EXPLODE option places the user into an ISPF full screen browse session at the column level.
  • Full support for NULL values.
  • Support for embedded blanks at the beginning or within values for the following items:
    • Column names
    • Table names
    • Creators
  • Support for long names.
  • Selection capability on columns and rows. An SQL statement can be specified to select only specific columns and rows. These SQL statements can be saved for repeated use.
  • A SORT feature for sorting the rows while they are being browsed. This permits users to constantly change the order of the data without re-executing the SQL statement.
  • A FREEZE option for keeping columns fixed during scrolling. This facilitates examining columns dependent on other columns.
  • FIND and RFIND commands for finding specific data during the browse session.
  • A K command to automatically identify the primary (Pn) and foreign (FK) columns in a table.
  • The extended view support feature lets users browse most joined views on the BROWSE screen, using the Column Mode. This is accomplished by mapping the columns in the views to the underlying base tables.