File-AID Search/Update

Searching and Globally Updating File-AID Datasets

Users can perform basic text-based searches as well as advanced searches through z/OS PDS/PDSE, sequential, and VSAM dataset contents. In addition to searching for data, facilities are provided to perform global updates to supported dataset types, including all members of a PDS.

Perform a Basic Search with Optional Update

To perform a basic search:

1. Do one of the following:
   1. From the Search menu, select File-AID Search/Update.
   2. On the toolbar, from the drop-down list, select File-AID Search/Update.
   3. Click Ctrl + H.
   4. In the Host Explorer tree view, right click a PDS, sequential, or VSAM dataset and select Search. Datasets or PDS members can be multi-selected.
   5. In the Host Explorer tree view, right click on a dataset filter and select Search.
      The File-AID Search/Update tab of the Search dialog box appears.
2. If necessary, click Switch to basic search. The dialog box contents refresh to show basic search options.
3. In the Search for text field, enter the text to be searched for or, from the drop-down list, select one of the previous 12 searches.
4. Select the Case sensitive check box to make the text search match the case entered in the Search for text field, or clear the check box to perform a case-insensitive search.
5. Optionally, select the Use comma to separate values check box to search for multiple text values. Separate the values with a comma. For example PICTURE,DCL searches for PICTURE or DCL when the check box is selected.
6. In the Host field, select the host that contains the datasets to be searched. If only one host is configured or the Search dialog box was accessed from a context-specific method that predetermines the host, the Host field is disabled and pre-populates with the host being used. Click Configure if you want to configure a new host connection. Refer to the Topaz Workbench Host Explorer User Guide for how to configure a new host connection.
7. In the Datasets (PDS, sequential, or VSAM) box, use the Add, Edit, Remove, and Remove All buttons to select the datasets to be searched.
   • Click Add to open the Add Datasets dialog box, which allows users to type or browse to datasets to be added to the Search dialog box. The ? - * and % wildcards are supported in any position.
   • Select a dataset and click Edit to edit the name of the dataset.
   • Select a dataset and click Remove to remove the dataset from the search.
   • Click Remove All to remove all datasets from the search. The Search action button is disabled if no datasets are specified.
8. Select the Process as JCL check box, if desired, to treat JCL continuation lines as one statement in 80-byte PDS members, thus searching the entire JCL statement (JOB, EXEC, DD, etc.) for the search criteria.
9. Optionally, click Preferences to open the Preferences dialog box and set search preferences. Refer to the Topaz Workbench Host Explorer User Guide for how to set search preferences.
10. Click Search to perform a search, or click Update to initiate an update via the Update Text Matches dialog that pops up. After the search runs, the results appear in the Search view. The Search view, if not visible, can be opened from the Window menu by selecting Show View>Other>General> Search. Refer to the Eclipse documentation at www.eclipse.org for information on the Search view.

11. Optionally, double-click a record in the Search view or click or to go to the selected line in the default editor. 

    Important

    • To select the pages to be shown in the Search dialog box, click Customize and complete the Search Page Selection dialog box.
    • To set whether editors are reused when records are opened, from the Window menu, select Preferences and then, from the navigation tree, select General>Search. Select or clear the Reuse editors to show matches check box.
12. If you have chosen to do a global Update, use the Update Text Matches dialog to review your search text in the Update: field and to specify the replacement text in the With: field. Optionally, perform the following:
    • If your text strings are not the same length, verify that you want to allow data to shift or not. By default, the Shift if length is different from search check box is enabled, and data beyond the replacement string will be shifted left if the replacement With: value is shorter or right if the With: value is larger. Extra blanks are added when shifting left and removed when shifting right.
    • Since a global update can alter data in a file(s), you may choose to create an audit file of the changes by selecting the Enable Auditing check box.
    • Use the Preview button to view a preview of your changes in the Confirm Preview Results window.
    • Optionally, double-click a record in the Preview Results window to open a File-AID Data Editor session displaying the Preview results file. Note that this file only shows the records that are going to be changed.
    • Use the + icon to expand all PDS and files in the Preview Results window.
    • Use the - icon to collapse all Preview results.
    • Use the down arrow () to access a menu where you can control the format of the results as either a list or a tree view.
    • Use the Back button to return to the Update Text Matches dialog.
    • Use the Cancel button to exit from File-AID Search/Update without performing any changes.
13. When you are sure you are ready to update your files, click Finish. You will be prompted for confirmation. Click OK to proceed or Cancel to return. Summary statistics are then displayed in the Search view.

Perform an Advanced Search/Update by Building Search/Update Criteria

To perform an advanced search/update by building search criteria

1. Do one of the following:

   • From the Search menu, select File-AID Search/Update.
   • On the toolbar, from the drop-down list, select File-AID Dataset Search/Update.
   • Click Ctrl + H.
   • In the Host Explorer tree view, right click a PDS, sequential, or VSAM dataset and select Search. Datasets or PDS members can be multi-selected.
   • In the Host Explorer tree view, right click on a dataset filter and select Search.

   The File-AID Dataset Search/Update tab of the Search dialog box appears.

2. If necessary, click Switch to advanced search. The dialog box contents refresh to show advanced search options. The dialog box can be resized to show all options.
3. Select Use selection criteria below.
4. Click Add then select Add Condition (AND). The Edit Search Criteria dialog box appears. Optionally, you may select Add Update. The Edit Change Criteria dialog box appears. It is possible to define an unconditional update to your file, which will perform an update to every record in every dataset specified. You may not select ADD condition (AND) after you have added an Update criteria, however you may start a new set of conditional updates by using ADD set (OR).
5. Complete the Edit Search Criteria dialog box or complete the Edit Update Criteria dialog box.
6. After completing the Edit Search Criteria dialog box, if desired, add more selection criteria by clicking Add and doing either of the following:
   • To add an AND condition to the existing search condition, click Add Condition (AND), then complete the Edit Search Criteria dialog box.
   • To create an OR condition, click Add Set (OR), then complete the Edit Search Criteria dialog box.
   • To create or add update criteria, click Add Update, then complete the Edit Update Criteria dialog box.
7. When all selection and update criteria have been created, in the Host field, select the host that contains the datasets to be searched. If only one host is configured or the Search dialog box was accessed from a context-specific method that predetermines the host, the Host field is disabled and prepopulates with the host being used. Click Configure if you want to configure a new host connection. Refer to the Topaz Workbench Host Explorer User Guide for how to configure a new host connection.
8. In the Datasets (PDS, sequential, or VSAM) box, use the Add, Edit, Remove, and Remove All buttons to select the datasets to be searched and/or updated.
   • Click Add to open the Add Datasets dialog box, which allows users to type or browse to datasets to be added to the Search dialog box.
   • Select a dataset and click Edit to edit the name of the dataset.
   • Select a dataset and click Remove to remove the dataset from the search.
   • Click Remove All to remove all datasets from the search. The Search action button is disabled if no datasets are specified.
9. Select the Process as JCL checkbox, if desired, to treat JCL continuation lines as one statement in 80-byte PDS members, thus searching the entire JCL statement (JOB, EXEC, DD, etc.) for the search criteria.
10. Optionally, click Preferences to open the Preferences dialog box and set search preferences. Refer to the Topaz Workbench Host Explorer User Guide for how to set search preferences.
11. Click Search to perform the search. After the search runs, the results appear in the Search view. The Search view, if not visible, can be opened from the Window menu by selecting Show View>Other>General> Search. Refer to the Eclipse documentation at www.eclipse.org for information on the Search view.

12. Optionally, double-click a record in the Search view or click or to go to the selected line in the default editor. 

    Important

    • To select the pages to be shown in the Search dialog box, click Customize and complete the Search Page Selection dialog box.
    • To set whether editors are reused when records are opened, from the Window menu, select Preferences and then, from the navigation tree, select General>Search. Select or clear the Reuse editors to show matches check box.
13. If you have defined any Update Criteria, click the Update button and use the Update Text Matches dialog to control the global update processing. Optionally, perform the following:
    • Use the Confirm Updates check box to request a prompt before your updates are processed.
    • Since a global update can alter data in a file(s), you may choose to create an audit file of the changes by selecting the Enable Auditing check box.
    • Use the Preview button to view a preview of your changes in the Confirm Preview Results window.
    • Optionally, double-click a record in the Preview Results window to open a File-AID Data Editor session displaying the Preview results file. Note that this file only shows the records that are going to be changed.
    • Use the + icon to expand all PDS and files in the Preview Results window.
    • Use the - icon to collapse all Preview results.
    • Use the down arrow () to access a menu where you can control the format of the results as either a list or a tree view.
    • Use the Back button to return to the Update Text Matches dialog.
    • Use the Cancel button to exit from File-AID Search/Update without performing any changes.
    • Click the Finish button when you are sure you are ready to update your files.
14. When you are sure you are ready to update your files, click Finish. You will be prompted for confirmation. Click OK to proceed or Cancel to return. Summary statistics are then displayed in the Search view. To examine the updated file, right-click the file name in the results view to open a File-AID Data Editor session for the file.

Perform an Advanced Search/Update by Using Search/Update Criteria Created on the Mainframe

To perform an advanced search by using search criteria created on the mainframe.

1. Do one of the following:

   • From the Search menu, select File-AID Search.
   • On the toolbar, from the drop-down list, select File-AID Dataset Search.
   • Click Ctrl + H.
   • In the Host Explorer tree view, right click a PDS, sequential, or VSAM dataset and select Search. Datasets or PDS members can be multi-selected.
   • In the Host Explorer tree view, right click on a dataset filter and select Search.

   The File-AID Dataset Search tab of the Search dialog box appears.

2. Click Switch to advanced search. The dialog box contents refresh to show advanced search options. The dialog box can be resized to show all options.
3. Select Use selection criteria dataset(member).

4. Select the dataset from the list or browse to it. 

   Important

   If your saved selection criteria happens to contain any EDIT or REPLACE parameters, it will be considered invalid by File-AID Search/Update.

5. In the Host field, select the host that contains the datasets to be searched. If only one host is configured or the Search dialog box was accessed from a context-specific method that predetermines the host, the Host field is disabled and prepopulates with the host being used. Click Configure if you want to configure a new host connection. Refer to the Topaz Workbench Host Explorer User Guide for how to configure a new host connection.
6. In the Datasets (PDS, sequential, or VSAM) box, use the Add, Edit, Remove, and Remove All buttons to select the datasets to be searched.
   • Click Add to open the Add Datasets dialog box, which allows users to type or browse to datasets to be added to the Search dialog box.
   • Select a dataset and click Edit to edit the name of the dataset.
   • Select a dataset and click Remove to remove the dataset from the search.
   • Click Remove All to remove all datasets from the search. The Search action button is disabled if no datasets are specified.
7. Select the Process as JCL checkbox, if desired, to treat JCL continuation lines as one statement in 80-byte PDS members, thus searching the entire line for the search criteria.
8. Optionally, click Preferences to open the Preferences dialog box and set search preferences. Refer to the Topaz Workbench Host Explorer User Guide for how to set search preferences.

9. Click Search to perform the search. After the search runs, the results appear in the Search view. The Search view, if not visible, can be opened from the Window menu by selecting Show View>Other>General> Search. Refer to the Eclipse documentation at www.eclipse.org for information on the Search view. 

   Important

   This type of search ignores the search preference set on the maximum number of records to be returned. Refer to the Topaz Workbench Host Explorer User Guide for how to set search preferences.

10. Optionally, double-click a record in the Search view or click or to go to the selected line in the default editor.

    Important

    • To select the pages to be shown in the Search dialog box, click Customize and complete the Search Page Selection dialog box.
    • To set whether editors are reused when records are opened, from the Window menu, select Preferences and then, from the navigation tree, select General>Search. Select or clear the Reuse editors to show matches check box.

Saving and Opening Saved Search/Update Requests

All executed searches are saved. Optionally, a permanent name can be assigned to a search and the search then re-run by selecting it from the list of saved searches. All search requests are organized by type of search. Therefore, all saved and last executed basic searches are managed independently of advanced searches.
When opening a saved search request or showing previous searches, first select Switch to basic search or Switch to advanced search to access the proper list.

To save a search request

1. With the desired selection criteria appearing on the File-AID Dataset Search tab of the Search dialog box, click . The Save Search Request dialog box appears.
2. Enter a name for the search request and click OK. The named search can now be opened and rerun.

To open a saved search request

1. On the File-AID Dataset Search tab of the Search dialog box, click . The Open Search Request dialog box appears.
2. Select an existing saved search of the current type (basic or advanced) and click OK. The search request is entered on the Search dialog box.

Show Previous Search/Updates

Previously run searches can be reopened so they can be revised or rerun.

To show previous searches

Do either of the following:

• With the desired search appearing in the Search view, click . The Search dialog box appears showing the corresponding search criteria.
• On the File-AID Dataset Search tab of the Search dialog box, click . The last 15 searches of the current type (basic or advanced) that have been run and/or saved are listed by date/timestamp. Select the desired search. The Search dialog box refreshes to show the corresponding search criteria.

Edit, Duplicate, and Remove Conditions

To edit a condition:

1. On the File-AID Dataset Search tab of the Search dialog box, select the condition.
2. Click Edit. The Edit Search Criteria dialog box appears.
3. Make any necessary changes and click OK. The Search dialog box refreshes to reflect the changes.

To duplicate a condition

1. On the File-AID Dataset Search tab of the Search dialog box, select the condition.
2. Click Duplicate. The Edit Search Criteria dialog box appears.
3. Make any necessary changes and click OK. The Search dialog box refreshes to show the duplicated condition.

To remove a condition or set

1. On the File-AID Dataset Search tab of the Search dialog box, select the individual condition or set.
2. Do one of the following:
   • Click Remove to remove the selected condition or set.
   • Click Remove All to remove all selection criteria.

The selected selection criteria is removed from the Search dialog box.

Export and Import Search/Update Configurations

To export a search configuration

1. From the File menu, select Export. The Export dialog box appears.
2. Select Compuware>Topaz Legacy Export>Compuware Configuration Settings and click Next. The Export Compuware Configuration Settings dialog box appears.

3. In the Configuration Settings box, toggle open the File-AID node and select the Search check box. 

   Important

   Additional settings can be exported using this dialog box by selecting Export all, Select All, or by selecting additional check boxes.

4. From the To directory list, select, type, or browse to the directory in which to export the file.
5. Select or clear the Overwrite existing files without warning check box, depending on whether an existing file with the same name should be overwritten by the new file.
6. Click Finish. The search configuration is exported to a File-AID Settings\SearchSettings directory in the chosen location.

To import a search configuration

1. From the File menu, select Import. The Import dialog box appears.
2. Select Compuware>Topaz Legacy Import>Compuware Configuration Settings and click Next. The Import Compuware Configuration Settings dialog box appears.
3. From the From directory list, select, type, or browse to the directory above the File-AID Settings directory. 
   For example, if the search configuration is located at C:\MyExports\File-AID Settings\SearchSettings, enter C:\ MyExports\ in the From directory list.

4. In the Configuration Settings box, toggle open the File-AID node and select the Search check box. 

   Important

   Additional settings can be imported using this dialog box by selecting Import all, Select All, or by selecting additional check boxes.

5. Click Finish. The settings are imported and can be opened and rerun.

Field Selection Dialog Box

The Field Selection dialog box is used when performing a File-AID dataset search to allow users to select a COBOL or PL/I layout dataset from which to get length and location for a field.
To use the Select Field dialog box:

1. Access the dialog box by clicking Select Field on the Edit Search Criteria dialog box.
2. In the Layout dataset(member) field, do one of the following:
   • Type the dataset name(member name), then click Get Layout. The layout appears in the table.
   • Select the dataset name(member name) from the list. The layout appears in the table.
   • Browse to the dataset name and member name and click OK. The layout appears in the table.
3. If necessary, from the 01 level name list, select the appropriate layout to use.
4. Select the specific field containing the length and location you want to use. While a field within a COBOL OCCURS DEPENDING ON (ODO) or a PL/I REFER clause can be chosen, a warning will appear indicating that the selected field is a variably located field and may not always be found at the specified position.

5. Click OK. The length and location from the selected field are entered on the Edit Search Criteria dialog box.