Running the DB2 command db2cli to run and capture SQL statements

To control how an application runs SQL statements with pureQuery client optimization, you capture the statements in a pureQueryXML file. The primary method of capturing of SQL statement is by enabling the application with pureQuery client optimization and capturing SQL statements as the application runs.

You can use the DB2® command db2cli to run SQL statements that are in file. When you run the SQL statements, you can optionally capture the statements in a pureQueryXML file.

You can also use the db2cli command to validate the SQL statements in the file.


Feedback