Previous Topic

Next Topic

Book Contents

Book Index

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:

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.