Previous
Previous 		 Next
Next

Unloading Data

You can use the Unload page to export the contents of a table to a text file or XML document.


See Also:

"Choosing the Right Import/Export/Load/Unload Option"

Unloading a Text File

Use the Unload to Text Wizard to export the contents of a table to a text file. For example, you could export an entire table to a comma-delimited file (.csv).

To unload a table to a text file:

  1. On the Workspace home page, click the SQL Workshop icon.

  2. Click Utilities.

  3. Under Data Unload, click To Text.

    The Unload to Text Wizard appears.

  4. Select the appropriate schema and click Next.

  5. Select the table to unload and click Next.

  6. Highlight the columns to include, optionally enter a Where Clause to limit the records unloaded and click Next.

  7. For Options, enter the following:

    • Separator - Enter the type of separator used to separate column values.

    • Optionally Enclosed By - If your data contains a delimiter character, enter it here. See item Help for more details.

    • Include Column Names - Check this box to include the name of each column in the text file. See item Help for more details.

    • File Format - Select the appropriate file format. See item Help for more details.

    • File Character Set - Select the character set in which your text file is encoded. See item Help for more details.

  8. Click Unload Data.

    The File Download window appears.

  9. Click Save to download the file.

Unloading to an XML Document

Use the Unload to XML Wizard to export the contents of a table to an XML document adhering to the Canonical XML specification.

To unload a table to an XML document:

  1. On the Workspace home page, click the Utilities icon.

  2. Click Data Workshop.

  3. Under data Unload, click to XML.

    The Unload to XML Wizard appears.

  4. Select the appropriate schema and click Next.

  5. Select the table to unload and click Next.

  6. Highlight the columns to include.

  7. Check Export as File if you would like to save the output directly to a file.

    If you do not check Export as File, the XML document will be displayed in your browser and can be saved to a file or cut and pasted as necessary.

  8. Optionally enter a Where Clause to limit the records unloaded, and click Unload Data.

    A browser displays the XML data.


 Previous
Previous 		 Next
Next