Select Results--> Save to File to save the query results to a file with the file name, location, and format you specify.
This option is available only when you are viewing query results. You can save query results in various formats, such as .txt, .ixf, .html, .csv, .dbf, and .spm.
Optional: You can select a CCSID from the CCSID drop-down list if you are exporting the query results as a .txt, .csv or .htm file. This helps ensure operability between the exported files and other applications.