The Export Data dialog box opens.
You can produce a text file, with a .txt extension. This is a standard ASCII file with optional string and column delimiters (as specified in the Export Text/DEL Options dialog box).
You can produce an .htm type file (HTML). This is an HTML file that can be viewed by any web browser. All of the HTML tags are automatically generated in the file and it is prepared to be published on your Internet or intranet web site. The options you choose on the Export HTML Options dialog box control the appearance of the exported data.
You can produce an .ixf type file. An IXF export preserves all database information, including column headings and data types. It is typically used to transfer information from one database to another.
You can produce a .csv type file. A CSV export is similar to a text export, using a comma as the column delimiter. This format is most commonly used by spreadsheet applications.
You can produce a .dbf file, which is a dBASE III file, part of the popular database management system. The dBASE format for storing data has become a de facto standard, and is supported by nearly all database management and spreadsheet systems. Even systems that do not use the dBASE format internally are able to import and export data in dBASE format.
You can produce a SPM file, which enables you to view data from DB2 in a map rather than through conventional means such as in a chart, report, or browser. Only tables having a column defined as GEO type can be rendered as a map in QMF for Windows.
One of the following dialog boxes opens: