Specifying file export options

You must specify one or more of the following options when you export query results to a file. The options that you specify depend on the type of file that you are exporting.

Table 1. Text options
Field File Type Description
What Data
  • .txt
  • .html
  • .csv
  • .ixf
  • .wqml
  • .xml
  • .dbf
 You use the following radio buttons to specify what data in the query results will be saved:
  • All to specify that all of the data in the current results grid will be saved with all the changes applied to it.

    For example, if you remove a column from the layout, it will not be saved in the export file.

    If your result set grid includes any calculated columns, they are included in the exported file along with other columns.

  • All - Result set only to specify that all of the data in the original query result set not depending on the changes applied to results grid will be saved.

    For example, if you remove a column from the layout, it will be saved in the export file anyway.

  • Selection to specify that only the data that you have selected in the current query results will be saved. This can include calculated columns if they are selected. The query result data that you want to save must be selected before you open the Export Query Results window.
Include Column Headings
  • .txt
  • .html
  • .csv
 Select this check box to include the query results column headings as the first row in the file.
Date or Time Format
  • .txt
  • .html
  • .csv
 Select one of the radio buttons to specify how the date and time should be formatted in the file:
  • ISO to specify that the date and time will be formatted in the file based on the ISO format. The date will be formatted as (YYYY-MM-DD) and the time will be formatted as (HH:mm:SS).
  • USA to specify that the date and time will be formatted in the file based on the USA format. The date will be formatted as (MM/DD/YYYY) and the time will be formatted as (HH:mm PM/AM).
  • JIS to specify that the date and time will be formatted in the file based on the JIS format. The date will be formatted as (YYYY-MM-DD) and the time will be formatted as (HH:mm:SS).
  • EUR to specify that the date and time will be formatted in the file based on the EUR format. The date will be formatted as (DD.MM.YYYY) and the time will be formatted as (HH.mm.SS).
  • Custom to specify a custom format for date and time values. "Date": and "Time:" text fields accept Java™ format strings. (See http://java.sun.com/j2se/1.4.2/docs/api/java/text/SimpleDateFormat.html for more details.)
CCSID
  • .txt
  • .html
  • .csv
  • .ixf
  • .dbf
 Use this field to select the code page to use when saving this file.
Note: When changing the CCSID for exporting to an .ixf file in the PC/IXF Version 2 format, be aware that:
  • Data lengths in columns in the exported file can change.
  • If the data length becomes greater after changing the encoding, the longer data will be truncated in the exported file. For example, truncation is probable when applying the UTF-8 encoding.
Display null values
  • .txt
 Use this field to specify the string that will be used to display null values.
Separate columns
  • .txt
 Use this field to specify the string that will be used to separate the columns.
Delimit values
  • .txt
 Use this field to specify the string that will be used to delimit values.
When should values be delimited
  • .txt
 Use this field to specify when values should be delimited. Your choices are:
  • Never
  • Only when necessary
  • Always
Which type of values should be delimited
  • .txt
 Select one or more of the following check boxes to specify what types of values should be delimited in the file:
  • Column headings
  • Character values
  • Numeric values
  • Date/time values
Format .ixf Select one of the following radio buttons to specify how to format the .ixf output file. Your choices are:
  • PC/IXF (Version 1) to export data in PC/IXF Version 1 format.
  • PC/IXF (Version 2) to export data in PC/IXF Version 2 format.
    Note:
    • If you change the encoding for the exported file from the original encoding, data lengths in columns in the exported file can change.
    • If the data length becomes greater after changing the encoding, the longer data will be truncated in the exported file. For example, truncation is probable when applying the UTF-8 encoding.
  • System/370 IXF to export data in System/370 IXF format.
Add Document Information .pdf Select this check box to add identification information in the document's properties fields when the PDF is created. Document information provides basic data about the document as well as criteria to facilitate searching. The document information includes:
  • Title specifies the title of the PDF document.
  • Author specifies the author of the PDF document.
  • Subject specifies the subject of the PDF document.
  • Keywords Specifies the keywords for the PDF document. Keywords are used as search criteria.
Use only ANSI Fonts .pdf Select this check box to specify that only ANSI fonts will be used in creating the PDF. If the PDF document includes only English characters, select this check box to produce a smaller PDF in less time.
Note: Some of the fonts (for example, TTC) can be displayed incorrectly.