Use the Captured SQL Files viewer to review the SQL statements that are
in a captured SQL file. You can also use the viewer to open the window
where you specify the options for binding the captured SQL statements
to a database to create the bind package.
To open the Captured SQL Files viewer:
In the Solution Explorer, expand the Captured SQL Files
folder of the .NET application, and then double-click a captured SQL
(.capt) file.
Viewer toolbar
Use the buttons on the viewer toolbar to perform actions
that are involved with binding the captured SQL statements.
Connection
Select the data connection to use to bind the captured
SQL statements.
The package that contains the static SQL must be bound
to the database that the application uses.
New
Click to define a new data connection in the Add
Connection window.
Bind Options
Click to specify the options for binding the captured
SQL statements in the Captured SQL
Bind Options window.
Create Package
Click to bind the SQL in the open captured SQL file and
generate a static package.
Clicking this button calls the DB2®db2cap
utility and passes the captured SQL file and its
associated connection information to the utility.
Statements
This section contains a list of the SQL statements that use
the database that is associated with the data connection
that was selected for the capture process.
Statement
Lists the SQL statements that were captured when
the .NET application was run.
Type
Shows the cursor type of the SQL statement in the row.
The possible values are:
SELECT_CURSOR
SELECT_CURSOR_WITHHOLD
UPDATE_CURSOR
INSERT_CURSOR
DELETE_CURSOR
OTHER
Unlabeled box
A read-only field that displays the complete
SQL statement for the row that is selected
in the Statements section.
The field uses syntax highlighting to
differentiate DB2 and SQL keywords.