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.
WarningImportant
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.
WarningImportant
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:
- Enter =X to return to the Code Debug TSO Source display screen displaying your source program.
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.
