Browse and Edit Data

The following topics will help you become accustomed to using the File-AID Data Editor to work with z/OS DB2, MVS, IMS, or distributed relational database data.

  • Relational Database Modes
  • z/OS Dataset and z/OS UNIX Modes
  • IMS Modes
  • File-AID Data Editor Data Display View
  • Formatted Table Mode
  • Formatted Row Mode
  • Unformatted Table Mode
  • Find/Replace
  • Search Column Selection
  • Column Chooser
  • Sorting Rows
  • Filtering Rows
  • Insert Multiple Rows
  • Repeat Row(s) and Repeat Row(s) Multiple Times
  • Export the Data Editor Data Display View
  • Add Bookmark
  • Go to Bookmark
  • Freeze Columns
  • Display and Edit Cell Data
  • Invalid Data
  • Concurrent Updates
  • Row Editor

Browse and Edit Modes

The following topics will help you become familiar with modes used to browse and edit data using the File-AID Data Editor.

  • Relational Database Modes
  • z/OS Dataset and z/OS UNIX Modes
  • IMS Modes
  • Page Management
  • Relational Database Modes

Relational Database Modes

When working with relational database data, the File-AID Data Editor data display presents the data in a table format. Columns of the table represent database table/view columns with the heading containing column information metadata, including column name and data type, and key indicators. Rows of the table represent database table/view rows. This data display is called Formatted Table Mode.
A second display mode, called Row mode, is available to zoom in on a selected row. The icon at the top right of the data display will cause the data display area to split and will present the currently selected (or first) row of the table mode in the lower portion of the screen in a matrix. Columns of the matrix contain column names, metadata, and column values. Each row of the matrix is one column of the selected row.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*