Specifying how your data is to be exported

If your SQL runs a query which produces data, you will need to specify how the data is to be exported.

If you have already specified this with an --aqt export statement, this step will not be shown.

This dialog shows a limited set of options for exporting data. To see the full set of options, click on Advanced.

Export File

By default, the export will go a file named $jobname_$datetime.

• $jobname is the name of the batch job (UpdateSalaries in this example)
• $datetime is the date/time the batch job is run (for example 20210605123457)
• if the job exports multiple files, $runtime will be the same for all of them. However File Mode of Create New will ensure that each export will go to a new file
• the export files will be created in the Default directory for Exports, specified in Options > File Locations.

Viewing the Export File

Once the batch job has run, you can view the export file/s in several ways:

• from the Manage Batch Jobs dialog, click on the batch job > History > Show Exported Files
• from the Export History window
• if you have exported the results as a saved-grid, it can be seen in the Query Explorer.