Exporting query results to Amazon S3

You can export query results data to Amazon S3 by using the Export Query Results wizard.

1. To open the Export Query Results wizard, select File > Export.
2. Select Result set from the list of available export wizards and click Next.
3. Select Amazon S3.
   The fields that are required to export query results to Amazon S3 are displayed.
4. From the Source list, select the query result set that you want to export.
   Note: If the query that you are exporting includes several result sets, all of them are displayed in the Source field.
5. From the Export type list, select the type of file that you want to export.
   You can choose one of the following file types:

   • Avro (*.avro)
   • Parquet (*.parquet)
   • PDF (*.pdf)
   • CSV (*.csv)
   • IXF (*.ixf)
   • XML QMF Markup Language file (*.xml)
   • HTML (*.htm)
   • TEXT (*.txt)
   • dbase III (*.dbf)
   • XLS Microsoft Excel 97-2003 (*.xls)
   • XLSX Microsoft Excel 2007 (*.xlsx)

   Note: Some of the fonts (for example, TTC) can be displayed incorrectly in PDF files.
6. In the S3 Object Key field, specify the entire file path of the Amazon S3 storage where you want to export the file.
   Example: qmf/websphere/employee.txt
7. From the Amazon S3 Data Source list, select the Amazon S3 data source where you want to export the file.
8. Click Finish.