Scripting functions

The valid values for function are as follows:

Export	Export the results of the following SQL statement. In batch mode, this applies to all subsequent SQL statement until another Output statement.
Parms	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 Output or Parms statement.
Queryinfo	System-generated value that records the positions of tables in the Gui Query Builder.
Connect	Connects you to a database. This is mainly used when running Batch Queries.
Use	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.
Disconnect	Disconnects you from a database.
Compschema	Runs the Compare Tables in Schema function in batch mode.
Datacomp	Runs the Data Compare function in batch mode
Options	Specify some options for the batch session.
Include	Allows you to import some SQL from another file.
Queryparm	Prompts the user to enter parameter values.
Setparm	Set a parameter to a particular value.
Load	Run the Data Loader.
Tran	Allows you to run statements under transactional control
CloseXL	Closes Excel if it is open
Layout	Applied a layout to the following query.
RenameButt	Renames the button of the most recent data display window displayed.

Examples of parameter usage

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.