Execute Prepared SQL with Parameter

Executes a prepared SQL query by specifying its syntax and parameters.

Inputs

Database connection
A CwDBConnection object that represents the database connection.

Query
A String that represents the SQL query to execute in the database.

Parameters
A Vector object of arguments to pass to parameters in the SQL query.

Exceptions

The Execute Prepared SQL with Parameter function block can throw the CwDBSQLException exception if a database error occurs.

Notes

Refer to the Notes section for the Execute Prepared SQL function block in this chapter.

Related information

This function block is based on the CwDBConnection.executePreparedSQL() method. For more information, see executePreparedSQL().

Copyright IBM Corp. 2004