Edit C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\odbc\7.0.1\help\userguide\usingproduct.05.10.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>Persisting a Result Set as an XML Data File</title> <link rel="StyleSheet" href="css/usingproduct.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="usingproduct.05.01.html#111037">2 Using The Product</a> : Persisting a Result Set as an XML Data File</div> <hr align="left" /> <blockquote> <div class="head_1"><a name="111037">Persisting a Result Set as an XML Data File</a></div> <div class="Body"><a name="158548">The </a>DataDirect Connect Series <span class="forbody">for</span> <span class="APIbody">ODBC</span> drivers allow you to persist a result set as an XML data file with embedded schema. To implement XML persistence, a client application must do the following:</div> <div class="list_procedure_first_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_procedure_first_inner" style="width: 18pt; white-space: nowrap;"> <span class="Numbers">1 </span> </div> </td> <td width="100%"> <div class="list_procedure_first_inner"><a name="158549">Turn on STATIC cursors. For example:</a></div> </td> </tr> </table> </div> <div class="syntax_embed_first"><a name="158550">SQLSetStmtAttr (hstmt, SQL_ATTR_CURSOR_TYPE, SQL_CURSOR_STATIC, </a>SQL_IS_INTEGER)</div> <div class="Body_Indent"><a name="158551">NOTE: A result set can be persisted as an XML data file only if the result set is </a>generated using STATIC cursors. Otherwise, the following error is returned:</div> <div class="syntax_embed_first"><a name="158552">Driver only supports XML persistence when using driverâ??s static cursors.</a></div> <div class="list_procedure_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_procedure_inner" style="width: 18pt; white-space: nowrap;"> <span class="Numbers">2 </span> </div> </td> <td width="100%"> <div class="list_procedure_inner"><a name="158553">Execute a SQL statement. For example:</a></div> </td> </tr> </table> </div> <div class="syntax_embed_first"><a name="158554">SQLExecDirect (hstmt, "SELECT * FROM GTABLE", SQL_NTS)</a></div> <div class="list_procedure_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_procedure_inner" style="width: 18pt; white-space: nowrap;"> <span class="Numbers">3 </span> </div> </td> <td width="100%"> <div class="list_procedure_inner"><a name="158555">Persist the result set as an XML data file. For example:</a></div> </td> </tr> </table> </div> <div class="syntax_embed_first"><a name="158556">SQLSetStmtAttr (hstmt, SQL_PERSIST_AS_XML, "C:\temp\GTABLE.XML", SQL_NTS)</a></div> <div class="Body_Indent"><a name="158557">NOTE: A statement attribute is available to support XML persistence, </a>SQL_PERSIST_AS_XML. A client application must call SQLSetStmtAttr with this attribute as an argument. See the following table for the definition of valid arguments for SQLSetStmtAttr.</div> <table class="Format_D" 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="158560">Argument</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="158562">Definition</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-right-color: Black; border-top-color: Black; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text" style="color: #000000; font-style: italic; font-variant: normal; font-weight: normal; margin-bottom: 3.0pt; margin-top: 3.0pt; text-transform: none; vertical-align: baseline;"><span class="EquationVariables"><a name="158564">StatementHandle</a></span></div> </td> <td style="border-bottom-color: Black; border-right-color: Black; border-top-color: Black; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="158566">The handle of the statement that contains the result set to </a>persist as XML.</div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-right-color: Black; border-top-color: Black; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text" style="color: #000000; font-style: italic; font-variant: normal; font-weight: normal; margin-bottom: 3.0pt; margin-top: 3.0pt; text-transform: none; vertical-align: baseline;"><span class="EquationVariables"><a name="158568">Attribute</a></span></div> </td> <td style="border-bottom-color: Black; border-right-color: Black; border-top-color: Black; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="158570">SQL_PERSIST_AS_XML. This statement attribute can be </a>found in the file qesqlext.h, which is installed with the driver.</div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-right-color: Black; border-top-color: Black; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text" style="color: #000000; font-style: italic; font-variant: normal; font-weight: normal; margin-bottom: 3.0pt; margin-top: 3.0pt; text-transform: none; vertical-align: baseline;"><span class="EquationVariables"><a name="158572">ValuePtr</a></span></div> </td> <td style="border-bottom-color: Black; border-right-color: Black; border-top-color: Black; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="158574">Pointer to a URL that specifies the full path name of the XML </a>data file to be generated. The directory specified in the path name must exist, and if the specified file name exists, the file will be overwritten.</div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-right-color: Black; border-top-color: Black; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text" style="color: #000000; font-style: italic; font-variant: normal; font-weight: normal; margin-bottom: 3.0pt; margin-top: 3.0pt; text-transform: none; vertical-align: baseline;"><span class="EquationVariables"><a name="158576">StringLength</a></span></div> </td> <td style="border-bottom-color: Black; border-right-color: Black; border-top-color: Black; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="158578">The length of the string pointed to by ValuePtr or SQL_NTS if </a>ValuePtr points to a NULL-terminated string.</div> </td> </tr> </table> <div class="Body"><a name="158580">A client application can choose to persist the data at any time that the statement is in an </a>executed or cursor-positioned state. At any other time, the driver returns the following message:</div> <div class="syntax_first"><a name="158581">Function Sequence Error</a></div> <div class="head_2"><a name="158590">Using the Windows XML Persistence Demo Tool</a></div> <div class="Body"><a name="158591">The </a>32-bit drivers for Windows are shipped with an XML persistence demo tool. This tool is installed in the product installation directory. </div> <div class="Body"><a name="158592">The tool has a graphical user interface and allows you to persist data as an XML data file.</a></div> <div class="hanging_label_head"><a name="158593">To use the Windows XML Persistence Demo tool:</a></div> <div class="list_procedure_first_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_procedure_first_inner" style="width: 18pt; white-space: nowrap;"> <span class="Numbers">1 </span> </div> </td> <td width="100%"> <div class="list_procedure_first_inner"><a name="158594">From the product program group, select </a><span class="Action_bold">XML Persistence Demo</span>. The XMLPersistence dialog box appears.</div> </td> </tr> </table> </div> <div class="picture"><a name="158603"><img class="procedure" src="images/xmlpersist.gif" width="483" height="240" style="display: block; float: none; left: 0.0; top: 0.0;" alt="XML Persistence dialog box" /></a></div> <div class="list_procedure_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_procedure_inner" style="width: 18pt; white-space: nowrap;"> <span class="Numbers">2 </span> </div> </td> <td width="100%"> <div class="list_procedure_inner"><a name="158604">First, you must connect to the database. Click </a><span class="Action_bold">Connect</span>. The Select Data Source dialog box appears.</div> </td> </tr> </table> </div> <div class="picture"><a name="158613"><img class="procedure" src="images/xmlpersist2.gif" width="459" height="401" style="display: block; float: none; left: 0.0; top: 0.0;" alt="Select Data Source dialog box (File Data Source tab)" /></a></div> <div class="list_procedure_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_procedure_inner" style="width: 18pt; white-space: nowrap;"> <span class="Numbers">3 </span> </div> </td> <td width="100%"> <div class="list_procedure_inner"><a name="158614">You must either select an existing data source or create a new one. Take one of the </a>following actions:</div> </td> </tr> </table> </div> <div class="list_bulleted_proc_outer" style="margin-left: 18pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_proc_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_proc_inner"><a name="158615">Select an existing data source and click </a><span class="Action_bold">OK</span>.</div> </td> </tr> </table> </div> <div class="list_bulleted_proc_outer" style="margin-left: 18pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_proc_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_proc_inner"><a name="158616">Create a new file data source by clicking </a><span class="Action_bold">New</span>. The Create New Data Source dialog box appears. Follow the instructions in the dialog box.</div> </td> </tr> </table> </div> <div class="list_bulleted_proc_outer" style="margin-left: 18pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_proc_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_proc_inner"><a name="158617">Create a new machine data source by clicking the </a><span class="Action_bold">Machine Data Source</span> tab and clicking <span class="Action_bold">New</span>. The Create New Data Source dialog box appears. Follow the instructions in the dialog box.</div> </td> </tr> </table> </div> <div class="list_procedure_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_procedure_inner" style="width: 18pt; white-space: nowrap;"> <span class="Numbers">4 </span> </div> </td> <td width="100%"> <div class="list_procedure_inner"><a name="158618">After you have connected to a database, type a SQL Select statement in the Query text </a>box of the XML Persistence dialog box. Then, click <span class="Action_bold">Persist</span>. The Save As dialog box appears.</div> </td> </tr> </table> </div> <div class="list_procedure_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_procedure_inner" style="width: 18pt; white-space: nowrap;"> <span class="Numbers">5 </span> </div> </td> <td width="100%"> <div class="list_procedure_inner"><a name="158619">Specify a name and location for the XML data file that will be created. Then, click </a><span class="Action_bold">OK</span>.</div> </td> </tr> </table> </div> <div class="Body_Indent"><a name="158620">Note that the Status box in the XML Persistence dialog box displays whether the action </a>failed or succeeded.</div> <div class="list_procedure_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_procedure_inner" style="width: 18pt; white-space: nowrap;"> <span class="Numbers">6 </span> </div> </td> <td width="100%"> <div class="list_procedure_inner"><a name="158621">Click </a><span class="Action_bold">Disconnect</span> to disconnect from the database.</div> </td> </tr> </table> </div> <div class="list_procedure_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_procedure_inner" style="width: 18pt; white-space: nowrap;"> <span class="Numbers">7 </span> </div> </td> <td width="100%"> <div class="list_procedure_inner"><a name="158622">Click </a><span class="Action_bold">Close</span> to exit the tool.</div> </td> </tr> </table> </div> <div class="head_2"><a name="158631">Using the UNIX/Linux XML Persistence Demo Tool</a></div> <div class="Body"><a name="158632">On UNIX and Linux, the drivers are shipped with an XML persistence demo tool named </a>demoodbc. This tool is installed in the installation directory, in the /samples/demo subdirectory. For information about how to use this tool, refer to the demoodbc.txt file installed in the demo subdirectory.</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