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.