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