Space announcement This documentation space provides the same content as before, but the organization of the content has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

Accessing File-AID for Db2 from Code Debug TSO

This section describes how to access and exit File-AID for Db2 from Code Debug TSO. File-AID for Db2 is BMC’s interactive Db2 database management tool that lets you create, view, change, and customize the Db2 table data associated with your program without coding SQL. File-AID for Db2 also provides facilities for interactive SQL development and analysis and a host of utilities. See the File-AID for DB2 Reference for information about using File-AID for Db2.

Important

Code Debug TSO supports debugging of any Db2 program within all execution environments selectable under the Environments Menu, with the following exceptions:

  • The first exception to this Code Debug TSO support rule is the Code Debug TSO dialog box environment.
  • A second exception to normal debugging is that Code Debug Db2 Extension cannot be accessed when using the Batch Connect facility.
    You must bind your program application plan with File-AID for Db2 if any of the following apply:
  • The program executes statically compiled SQL statements. If the program executes only dynamically inserted SQL statements, you can either bind your application plan with File-AID for Db2 or use the File-AID for Db2 default plan in place of your application plan.
  • The program executes in the IMS environment.

See the Binding the Application Plan or Package for information about binding.

The following accesses File-AID for Db2 from Code Debug TSO:

  • Select the FADB2 menu item on the Code Debug TSO Primary Menu.
  • Enter the FADB2 command on any Code Debug TSO Source display screen.

The File-AID for Db2 Primary Option Menu is displayed. The menu lists all File-AID for Db2 facilities.

Important

The SQL Development and Analysis facility is available from Code Debug TSO only when File-AID for Db2 is accessed by entering F (FADB2) on the Code Debug TSO Primary Menu.

The plan name and Db2 subsystem you specified to start your Code Debug TSO test session are also in effect when you invoke File-AID for Db2 from a Code Debug TSO Source display screen. However, a subsystem switch is not permitted under File-AID for Db2 when it is accessed from Code Debug TSO.

Exiting File-AID for DB2

When you finish using File-AID for Db2 functions, you can either:

  1. Enter =X to return to the Code Debug TSO Source display screen displaying your source program.

  2. Enter END, which will take you to the File-AID for Db2 Primary Option Menu from which you can select another File-AID for Db2 function.

 

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