Before you begin
You must have an active connection to the SAMPLE database. If you do not have an active connection, the workbench prompts for a connection when you perform the bind operation.
The pureQueryXML file that you created in the previous lesson contains a single statement set. If you perform the bind process with the file, you create a single set of packages on the target database. In this lesson, you update statement set name in the pureQueryXML file. Then you create a single set of packages from the pureQueryXML file and bind those packages.
After performing the binding process on the target database, you set pureQuery Runtime properties to specify that pureQuery runs the statements issued by the application statically.
When you update the pureQueryXML file, the workbench configures the pureQueryXML file as needed. The configuration process manages the SQL statements in the pureQueryXML file and adds information needed for the binding process. The workbench uses the options defined in the Default.genProps file to configure the capture.pdqxml pureQueryXML file.
To update the pureQueryXML file and bind the SQL statements in the file:
To configure pureQuery Runtime to run SQL statements statically:
To test the mapping between the pureQueryXML file and the packages on the database: