After you capture the SQL statements in your .NET application, you can review the captured statements in a viewer. You also use the viewer to open the window where you set the bind options to create the package.

Prerequisites:

• The solution that contains the .NET application must be open in the Solution Explorer.
• You must capture the SQL statements in the .NET application.

To review captured SQL statements:

1. In the Solution Explorer, expand the Captured SQL Files folder, and then double-click the captured SQL file that you want to review.

   The Captured SQL Files viewer opens.

2. In the Statements section of the viewer, scroll through the list of captured SQL statements.
3. Optional: Click an SQL statement in the list to see the complete statement.

   The selected SQL statement is displayed in the code editor in the lower section, with syntax highlighting for DB2 and SQL keywords.

See Also

Improving Performance and Security in .NET Applications with Static SQL | Using Static SQL in .NET Applications | Binding Captured SQL Statements in Packages

.NET Development Forum   DB2 FAQs

© Copyright IBM Corporation 2002, 2019. All Rights Reserved.