Using BMC AMI DevX Workbench File-AID

The DevX File-AID Data Editor allows browsing and editing capabilities for MVS and VSAM-type data sets.

Creating a data editor request

1. Click   View > Command Palette.
2. In the command palette, start typing DevX File-AID and select DevX File-AID: Create Data Editor Request for a Data Set from the list. 
   The Data Editor Request page is displayed.
   
   

1. Select the HCI connection.
2. Click Find and select the data set name. You see a Selection Criteria tab where you can browse the selection criteria data set and members. You can run the request from that tab.
3. By default, the Format the display using a record layout option is enabled. If you disable it, the options under the Record layout option will be hidden, and you will see the unformatted data table. When this option is enabled, the data editor table details are visible in the formatted manner.
4. Select Single Layout  (the default setting) or  Record Layout cross reference (XREF) in the Record Layout section. Selecting  Record Layout cross reference (XREF)  automates the layout presentation for files with multiple record types or multiple segments of data per second (segmented records).
5. Perform one of the following steps, depending on your selected record layout:
   • If you have selected Single Layout, follow these steps:
     1. Click  Find next to the Layout data set (member) field and select a layout data set.
        If one level name exists, it is displayed.
     2. Select one from the list if your layout has more than one level name.
        From the Fields option, you can select the fields you want to display in the data editor table. The fields you select during the request are visible in the table as well as in the row mode editor.
   • If you selected  Record Layout cross reference (XREF), follow these steps:
     1. Click  Find next to the  XREF data set (member)  field and select a layout data set.
     2. Next to the  Record layout (PDS)  field, click Find  and select previously entered record layout PDS names from the list or search for the PDS in your XREF.
        If the selected data set is a partitioned data set (PDS), it populates the list of data set members. If the selected layout is validated, the associated level names are displayed.

6. In the  Display  section, in the  Record per page  field, enter the number of records you want to view on each page. The maximum number of record pages is 25,000. 

   Best practice
   We recommend entering a value between 1 and 2000. A high value causes record loading to take longer.

   Important

   File-AID admin can set a record limit in the mainframe. If the administrator has not set any limit for the records, you can enter any value, and records are displayed based on the set value. In case the administrator sets a maximum limit, you see a maximum number of records set by the administrator.

7. In the  Run mode  section:
   1. Select  Browse or Edit  (the default setting).
   2. If you selected Edit:
      1. Specify whether to enable auditing. Auditing is enabled by default.
      2. Selected  Exclusive use or Audit edit section  for shared use.

8. Click Run.

   • Single layout
   • Record Layout cross reference (XREF)

   You can perform the following actions in the table:

   Purpose	Action
   Switch between formatted and unformatted views for the table data.	Click .
   Switch between text and hexadecimal mode to view the table data.	Click .
   Choose file export delimiter	Click and select the following options. Select the delimiter from the list. Select the file qualifier. Select the required heading you want to export.
   Export the table data	Click Export .
   Show and hide columns	Click .
   Search data on the table	Enter the required data in the Search page field.
   Freeze and unfreeze a column	Right-click on the column header and select Freeze to freeze the column. This makes the selected column append at the start of all columns and the remaining columns can be moved forward and backward using the horizontal scrollbar. If you want to unfreeze the column, right-click on the column header and select Unfreeze.
   Edit a row	Right-click and select Edit Row or double-click it and edit it. Click  or press Enter to save your edit to the cache or click  to cancel the edit. If you enter an incorrect value, an error message is displayed based on the column type, and that column's original value is restored. When you save your edit to cache, you see the blue icon () beside the row.  Right-click and select Undo Pending Edit or press Ctrl +s to save your edits.
   Insert a row	Right-click and select Insert Row. Enter the required details in the inserted row and press Enter. You see the green icon () beside the row. Right-click and select Undo Pending Inset or press Ctrl +s to insert the row.  Important If the data set is empty, you can click the Insert a record link to add a row to the data set. While inserting a new row or editing the row in text mode you must delete the characters before adding the new one.
   Duplicate a row	Right-click and select Duplicate. A new row is inserted and all values of the selected row are copied to the new row, Press Enter to save the row. You see the green icon () beside the row. Right-click and select Undo Pending Inset or press Ctrl +s to insert the row.
   Revert your changes	Click the Updo Page option (). The undo page confirmation notification is displayed. Click Undo Page to revert your changes.
   View and edit the data added in the rows	Click the arrow present beside the row number to expand the row and view the data. Double-click on the row data and edit in hexadecimal and text mode as required. Important For the VSAM data set, in the single layout, you see the primary key icon () in the header of the columns for which data is unique. If there is a primary key for the VSAM file, you can not edit it. You can edit other details.

      

   
   

   You can also perform the following actions in the table:

   Purpose	Action
   Switch between formatted and unformatted views for the table data.	Click .
   Switch between text and hexadecimal mode to view the table data.	Click .
   Choose file export delimiter	Click and select the following options. Select the delimiter from the list. Select the file qualifier. Select the required heading you want to export.
   Export the table data	Click Export .
   Edit a row	Right-click and select Edit Row or double-click it and edit it. Click  or press Enter to save your edit to the cache or click  to cancel the edit. If you enter an incorrect value, an error message is displayed based on the column type, and that column's original value is restored. When you save your edit to cache, you see the blue icon () beside the row.  Right-click and select Undo Pending Edit or press Ctrl +s to save your edits.
   Insert a row	Right-click and select Insert Row. Enter the required details in the inserted row and press Enter. You see the green icon () beside the row. Right-click and select Undo Pending Inset or press Ctrl +s to insert the row.  Important If the data set is empty, you can click the Insert a record link to add a row to the data set. While inserting a new row or editing the row in text mode you must delete the characters before adding the new one.
   Duplicate a row	Right-click and select Duplicate. A new row is inserted and all values of the selected row are copied to the new row, Press Enter to save the row. You see the green icon () beside the row. Right-click and select Undo Pending Inset or press Ctrl +s to insert the row.
   Revert your changes	Click the Updo Page option (). The undo page confirmation notification is displayed. Click Undo Page to revert your changes.