Edit C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\odbc\7.0.1\help\reference\flatfile.13.6.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>Delete Statement</title> <link rel="StyleSheet" href="css/flatfile.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="flatfile.13.1.html#106986">11 SQL Statements for Flat-File Drivers</a> : Delete Statement</div> <hr align="left" /> <blockquote> <div class="head_1"><a name="106986">Delete Statement</a></div> <div class="Body"><a name="106987">The Delete statement is used to delete rows from a database table. The form of the Delete </a>statement supported for flat-file drivers is:</div> <div class="syntax_first"><a name="106988">DELETE FROM </a><span class="EquationVariables">table_name</span> </div> <div class="syntax"><a name="106989">[ WHERE { </a><span class="EquationVariables">conditions</span> | CURRENT OF <span class="EquationVariables">cursor_name</span> } ]</div> <div class="Body"><span class="EquationVariables"><a name="106990">table_name</a></span> can be a simple table name or a full path name. A table name is preferred for portability to other SQL data sources.</div> <div class="Body"><a name="106991">The Where clause determines which rows are to be deleted. If you include only the keyword </a>Where, all rows in the table are deleted, but the file is left intact.</div> <div class="Body"><a name="106992">The Where Current Of </a><span class="EquationVariables">cursor_name</span> clause can be used only by developers coding directly to the ODBC API. It causes the row at which <span class="EquationVariables">cursor_name</span> is positioned to be deleted. This is called a "positioned delete." You must first execute a Select...For Update statement with a named cursor and fetch the row to be deleted.</div> <div class="Body"><a name="106993">An example of a Delete statement on the emp table is:</a></div> <div class="syntax_first"><a name="106994">DELETE FROM emp WHERE emp_id = 'E10001'</a></div> <div class="Body"><a name="106995">Each Delete statement removes every record that meets the conditions in the Where </a>clause. In this case, every record having the employee ID E10001 is deleted. Because employee IDs are unique in the employee table, at most, one record is deleted.</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