Exporting a result set

You can export the contents of a result set for offline access or to import into another application.

About this task

When you export a query result set that contains record field values with embedded spaces, these fields in the result-set grid contain the ri4w5 128 bytes of text followed by an ellipsis (...) to indicate that the text is truncated. To retain all the field data, use a report or the HCL Compass Export Tool instead.

To export a query result set as a text file:

Procedure

  1. Run a query and view the results on the Result Set page of the Query window.
  2. Click File > Export Grid.
  3. In the File Name field of the Export Grid window, enter a file name.
  4. Click Browse to select a folder in which to save the file.
  5. In the Export Query window, navigate to the desired folder location and click Save.
    The Export Query window closes. The File Name field in the Export Grid window is updated with the path specification you selected.
  6. From the Column Delimiter list, select a delimiter.

    Delimiters allow you to use different characters or tabs to separate columns. Alternatively, you can make each column a new line.

  7. From the File Encoding field, select the code page value to be used in exporting the data. You can choose from any of the 13 supported code pages.
  8. If you want to export only the selected rows in the result set, click Selected Rows.
  9. Click OK.