Edit C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\odbc\7.0.1\help\userguide\xml.24.06.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>Specifying Table Names in SQL Statements</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#106509">19 The XML Driver</a> : Specifying Table Names in SQL Statements</div> <hr align="left" /> <blockquote> <div class="head_1"><a name="106509">Specifying Table Names in SQL Statements</a></div> <div class="Body"><a name="106511">When defining locations, you specify a name for the location along with a directory, or path </a>and file name. For example, suppose you define two locations for a data source, a Folder location and an XML Document location. The Folder location is on a local filing system and the XML Document location is on a web server with a URL prefix of http://www.acme.com/xmldata. </div> <div class="Body"><a name="106512">For example:</a></div> <div class="Body"><a name="106513">The Folder location: </a><br />c:\xmldata\xmlsample as LOC1</div> <div class="Body"><a name="106514">The XML Document location: http://www.acme.com/xmldata/doc.xml as LOC2</a></div> <div class="Body"><a name="106515">For complete information about how to configure locations in an XML data source, see </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'xml.24.07.html#106561', '');">â??Configuring and Connecting to Data Sourcesâ??</a></span>.</div> <div class="Body"><a name="106519">If you are connected to this data source and the data source had the "Show Manufactured </a>Schemas" option set as the Schema Mode (see the Schema Mode option under <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'xml.24.07.html#106561', '');">â??Configuring and Connecting to Data Sourcesâ??</a></span>) and then you performed an unqualified SQLTables operation, you would get the following results.</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="106525">Schema name</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="106527">Table name</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="106529">LOC1#</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="106531">FILE1</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="106533">LOC1#</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="106535">FILE2</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="106537">LOC2#</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="106539">TABLE1</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="106541">LOC2#</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="106543">TABLE2</a></div> </td> </tr> </table> <div class="Body"><a name="106545">Location names are fabricated into the schema name by adding a # symbol to the end of the </a>location name.</div> <div class="Body"><a name="106546">NOTE: If you had the "Show Virtual Schemas" option set, the above table would have </a>"XML" listed in the Schema name column.</div> <div class="Body"><a name="106547">To fully qualify a table name in a SQL statement, you could use the following:</a></div> <div class="Body"><a name="106548">LOC1#.FILE1</a><br />or<br />XML.FILE1</div> <div class="Body"><a name="106549">LOC2#.TABLE2</a><br />or<br />XML.TABLE2 </div> <div class="Body"><a name="106550">This design gives you a simpler table name qualifier. This is an important advantage given </a>the complexity of URL names, and the requirement to double quote them in SQL statements. For example, the following query uses a fully qualified table name for an XML Document location:</div> <div class="syntax_first"><a name="106551">SELECT * FROM "http://www.acme.com/xmldata/doc.xml#TABLE2" WHERE productName=</a>â??lawnmowerâ?? </div> <div class="Body"><a name="106552">Compare that to the same query using a location name:</a></div> <div class="syntax_first"><a name="106553">SELECT * FROM LOC2#.TABLE2 WHERE productName=â??lawnmowerâ?? </a></div> <div class="Body"><a name="106554">Another example demonstrating the Folder location is as follows:</a></div> <div class="syntax_first"><a name="106555">SELECT * FROM "c:\xmldata\xmlsample\FILE1.XML" WHERE productName=â??lawnmowerâ?? </a></div> <div class="Body"><a name="106556">Compare that to the same query using a location name:</a></div> <div class="syntax_first"><a name="106557">SELECT * FROM LOC1#.FILE1 WHERE productName=â??lawnmowerâ?? </a></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