Edit C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\odbc\7.0.1\help\userguide\xml.24.09.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>Using Hints for Tabular-Formatted XML Documents</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#107151">19 The XML Driver</a> : Using Hints for Tabular-Formatted XML Documents</div> <hr align="left" /> <blockquote> <div class="head_1"><a name="107151">Using Hints for Tabular-Formatted XML Documents</a></div> <div class="Body"><a name="107154">The XML driver supports table and row hints. You can specify a table hint, a row hint, or </a>both, when configuring an XML data source or using a connection string.</div> <div class="Body"><a name="107156">Table hints should be specified so that they resolve to a single node. If a table hint resolves </a>to a set of nodes, the first node in the set is used as the table node. The context of the table hint is always the root node of the XML document. </div> <div class="Body"><a name="107158">Row hints define the "row" element and specify whether the rowset is element-based or </a>attribute-based. If a table hint is supplied, the context of the row node is the node to which the table hint resolves; otherwise, the context is the root node of the XML document. The column mode identifier specifies whether the columns of a row are child nodes or attributes of the row node.</div> <div class="Body"><a name="107159">When working with hints, keep in mind that the XML driver assumes that the row nodes are </a>the immediate children of the table node.</div> <div class="list_bulleted_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner"><a name="107160">If only a table hint is specified, the row nodes are the children of the node to which the </a>hint resolves. It is assumed that all of the child nodes have the same name. </div> </td> </tr> </table> </div> <div class="list_bulleted_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner"><a name="107161">If only a row hint is specified, the table node is the parent of the node to which the hint </a>resolves. If the row hint resolves to a set of nodes, the nodes in that set must all have the same parent. </div> </td> </tr> </table> </div> <div class="list_bulleted_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner"><a name="107162">If both a table hint and a row hint are specified, the row hint is taken to be relative to the </a>node to which the table hint resolves. </div> </td> </tr> </table> </div> <div class="Body"><a name="107163">The column mode identifier has the format:</a></div> <div class="syntax_first"><a name="107164">\</a>column <span class="EquationVariables">mode</span></div> <div class="Body"><a name="107165">where </a><span class="EquationVariables">mode</span> can be one of the following options:</div> <div class="list_bulleted_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner"><a name="107166">child: The columns are child nodes of the row node.</a></div> </td> </tr> </table> </div> <div class="list_bulleted_single_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_single_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_single_inner"><a name="107167">attr: The columns are attributes of the row node.</a></div> </td> </tr> </table> </div> <div class="Body"><a name="107168">In the following examples, the columns are the children of the row nodes.</a></div> <div class="head_3"><a name="107169">Example 1</a></div> <div class="Body"><a name="107170">Table Hint:</a></div> <div class="Body"><a name="107171">Row Hint: //Item</a></div> <div class="Body"><a name="107172">The row nodes are the nodes named Item. The table node is the parent of the row nodes. </a>Use this form only when all of the Item nodes reside under one parent. </div> <div class="Body"><a name="107173">If some Item nodes have different parents, use a table hint or a more specific row hint to </a>select the set of Item nodes.</div> <div class="head_3"><a name="107174">Example 2</a></div> <div class="Body"><a name="107175">Table Hint:</a></div> <div class="Body"><a name="107176">Row Hint: /Bookstore/Books/Item</a></div> <div class="Body"><a name="107177">The row nodes are the nodes named Item. The table node is Books, which is a child of the </a>Bookstore node.</div> <div class="head_3"><a name="107178">Example 3</a></div> <div class="Body"><a name="107179">Table Hint: /Bookstore/Books</a></div> <div class="Body"><a name="107180">Row Hint:</a></div> <div class="Body"><a name="107181">The table node is Books, which is a child of the Bookstore node. The row nodes are the </a>children of the Books node. It is assumed that all of the child nodes under the Books nodes have the same name. If the child nodes do not all have the same name, the name of the first child node encountered is used as the row node name. In that case, it would be better to specify both a table and row hint.</div> <div class="head_3"><a name="107182">Example 4</a></div> <div class="Body"><a name="107183">Table Hint: /Bookstore [@location = "Raleigh"]/Books</a></div> <div class="Body"><a name="107184">Row Hint: ./Item</a></div> <div class="Body"><a name="107185">The table node is Books, which is a child of the Bookstore node. Bookstore has a "location" </a>attribute with the value Raleigh. The row nodes are the Item nodes that are children of the Books node. </div> <div class="head_2_no_TOC"><a name="107186">Column Mode Identifier</a></div> <div class="Body"><a name="107187">The following examples illustrate the use of the optional column mode identifier.</a></div> <div class="head_3"><a name="107188">Example 5</a></div> <div class="Body"><a name="107189">Table Hint:</a></div> <div class="Body"><a name="107190">Row Hint: //Item \column attr </a></div> <div class="Body"><a name="107191">The row nodes are named Item. The table node is the parent of the row nodes. The </a>columns are attributes of the row node.</div> <div class="head_3"><a name="107192">Example 6</a></div> <div class="Body"><a name="107193">Table Hint:</a></div> <div class="Body"><a name="107194">Row Hint: //Item \column child </a></div> <div class="Body"><a name="107195">The row nodes are the nodes named Item. The table node is the parent of the row nodes. </a>The columns are attributes of the row node.</div> <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