Debugging A SQL Stored Procedure .

The CICS BANKDEMO application has a small stored procedure example built in to it .

In order to proceed with this tutorial , please perform the following steps .

• Configure and compile the BANKDEMO CICS application as a disk hosted application(bankdemo2 project ) as described in the samples section of this document.
• Study the debugging topics and using that knowledge , make sure you can debug and step into the bankdemo application.
  • Pay particular attention to the SQL server debugging configuration.
    • Make sure that the Enable SQL server debugging option is set
    • Make sure that the SQL server instance is configured to allow SQL/CLR debugging .
• Start the BANKDEMO region using the managed server explorer in Visual Studio.
• Set a breakpoint in the ZSQLTST module on the line before the EXEC SQL EXECSP statement.
• Set a breakpoint in the ZSQLTST module on the line containing the EXEC CICS RETURN statement.
• Open the SQL Server Object Explorer and open the dbo.CreateEmpDb stored procedure .
  • Set a breakpoint on the line containing the DROP TABLE statement.
• Start debugging
• Attach a terminal to the region and type bank<enter>
  • The BANK application login screen will present.
  • Push the f5 key
• In visual studio , the application should halt on the first breakpoint in ZSQLTST.CBL .
  • Press f5 or step , the application should now continue and break in the SQL stored procedure .
  • Step through the TSQL statements
  • Step out of the SQL procedure and the application should halt on the breakpoint with the EXEC CICS RETURN.
• At this point the tutorial is complete.