Working with a prepared SQL statement - Portlet Factory v6.1.2

Portlet Factory, Version 6.1.2

Working with a prepared SQL statement

The SQL Statement builder provides more basic functionality than the SQL Call builder. The SQL Statement builder is designed to work with a prepared or callable SQL statement that is ready for execution. The builder allows you to specify to the statement values for positional parameters. You can also make various performance-enhancing settings to the ResultSet and execution throttles to tune the query to the database. To use a prepared SQL statement in this builder, follow these steps.

Code a valid SQL statement in the SQL Call builder or in an editor such as Notepad.
Paste the text of the statement into the SQL Statement builder or identify an indirect reference where the text is located, such as a Variable.
If the statement includes positional parameters (?), identify those parameters in the builder Statement Parameters tables.

Parent topic: Working with a database

Library | Support |