Edit C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\odbc\7.0.1\help\userguide\xml.24.04.html
<?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 xml:lang="en" lang="en" xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html;charset=utf-8" /> <meta http-equiv="Content-Style-Type" content="text/css" /> <!-- MOTW-DISABLED saved from url=(0014)about:internet --> <title>Hierarchical-Formatted XML Document Support</title> <link rel="StyleSheet" href="css/xml.css" type="text/css" media="all" /> <link rel="StyleSheet" href="css/webworks.css" type="text/css" media="all" /> <script type="text/javascript" language="JavaScript1.2" src="wwhdata/common/context.js"></script> <script type="text/javascript" language="JavaScript1.2" src="wwhdata/common/towwhdir.js"></script> <script type="text/javascript" language="JavaScript1.2" src="wwhdata/common/wwhpagef.js"></script> <script type="text/javascript" language="JavaScript1.2"> <!-- var WebWorksRootPath = ""; // --> </script> <script type="text/javascript" language="JavaScript1.2"> <!-- // Set reference to top level help frame // var WWHFrame = WWHGetWWHFrame("", true); // --> </script> <script type="text/javascript" language="JavaScript1.2" src="scripts/expand.js"></script> </head> <body class="" style="background-color: #FFFFEE;" onload="WWHUpdate();" onunload="WWHUnload();" onkeydown="WWHHandleKeyDown((document.all||document.getElementById||document.layers)?event:null);" onkeypress="WWHHandleKeyPress((document.all||document.getElementById||document.layers)?event:null);" onkeyup="WWHHandleKeyUp((document.all||document.getElementById||document.layers)?event:null);"> <br /> <div class="WebWorks_Breadcrumbs" style="text-align: left;"> <a class="WebWorks_Breadcrumb_Link" href="xml.24.01.html#106350">19 The XML Driver</a> : Hierarchical-Formatted XML Document Support</div> <hr align="left" /> <blockquote> <div class="head_1"><a name="106350">Hierarchical-Formatted XML Document Support</a></div> <div class="Body"><a name="106353">The XML driver can be configured so that it supports hierarchical-formatted documents. In </a>this case, the driver assumes that the document that it is accessing can contain more than one table. The driver scans the document to locate all tables; the available tables are visible through a SQLTables operation. Then, the driver does a second scan to gather each tableā??s column information and to determine a data type for each column.</div> <div class="Body"><a name="106354">The following is an example of a hierarchical document:</a></div> <div class="syntax_first"><a name="106355"><?xml version="1.0"?></a></div> <div class="syntax"><a name="106356"> </a> <purchaseOrder orderDate="1999-10-20"></div> <div class="syntax"><a name="106357"> </a> <shipTo country="US"></div> <div class="syntax"><a name="106358"> </a> <name>Alice Smith</name></div> <div class="syntax"><a name="106359"> </a> <street>123 Maple Street</street></div> <div class="syntax"><a name="106360"> </a> <city>Mill Valley</city></div> <div class="syntax"><a name="106361"> </a> <state>CA</state></div> <div class="syntax"><a name="106362"> </a> <zip>90952</zip></div> <div class="syntax"><a name="106363"> </a> </shipTo></div> <div class="syntax"><a name="106364"> </a> <billTo country="US"></div> <div class="syntax"><a name="106365"> </a> <name>Robert Smith</name></div> <div class="syntax"><a name="106366"> </a> <street>8 Oak Avenue</street></div> <div class="syntax"><a name="106367"> </a> <city>Old Town</city></div> <div class="syntax"><a name="106368"> </a> <state>PA</state></div> <div class="syntax"><a name="106369"> </a> <zip>95819</zip></div> <div class="syntax"><a name="106370"> </a> </billTo></div> <div class="syntax"><a name="106371"> </a> <comment>Hurry, my lawn is going wild!</comment></div> <div class="syntax"><a name="106372"> </a> <items></div> <div class="syntax"><a name="106373"> </a> <item partNum="872-AA"></div> <div class="syntax"><a name="106374"> </a> <productName>Lawnmower</productName></div> <div class="syntax"><a name="106375"> </a> <quantity>1</quantity></div> <div class="syntax"><a name="106376"> </a> <USPrice>148.95</USPrice></div> <div class="syntax"><a name="106377"> </a> <comment>Confirm this is electric</comment></div> <div class="syntax"><a name="106378"> </a> </item></div> <div class="syntax"><a name="106379"> </a> <item partNum="926-AA"></div> <div class="syntax"><a name="106380"> </a> <productName>Baby Monitor</productName></div> <div class="syntax"><a name="106381"> </a> <quantity>1</quantity></div> <div class="syntax"><a name="106382"> </a> <USPrice>39.98</USPrice></div> <div class="syntax"><a name="106383"> </a> <shipDate>1999-05-21</shipDate></div> <div class="syntax"><a name="106384"> </a> </item></div> <div class="syntax"><a name="106385"> </a> </items></div> <div class="syntax"><a name="106386"> </a> </purchaseOrder></div> <div class="Body"><a name="106387">First, the XML driver returns two tables: "purchaseOrder" and "items." Two tables are </a>returned because two items are found for a single purchase order. The XML driver found commonality of child elements.</div> <div class="Body"><a name="106388">Second, the XML driver determines which columns are in a specific table. An </a><span class="Syntax">_ID</span> column, which is essentially a primary key, is automatically generated for each table. If a table is determined to be a child of another table, then it is given a second generated column. The name of this column is prefixed with the parent tableā??s name and ends with <span class="Syntax">_ID</span>, for example, <span class="Syntax">_purchaseOrder_ID</span>. </div> <div class="Body"><a name="106389">Consider the previous example document. The items table will receive two generated </a>columns, <span class="Syntax">_ID</span> and _<span class="Syntax">purchaseOrder_ID</span>, which are assigned an integer data type. The purchaseOrder table receives only the <span class="Syntax">_ID </span>column, because it does not have a parent table.</div> <div class="Body"><a name="106391">The tables returned from the example file include the following columns:</a></div> <table class="Format_B" cellspacing="0" summary=""> <caption></caption> <tr style="vertical-align: top;"> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_column_heads"><a name="106394">Table</a></div> </td> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;" colspan="2"> <div class="table_column_heads" style="text-align: Center;"><a name="106396">Columns</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="106400">items</a></div> </td> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="106402">_ID</a></div> <div class="table_text"><a name="106403">_purchaseOrder_ID</a></div> <div class="table_text"><a name="106404">partNum</a></div> <div class="table_text"><a name="106405">productName</a></div> <div class="table_text"><a name="106406"> </a></div> </td> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="106408">quantity</a></div> <div class="table_text"><a name="106409">USPrice</a></div> <div class="table_text"><a name="106410">comment</a></div> <div class="table_text"><a name="106411">shipDate</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="106413">purchaseOrder</a></div> </td> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="106415">_ID</a></div> <div class="table_text"><a name="106416">orderDate</a></div> <div class="table_text"><a name="106417">shipTo_country</a></div> <div class="table_text"><a name="106418">shipTo_name</a></div> <div class="table_text"><a name="106419">shipTo_street</a></div> <div class="table_text"><a name="106420">shipTo_city</a></div> <div class="table_text"><a name="106421">shipTo_state</a></div> <div class="table_text"><a name="106422">shipTo_zip</a></div> </td> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="106424">billTo_country</a></div> <div class="table_text"><a name="106425">billTo_name</a></div> <div class="table_text"><a name="106426">billTo_street</a></div> <div class="table_text"><a name="106427">billTo_city</a></div> <div class="table_text"><a name="106428">billTo_state</a></div> <div class="table_text"><a name="106429">billTo_zip</a></div> <div class="table_text"><a name="106430">comment</a></div> </td> </tr> </table> <div class="head_2_no_TOC"><a name="106432">Column Data Types</a></div> <div class="Body"><a name="106433">The XML driver determines the column data types by inspecting the column values. The </a>data type determination limits its data types to a subset of the DataDirect Format data types, as listed in the following table. For a complete list of DataDirect Format data types, see <a href="javascript:WWHClickedPopup('ODBC', 'xml.24.10.html#165685', '');">Table 19-6</a>.</div> <table class="Format_B" cellspacing="0" summary=""> <caption></caption> <tr style="vertical-align: top;"> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_column_heads"><a name="106439">Data Type</a></div> </td> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_column_heads"><a name="106441">Sample Values</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="106443">wvchar</a></div> </td> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="106445">"Foo", "best320"</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="106447">varbinary</a></div> </td> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="106449">"27AB2F9C"</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="106451">int</a></div> </td> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="106453">"34","-7000"</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="106455">unsignedint</a></div> </td> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="106457">"0", "123456789"</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="106459">long</a></div> </td> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="106461">"-12345678012345"</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="106463">unsignedlong</a></div> </td> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="106465">"123456789012345"</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="106467">boolean</a></div> </td> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="106469">"true", "false"</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="106471">date</a></div> </td> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="106473">1963-12-19</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="106475">time</a></div> </td> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="106477">10:09:58</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="106479">timeinstant</a></div> </td> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="106481">1963-12-19T10:09:58</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="106483">decimal</a></div> </td> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="106485">1245.678</a></div> </td> </tr> </table> <script type="text/javascript" language="JavaScript1.2"> <!-- // Clear related topics // WWHClearRelatedTopics(); document.writeln(WWHRelatedTopicsInlineHTML()); // --> </script> </blockquote> <script type="text/javascript" language="JavaScript1.2"> <!-- document.write(WWHRelatedTopicsDivTag() + WWHPopupDivTag() + WWHALinksDivTag()); // --> </script> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de