Edit C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\odbc\7.0.1\help\reference\bulk.11.5.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>DataDirect Bulk Load Statement Attributes</title> <link rel="StyleSheet" href="css/bulk.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="bulk.11.1.html#125567">9 DataDirect Bulk Load</a> : DataDirect Bulk Load Statement Attributes</div> <hr align="left" /> <blockquote> <div class="head_1"><a name="125567">DataDirect Bulk Load Statement Attributes</a></div> <div class="Body"><a name="114474">In addition to exporting tables with the ExportTableToFile methods, result sets can be </a>exported to a bulk load data file through the use of two DataDirect statement attributes, SQL_BULK_EXPORT_PARAMS and SQL_BULK_EXPORT. SQL_BULK_EXPORT_PARAMS is used to configure information about where and how the data is to be exported. SQL_BULK_EXPORT begins the bulk export operation.</div> <div class="head_2"><a name="123970">SQL_BULK_EXPORT_PARAMS</a></div> <div class="Body"><a name="124004">The ValuePtr argument to SQLSetStmtAttr or SQLSetStmtAttrW when the attribute </a>argument is SQL_BULK_EXPORT_PARAMS is a pointer to a BulkExportParams structure. The definitions of the fields in the BulkExportParams structure are the same as the corresponding arguments in the <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('reference', 'bulk.11.4.html#137628', '');">ExportTableToFile and ExportTableToFileW</a></span> methods except that the generation of the log file is controlled by the EnableLogging field. When EnableLogging is set to 1, the driver writes events that occur during the export to a log file. Events logged to this file are:</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="124033">A message for each row that failed to export.</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="124034">Total number of rows fetched</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="124035">Total number of rows successfully exported</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="124036">Total number of rows that failed to export</a></div> </td> </tr> </table> </div> <div class="Body"><a name="124030">The log file is located in the same directory as the bulk load data file and has the same base </a>name as the bulk load data file with a .log extension. When EnableLogging is set to 0, no logging takes place</div> <div class="Body"><a name="124061">If the bulk export parameters are not set prior to setting the SQL_BULK_EXPORT attribute, </a>the driver uses the current driver code page value, defaults EnableLogging to 1 (enabled), and defaults ErrorTolerance and WarningTolerance to -1 (infinite).</div> <div class="Body"><a name="124052">The SQL_BULK_EXPORT_PARAMS structure is as follows:</a></div> <div class="syntax_first"><a name="123995">struct BulkExportParams {</a></div> <div class="syntax"><a name="123996"> </a> SQLLEN Version; /* Must be the value 1 */</div> <div class="syntax"><a name="123997"> </a> SQLLEN IANAAppCodePage;</div> <div class="syntax"><a name="123998"> </a> SQLLEN EnableLogging;</div> <div class="syntax"><a name="123999"> </a> SQLLEN ErrorTolerance;</div> <div class="syntax"><a name="124000"> </a> SQLLEN WarningTolerance;</div> <div class="syntax"><a name="124016">};</a></div> <div class="head_2"><a name="124021">SQL_BULK_EXPORT</a></div> <div class="Body"><a name="124017">The ValuePtr argument to SQLSetStmtAttr or SQLSetStmtAttrW when the attribute </a>argument is SQL_BULK_EXPORT is a pointer to a string that specifies the file name of the bulk load data file to which the data in the result set will be exported.</div> <div class="Body"><a name="114476">Result set export occurs when the SQL_BULK_EXPORT statement attribute is set. If using </a>the SQL_BULK_EXPORT_PARAMS attribute to set values for the bulk export parameters, the SQL_BULK_EXPORT_PARAMS attribute must be set prior to setting the SQL_BULK_EXPORT attribute. Once set, the bulk export parameters remain set for the life of the statement. If the bulk export parameters are not set prior to setting the SQL_BULK_EXPORT attribute, the driver uses the current driver code page value, defaults EnableLogging to 1 (enabled), and defaults ErrorTolerance and WarningTolerance to -1 (infinite)</div> <div class="Body"><a name="114600">Both a bulk load data file and a bulk load configuration file are produced by this operation. </a>The configuration file has the same base name as the bulk load data file, but with an XML extension. The configuration file is created in the same directory as the bulk load data file.</div> <div class="Body"><a name="146581"> </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