Specify formats for exporting or saving SQL results to a file, using one of the Save Result or Export Result context menu options in the SQL Results view. You can set preferences for the XML format, column delimiters, and encoding.
To set export format preferences:
Select Window|Preferences from the main menu bar.
The Preferences dialog box appears.
In the left pane, expand Sybase, Inc, then expand Database Development and select Export Format.
Specify the XML format for saving or exporting SQL results.
XML Export Format Preferences
| Field | Explanation |
|---|---|
Add XML Header Automatically | To insert the XML Header string automatically at the beginning of each XML file, select the check box. |
XML Header | Enter the header string to be inserted at the beginning of the XML file, for example, <?xml version="1.0" encoding="UTF-8"?>. |
Add XML Root Tag Automatically | To include the contents of the SQL result enclosed in a root tag you specify in the Root Tag field, select the check box. |
Root Tag | Enter the XML root tag to wrap the SQL results with, for example, resultsets. Do not include angle brackets. |
Select a default column delimiter from the drop-down.
If you select User-defined, enter one or more characters in the Delimiter box. Default is semicolon (;).
Delimiters for Output Formats
| Output format | Delimiter |
|---|---|
| Column Aligned | Use the same-width font to display the result, and align each column, fill spaces between columns (default) |
| Comma Separated | Use comma to separate columns |
| Tab Delimited | Use tab to separate columns |
| User-defined | Use user-defined string to separate columns |
Select a default output encoding.
If you select Other, choose an encoding from the drop-down. These output encodings are available for all Sybase databases supported by Sybase WorkSpace.
Send your feedback on this help topic to Sybase Tech Pubs: pubs@sybase.com