The SQL Executor component
allows you to execute one or more custom SQL statements against
a database server.
SQL Executor is a standalone component without
input ports or output ports. You can place SQL Executor in a project separate
from other components, or in a single project containing one or
more SQL Executor components. For example, you can use SQL Executor
to:
Load data from a source table to a text
file (with a format that IQ can support), if the source table allows
extracting data into a file by using a SQL statement.
Load data from a text file into the target IQ database,
in a single transaction, using the Load Table command.