Specifying export query operation options

You use the export query operation to export query results to a file.

About this task

To add an export query operation to an action:

Procedure

  1. Open the Specify operations page of the Action Wizard and click Add Operation.
    The Operation Wizard opens.
  2. Click Export query and then click Next.
    The Specify export parameters page opens.
  3. If the query has multiple result sets, select the result set that you want to export from the Result set list.
  4. If the query has multiple display modes, select the display mode that you want to export from the Display mode list.
  5. Select the file type that you want to export from the Export type drop-down list.
    Valid file types are:
    • Avro - Apache Avro (*.avro)
    • Parquet - Apache Parquet (*.parquet)
    • Text (*.txt)
    • CSV (*.csv)
    • PDF (*.pdf)
    • HTML (*.html)
    • IXF (*.ixf)
    • XML Extensible Markup Language file (*.xml)
    • XLS Microsoft Excel 97-2003 (*.xls)
    • XLSX Microsoft Excel 2010 and later (*.xlsx)
    • PNG (*.png)
  6. Specify the location to save the object.
    Note: The file will be exported if the Root output directory is specified by administrator.
    There are two options:
    1. In case the Root output directory is specified on the Server-Side File System page of the Preferences window, you can just type a path and a file name or only a file name in the Path field. The file will be exported to this root directory automatically. In QMF for WebSphere® you can specify only the path, lying in the root directory set by administrator. Otherwise, the export will be forbidden and an error will occur.
    2. To specify a conditional save location for the object, click Formula and then click the ellipsis (...). In the Formula editor, specify the formula to use to determine the location to save the object and click OK.
  7. Select the Delete after task completion check box if you want to remove the exported file from the specified location when the scheduled task is completed.
  8. Select the Mark as attachment check box if you want to be able to attach this query result set to the email automatically.
  9. Click Next.
    • If you selected the Text of CSV export formats, the Specify [file type] export options page opens. On this page you can select additional options that are available depending on the type of file that you are creating. Then, the Specify delimiter options page opens. On this page, specify the detailed information about how the result set will be displayed in the selected format.
    • If you selected any other export format except XML, the Specify [file type] export options page opens. On this page you can select additional options that are available depending on the type of file that you are creating.
    • If you selected the XML format, click Finish instead of clicking Next.
  10. Click Finish.
    The Operation Wizard closes.