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.
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.