| <?xml version="1.0" encoding="UTF-8"?> |
| <!DOCTYPE html |
| PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> |
| <html lang="en" xml:lang="en"> |
| <head> |
| <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/> |
| <meta name="copyright" content="(C) Copyright 2005"/> |
| <meta name="DC.rights.owner" content="(C) Copyright 2005"/> |
| <meta name="DC.Type" content="reference"/> |
| <meta name="DC.Title" content="Export Format Options Preferences"/> |
| <meta name="abstract" content="Set export format options for the XML format, column delimiters, and encoding."/> |
| <meta name="description" content="Set export format options for the XML format, column delimiters, and encoding."/> |
| <meta name="DC.subject" content="sybase_workspace, database_development, dtp"/> |
| <meta name="keywords" content="sybase_workspace, database_development, dtp"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700412058.html"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700414871.html"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700416261.html"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700480170.html"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700490436.html"/> |
| <meta name="DC.Creator" content="ekapner"/> |
| <meta name="DitaCms:MapImporter:OriginalFileFullPath" content="\\kohman-xpvm1\tech_pubs_base_pool_1\projects\workspace\ws\en\source\r_export_format_preferences.xml"/> |
| <meta name="DitaCms:MapImporter:OriginalObjectId" content="reference_DFD2385133DA4C6599635435D3184AA2"/> |
| <meta name="status" content="Authoring:initial"/> |
| <meta name="source" content="Map Importer"/> |
| <meta name="comment:system" content="Imported topic [2008/12/19 08:26:53]"/> |
| <meta name="DC.Format" content="XHTML"/> |
| <meta name="DC.Identifier" content="asc1229700413480"/> |
| <meta name="DC.Language" content="en"/> |
| <link rel="stylesheet" type="text/css" href="../../styles/commonltr.css"/> |
| <link rel="stylesheet" type="text/css" href="../../styles/doc.css"/> |
| <title xmlns:xs="http://www.w3.org/2001/XMLSchema">Export Format Options Preferences</title> |
| <meta name="provider" content="Sybase, Inc."/></head> |
| <body id="asc1229700413480"><a name="asc1229700413480"><!-- --></a> |
| <br/> |
| |
| <h1 class="topictitle1">Export Format Options Preferences</h1> |
| |
| |
| |
| <div><p>Set export format options for the XML format, column |
| delimiters, and encoding. |
| </p> |
| |
| |
| <div class="tablenoborder"><a name="asc1229700413480__table_AD1391331AC54D6DB7C71201BC407498"><!-- --></a><table cellpadding="4" cellspacing="0" summary="" id="asc1229700413480__table_AD1391331AC54D6DB7C71201BC407498" frame="border" border="1" rules="all"><caption><span class="tablecap">Table 1. Export Format Options preferences: General</span></caption> |
| |
| |
| |
| <thead align="left"> |
| <tr> |
| <th class="cellrowborder" valign="top" id="d2774e61">Field |
| </th> |
| |
| <th class="cellrowborder" colspan="2" valign="top" id="d2774e64">Description |
| </th> |
| |
| </tr> |
| |
| </thead> |
| |
| <tbody> |
| <tr> |
| <td class="cellrowborder" valign="top" headers="d2774e61 ">Add XML Header Automatically |
| </td> |
| |
| <td class="cellrowborder" colspan="2" valign="top" headers="d2774e64 ">Insert the XML header |
| string automatically at the beginning of each XML file. |
| </td> |
| |
| </tr> |
| |
| <tr> |
| <td class="cellrowborder" valign="top" headers="d2774e61 ">XML Header |
| </td> |
| |
| <td class="cellrowborder" colspan="2" valign="top" headers="d2774e64 ">Enter the header string |
| to be inserted at the beginning of the XML file, for example, |
| <samp class="codeph"><?xml version="1.0" |
| encoding="UTF-8"?></samp>. |
| </td> |
| |
| </tr> |
| |
| <tr> |
| <td class="cellrowborder" valign="top" headers="d2774e61 ">Add XML Root Tag Automatically |
| </td> |
| |
| <td class="cellrowborder" colspan="2" valign="top" headers="d2774e64 ">Include the contents |
| of the SQL result enclosed in a root tag you specify in the Root Tag field. |
| </td> |
| |
| </tr> |
| |
| <tr> |
| <td class="cellrowborder" valign="top" headers="d2774e61 ">Root Tag |
| </td> |
| |
| <td class="cellrowborder" colspan="2" valign="top" headers="d2774e64 ">Enter the XML root tag to |
| wrap the SQL results with, for example, |
| <samp class="codeph">resultsets</samp>. |
| <p>Do not include angle brackets. |
| </p> |
| |
| </td> |
| |
| </tr> |
| |
| </tbody> |
| |
| </table> |
| </div> |
| |
| |
| <div class="tablenoborder"><a name="asc1229700413480__table_2752C185001E4E98A4BD39DB876A47B5"><!-- --></a><table cellpadding="4" cellspacing="0" summary="" id="asc1229700413480__table_2752C185001E4E98A4BD39DB876A47B5" frame="border" border="1" rules="all"><caption><span class="tablecap">Table 2. Export Format Options preferences: Default column delimiter</span></caption> |
| |
| |
| |
| <thead align="left"> |
| <tr> |
| <th class="cellrowborder" valign="top" id="d2774e136">Field |
| </th> |
| |
| <th class="cellrowborder" colspan="2" valign="top" id="d2774e139">Description |
| </th> |
| |
| </tr> |
| |
| </thead> |
| |
| <tbody> |
| <tr> |
| <td class="cellrowborder" valign="top" headers="d2774e136 ">Output Format |
| </td> |
| |
| <td class="cellrowborder" colspan="2" valign="top" headers="d2774e139 "> |
| <br/><a name="asc1229700413480__ul_756D6FAF74FD476DAD349EE59FDF44C7"><!-- --></a><ul id="asc1229700413480__ul_756D6FAF74FD476DAD349EE59FDF44C7"> |
| <li id="asc1229700413480__li_05DE8A8E07B94FC7A4B0394750CA6AFF"><a name="asc1229700413480__li_05DE8A8E07B94FC7A4B0394750CA6AFF"><!-- --></a> |
| <span class="uicontrol">Column Aligned</span> — use the same-width font to display the result, and align each column, fill |
| spaces between columns (default) |
| </li> |
| |
| <li id="asc1229700413480__li_C3BA67D2FB2F48A684B84DDA9EC68C95"><a name="asc1229700413480__li_C3BA67D2FB2F48A684B84DDA9EC68C95"><!-- --></a> |
| <span class="uicontrol">Comma |
| Separated</span> — use comma to separate columns |
| </li> |
| |
| <li id="asc1229700413480__li_1DDF5FEA39534D1A9CE23939663FD70B"><a name="asc1229700413480__li_1DDF5FEA39534D1A9CE23939663FD70B"><!-- --></a> |
| <span class="uicontrol">Tab Delimited</span> — use tab to separate columns |
| </li> |
| |
| <li id="asc1229700413480__li_2B43C4A5500449859405B77139633C6B"><a name="asc1229700413480__li_2B43C4A5500449859405B77139633C6B"><!-- --></a> |
| <span class="uicontrol">User-defined</span> — use user-defined string to separate columns |
| </li> |
| |
| </ul> |
| |
| </td> |
| |
| </tr> |
| |
| <tr> |
| <td class="cellrowborder" valign="top" headers="d2774e136 ">Delimeter</td> |
| |
| <td class="cellrowborder" colspan="2" valign="top" headers="d2774e139 ">Displays the delimiter for the output format.</td> |
| |
| </tr> |
| |
| </tbody> |
| |
| </table> |
| </div> |
| |
| |
| <div class="tablenoborder"><a name="asc1229700413480__table_E92F5EB0863F46ADB4BCA238A814DD13"><!-- --></a><table cellpadding="4" cellspacing="0" summary="" id="asc1229700413480__table_E92F5EB0863F46ADB4BCA238A814DD13" frame="border" border="1" rules="all"><caption><span class="tablecap">Table 3. Export Format Options preferences: Default output encoding</span></caption> |
| |
| |
| |
| <thead align="left"> |
| <tr> |
| <th class="cellrowborder" valign="top" id="d2774e211">Property |
| </th> |
| |
| <th class="cellrowborder" colspan="2" valign="top" id="d2774e214">Description |
| </th> |
| |
| </tr> |
| |
| </thead> |
| |
| <tbody> |
| <tr> |
| <td class="cellrowborder" valign="top" headers="d2774e211 ">Default Output Encoding |
| </td> |
| |
| <td class="cellrowborder" colspan="2" valign="top" headers="d2774e214 "> |
| <br/><a name="asc1229700413480__ul_AA88E8D9BC46446197319760EF8EEE90"><!-- --></a><ul id="asc1229700413480__ul_AA88E8D9BC46446197319760EF8EEE90"> |
| <li id="asc1229700413480__li_4CBA3775D73D40FCB8682A72B08BE393"><a name="asc1229700413480__li_4CBA3775D73D40FCB8682A72B08BE393"><!-- --></a> |
| <span class="uicontrol">cp1252</span> (default) — Microsoft Windows US (ANSI). </li> |
| |
| <li id="asc1229700413480__li_E803339B8E374BA784A461B45FB6B5CF"><a name="asc1229700413480__li_E803339B8E374BA784A461B45FB6B5CF"><!-- --></a> |
| <span class="uicontrol">ISO-8859-1</span> — ISO |
| 8859-1 Latin 1. |
| </li> |
| |
| <li id="asc1229700413480__li_30D0D7B7D13B4E428D03D8BA552FE010"><a name="asc1229700413480__li_30D0D7B7D13B4E428D03D8BA552FE010"><!-- --></a> |
| <span class="uicontrol">US-ASCII</span> — US |
| ASCII, with 8-bit data, ISO 646. |
| </li> |
| |
| <li id="asc1229700413480__li_0B3BDD321121440EBE2DEB5C53A68008"><a name="asc1229700413480__li_0B3BDD321121440EBE2DEB5C53A68008"><!-- --></a> |
| <span class="uicontrol">UTF-16</span> — Unicode |
| UTF-16. |
| </li> |
| |
| <li id="asc1229700413480__li_594EED47B43142488A57A1BD66287198"><a name="asc1229700413480__li_594EED47B43142488A57A1BD66287198"><!-- --></a> |
| <span class="uicontrol">UTF-16BE</span> — |
| Unicode UTF-16, big endian. |
| </li> |
| |
| <li id="asc1229700413480__li_7F15048B4F5A4B618B1632A189095655"><a name="asc1229700413480__li_7F15048B4F5A4B618B1632A189095655"><!-- --></a> |
| <span class="uicontrol">UTF-16LE</span> — |
| Unicode UTF-16, little endian.</li> |
| |
| <li id="asc1229700413480__li_659975CE9F14444096BA976BAA0CFA30"><a name="asc1229700413480__li_659975CE9F14444096BA976BAA0CFA30"><!-- --></a> |
| <span class="uicontrol">UTF-8 |
| </span> |
| <span>(default) </span>— Unicode UTF-8. |
| </li> |
| |
| </ul> |
| |
| </td> |
| |
| </tr> |
| |
| </tbody> |
| |
| </table> |
| </div> |
| |
| </div> |
| |
| <div><div class="relconcepts"><strong>Related concepts</strong><br/> |
| <div><a href="../../doc/html/asc1229700490436.html" title="SQL Results view displays the results of executing SQL statements, running procedural routine objects, and creating database objects.">SQL Results View</a></div> |
| </div> |
| <div class="reltasks"><strong>Related tasks</strong><br/> |
| <div><a href="../../doc/html/asc1229700480170.html" title="Use the SQL Results view to see the results of an executed SQL query or routine procedural object.">Viewing SQL Results</a></div> |
| </div> |
| <div class="relref"><strong>Related reference</strong><br/> |
| <div><a href="../../doc/html/asc1229700412058.html" title="The SQL Results view preferences determine the behavior of the SQL Results view.">SQL Results View Options Preferences</a></div> |
| <div><a href="../../doc/html/asc1229700414871.html" title="Set history option preferences for the display of history in the SQL Results view.">History Options Preferences</a></div> |
| <div><a href="../../doc/html/asc1229700416261.html" title="Select the viewer to display SQL results.">Result Set Viewer Preferences</a></div> |
| </div> |
| </div> |
| <div/> |
| </body> |
| </html> |
