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 (COBOL User Guide)

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.

Code Debug TSO’s Db2 capabilities are greatly enhanced when you have Code Debug Db2 Extension and File-AID for Db2 installed at your site. This versatile union lets you debug, prototype SQL calls, and analyze COBOL Db2 programs in Code Debug TSO. At the same time, you are also permitted to dynamically access File-AID for Db2, BMC’s interactive Db2 database management tool that lets you create, view, change, and customize the Db2 table data associated with the program without coding SQL. File-AID for Db2 also provides facilities for interactive SQL development and analysis and a host of utilities. See Using Code Debug for Db2 Extension for information about how to browse and edit Db2 table data while testing your program, analyze SQL statement execution with the FADB2 EXPLAIN command, and prototype SQL logic by inserting SQL statements.

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 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.

You can bypass the File-AID for Db2 Primary Option Menu by entering the FADB2 command with the keyword or 1-character number or letter that directly accesses a specific File-AID for Db2 function. For example, to directly access the File-AID for Db2 Browse function from Code Debug TSO, enter:

   FADB2 BROWSE

The keywords and 1-character numbers or letters that access File-AID for Db2 functions are listed on the File-AID for Db2 Primary Menu.

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*