This option allows you to run an SQL script that is in another file. This statement cannot be used when running AQT control statements in the interactive mode of AQT.
Warning: AQT does not have any controls to prevent a recursive specification of Include statements.
This feature can be used to copy data from one database to another. The following example copies data from Table1 in Database1 to Table2 in Database2.
select * from table1;
delete from table2;
When this is specified in an Export, AQT will can write to a file different to the one specified in File. AQT will add a sequence number to the end of file name so that it is a unique file.
One must be aware of this if you use the file in a subsequent include step. For instance, the following would be very dangerous:
Select * from Customer_Details;
The export may write to a file other than "C:\AQT\customer_details.sql". This means that the include statement may not pick up the file that was created during the export.
This specifies whether or not AQT is to return an error condition if the file is not found.
By default, an error condition will be returned. If you have specified:
then the script will cease processing.