The valid values for function are as follows:
Export the results of the following SQL statement. In batch mode, this applies to all subsequent SQL statement until another Export statement. |
|
Parameters to be used in the following SQL statement. Applies only to the next SQL statement. If you are running a script with many SQL statements, you will need to precede each statement with an Export or Parms statement. |
|
Queryinfo |
System-generated value that records the positions of tables in the GUI Query Builder. |
Connects you to a database. This is mainly used when running Batch Queries. |
|
When running Batch Queries, this specified the database to use for the subsequent SQL statements. You would use this if you have more than one database connection active. |
|
Disconnects you from a database. |
|
Runs the Compare Tables in Schema function in batch mode. |
|
Datacomp |
Runs the Data Compare function in batch mode |
Specify some options for the batch session. |
|
Allows you to import some SQL from another file. |
|
Prompts the user to enter parameter values. |
|
Set a parameter to a particular value. |
|
Run the Data Loader. |
|
Allows you to run statements under transactional control |
|
Closes Excel if it is open |
|
Applied a layout to the following query. |
|
Renames the button of the most recent data display window displayed. |
AQT provides a number of examples of parameter usage. The following files are deployed with AQT:
Batch_sample.bat
. This is a Windows command file that runs AQT in batch mode. In this file you specify the name of the AQT batch script to run. The batch script will be one of the following files.
Batch_sample.sql
. Script that demonstrates most of the capabilities of AQT batch processing.Batch_copy.sql
. Script that shows how you can copy data from one database to another.Batch_parms.sql
. Script that demonstrates the prompting for parameters.Batch_proc.sql
. Script that demonstrates the running of stored procedures.In addition:
startup.bat
and startup.sql
demonstrate specifying a startup script, which runs when AQT is started.