Export utility overview
The export utility extracts data using an SQL select or
an XQuery statement, and places that information into a file. You
can use the output file to move data for a future import or load operation
or to make the data accessible for analysis.
Privileges and authorities required to use the export utility
Privileges enable you to create, update, delete, or access
database resources. Authority levels provide a method of mapping privileges
to higher-level database manager maintenance and utility operations.
Exporting data
Use the export utility to export data from a database to
a file. The file can have one of several external file formats. You
can specify the data to be exported by supplying an SQL SELECT statement
or by providing hierarchical information for typed tables.