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 IN-ports or OUT-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.
