Generating an Export statement

In the Export Data window, the option Tools >Generate Batch Control Stmt (or Ctrl+G) will generate an Export statement according to the options specified on the window.

Exporting Multiple Tables

If you wish to export data from multiple tables (for instance, all tables in a schema), you can use the Generate Text feature of AQT to generate multiple --aqt export statements.

For instance, to export all the tables in a schema to separate files:

In the Database Explorer, make sure you are displaying the list of tables you wish to export. You can apply a filter to limit the list to the tables you are interested in.
Click on Tools > Generate Text.
Enter the following into the text-box:
--aqt export,file=$2.csv,type=csv,filemode=replace,prompt=no

select * from $1.$2;
Make sure you have the Repeat What? option to Entire text
Click on Generate.
Copy the generated text to the Run SQL window, or include it in a batch script
Click on Run.

Note that the same result can be achieved by have a single Export statement:

--aqt export,file=<table>.csv,type=csv,filemode=replace,prompt=no

followed by a number of select statements.

Advanced Query Tool

https://www.querytool.com