Accessing DB2 Data

Following are the instructions for accessing DB2 data.
If you have not already started

Topaz Workbench

and File-AID Data Editor, see Opening-the-File-AID-Data-Editor.
To Access the File-AID Data Editor DB2 Editor:

1. You must define a filter to access DB2 tables and views. Right-click on 

   File-AID for Db2

   and select Add Filter. The Specify DB2 Filter dialog box appears. 

   Important

   If you have already defined a filter, you can expand the filter and continue expanding down through subsystems (SSID) and Creators until you reach the table or view you want to access.

2. Fill in the SSID, Creator, and Table Name you want to access. For SSID, you may select a target subsystem from the list using the pull-down control. You can use the asterisk (*) wild card at any point including the first character. Click OK to save and process the filter.

   Important

   • Using an asterisk wild card as the first character will cause additional processing time when referencing the filter since the DB2 catalog must be searched and results returned to your workstation.
   • When specifying Creator or Table Name, exact case is used to match your filter against the catalog. If your target Creator or Table names are upper case, you must specify your filter in upper case or you may not find any matches. A special preference, Uppercase object names (Window > Preferences > Compuware > File-AID Data Editor > DB2 tab), may be set to cause all keystrokes to be treated as upper case when defining a filter. This makes it much easier and less error prone for users when all objects in the DB2 catalog are all upper case.
   • File-AID Data Editor supports several DB2 releases.
3. Select the table, then either:
   1. double-click or
   2. right-click and select File-AID Data Editor.
      The DB2 File-AID Data Editor Request view appears. For more information, see Requesting-DB2-Data.

4. Enter your selection criteria and click Run. This will navigate to the data editor where you can view or edit your data.