You can export one or all result sets. Exporting saves the result set to a file outside of any Sybase WorkSpace project, for use with other applications.
To export a single result set:
In SQL Results, if you are in single-tab mode, toggle to multitab mode by clicking Display Result in Single Tab (
).Select the result instance by placing the cursor anywhere inside the result set under a Result tab in SQL Results view.
Save the result for export by any of these methods:
Right-click and select Export Single Result.
Click the Export Single Result button (
) in the SQL Results toolbar.
The Export Result dialog appears.
Select a file format (Plain Text, XML, HTML, or CSV) from the Format list.
Browse for the location to save the result set.
Click Save. The Select Export Format page reappears, and the path name to your export file appears in the File name field.
Specify export format options.
Click Finish. You return to SQL Editor.
To export all result sets for the current operation:
Select the result instance by placing the cursor anywhere inside the result set under the Result Set tab in SQL Results view.
Save the result for export by any of these methods:
Right-click and select Export All Results.
Click the Export All Results button (
) in the SQL Results
toolbar.
The Export All Results dialog appears.
Select a file format (Plain Text, XML, HTML, or CSV) from the Format list.
Browse for the location to save the result sets. The Export Result dialog appears.
Click Save. The Select Export Format page reappears, and the path name to your export file appears in the File Name field.
Specify export format options.
Click Finish. You are returned to SQL Editor.