Execute Prepared SQL

Executes a prepared SQL query by specifying its syntax.

Inputs

Database connection
A CwDBConnection object that represents the database connection.

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

Exceptions

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

Notes

The SQL statements you can execute include the following (as long as you have the necessary database permissions):

Related information

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

Copyright IBM Corp. 1997, 2004