Exporting data objects and database tables

You can export data and table objects in the QMF, Integrated Exchange Format (IXF), XML, or comma-separated value (CSV) format. The QMF format is the default.

When you run a query, QMF displays the result in a report. The raw data for the report is stored in a temporary storage area as a data object. Relational tables and views that are stored in the database are referred to as table objects.

You can export data and table objects to storage areas external to QMF. The exported formats of a table in temporary storage (DATA) and a table stored in the database (TABLE) are identical. An object that is exported as data can be imported as a table, and vice versa, unless the data is in CSV format.

You can create your own tables outside of QMF. Use the QMF, IXF, or XML format and import the contents of the UNIX file, TSO data set, or CICS® data queue that contains the table. Include the required fields and add your own data as appropriate. Then import the UNIX file, TSO data set, or CICS data queue into QMF as a table object.