User Guide

11.0
- 10.0

Back Next

SQL Query Parameter

In the [SOURCE_INDIRECT_STATEMENTS] section of the configuration file, optionally enter one or more SQL query statements to be processed when an unload job runs.

Use the following parameter:

query_id: Defines an SQL query, such as a table join. You can specify the query_id parameters multiple times to define multiple SQL queries. Each query_id must be a unique key in the configuration file. Use the following syntax:
query_id=sql_statement
For example:
query1="SELECT * FROM table1 WHERE ROWNUM<10" query2="SELECT * FROM table2 WHERE col_id>100"
Fast Clone writes the results of these queries to the query1.dat and query2.dat files.
Use a
SELECT *
query only for source tables in which all of the columns have supported datatypes. If a source table includes any columns with unsupported datatypes, the SELECT query must exclude these columns.