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