RC/Edit Component

RC/Edit is a complete ISPF-style editor for manipulating information that is stored in DB2 tables. The data can be viewed in two different ways, column mode or form mode. All standard ISPF editor commands such as CHANGE, RCHANGE, FIND, and RFIND are supported. The extended view update support feature lets you edit most joined views. There is also an EXPLODE feature available for entering data into long character columns.
carcudb2
RC/Edit is a complete ISPF-style editor for manipulating information that is stored in DB2 tables. The data can be viewed in two different ways, column mode or form mode. All standard ISPF editor commands such as CHANGE, RCHANGE, FIND, and RFIND are supported. The extended view update support feature lets you edit most joined views. There is also an EXPLODE feature available for entering data into long character columns.
Used with the DB2 object create, drop, and alter capabilities, a complete environment for maintaining DB2 objects and data is provided, including the following.
  • Access to DB2 data in Tabular (column) or Form mode. The data can be accessed in browse only mode or with update capability.
  • Support for most DB2 data types includiing LONG VARCHAR, TIME, DATE, TIMESTAMP, TIMESTAMP with TIMEZONE, floating-point, graphical, and DBCS. All data entered is verified.
  • Ability for multiple users to edit the same table at the same time using the Searched method of editing.
  • An EXPLODE option for editing data greater than 256 characters. The EXPLODE option places the user into an ISPF full screen editor 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, and creators.
  • Selection capability on columns and rows. You can specify an SQL statement to select only specific columns and rows, and save it for repeated use.
  • A SORT feature for sorting the rows while they are being edited. This lets you constantly change the order of the data without re-executing the SQL statement.
  • A FREEZE option for keeping columns fixed during scrolling. This facilitates editing columns dependent on other columns.
  • Full ISPF line commands including insert, delete, undelete, and replicate. Block mode is supported.
  • A K command to identify the primary (Pn) and foreign (FK) columns in a table automatically.
  • FIND and RFIND commands to find specific data during the edit session.
  • CHANGE, RCHANGE, CHANGE ALL, and SET commands to facilitate updates.
  • A STATS command to view statistics any time during an edit session.
  • PROTECT, UNPROTECT, XCOL, and SCOL commands for greater flexibility and control over the RC/Edit display.
  • A SORT? command displays the Data Query Edit screen, where users can sort on multiple columns during the editing session.
  • All ISPF scrolling modes (PAGE, HALF, Number, and CSR are supported).
  • Support for the PPRINT, QPRINT, PFILE, and QFILE print commands.
  • Support for 3278 model 5 terminals for viewing 133 columns (column mode only).
  • Extended view update support feature to edit joined views on the EDIT screen using the Searched Column Mode. This is accomplished by mapping the columns in the views to the underlying base tables.
  • Ability to edit a table that has the following types of columns:
    • Identity columns
      If the column is GENERATED ALWAYS, DB2 always assigns a value whenever a new row is inserted. If the column is GENERATED BY DEFAULT, you can specify a value to override the generated DB2 value.
    • ROWID columns
      You cannot specify an overriding value. Inserted rows always have ROWID values generated by DB2.
    • LOB columns
      RC/Edit automatically omits the LOB columns of the edited table. You do not need to manually omit them. You can use RC/Edit to view and change the non-LOB columns of the table.
    • XML columns
      RC/Edit automatically omits the XML columns of the edited table. You do not need to manually omit them. You can use RC/Edit to view and change the non-XML columns of the table.