Edit C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\odbc\7.0.1\help\reference\sqlsupport.12.02.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>Alter Cache (EXT)</title> <link rel="StyleSheet" href="css/sqlsupport.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="sqlsupport.12.01.html#116567">10 SQL Statements and Extensions for the Salesforce Driver</a> : Alter Cache (EXT)</div> <hr align="left" /> <blockquote> <div class="head_1"><a name="116567">Alter Cache (EXT)</a></div> <div class="Body"><a name="138570">The Alter Cache statement changes the definition of a cache on a remote table or view. An </a>error is returned if the remote table or view specified does not exist.</div> <div class="gutter_text_right"><a name="138572">Grammar</a></div> <div class="syntax_first"><a name="138573">ALTER CACHE ON {</a><span class="EquationVariables">remote_table</span> | <span class="EquationVariables">view</span>}</div> <div class="syntax"><a name="138574"> [REFERENCING (</a><span class="EquationVariables">remote_table_ref</span>[,<span class="EquationVariables">remote_table_ref</span>]...)]</div> <div class="syntax"><a name="138575"> [REFRESH_INTERVAL {0 | -1 | </a><span class="EquationVariables">interval_value</span> [{M, H, D}]}]</div> <div class="syntax"><a name="138576"> [INITIAL_CHECK [ONFIRSTCONNECT | FIRSTUSE | DEFAULT}]</a></div> <div class="syntax"><a name="138577"> [PERSIST {TEMPORARY | MEMORY | DISK | DEFAULT}]</a></div> <div class="syntax"><a name="138578"> [ENABLED {YES | TRUE | NO | FALSE}]</a></div> <div class="syntax"><a name="138579"> [CALL_LIMIT {0 | -1 | </a><span class="EquationVariables">max_calls</span><span class="Syntax">}</span>]</div> <div class="syntax"><a name="138580"> [FILTER (</a><span class="EquationVariables">expression</span>)]</div> <div class="Body"><a name="138581">where:</a></div> <div class="Body"><span class="EquationVariables"><a name="165787">remote_table</a></span> is the name of the remote table cache definition to be modified. The remote table name can be a two-part name: <span class="EquationVariables">schemaname.tablename</span>. When specifying a two-part name, the specified remote table must be defined in the specified schema, and you must have the privilege to alter objects in the specified schema. When altering a relational cache, <span class="EquationVariables">remote_table</span> must specify the primary table of the relational cache.</div> <div class="Body"><span class="EquationVariables"><a name="165788">view</a></span> is the name of the view cache definition to be modified. The view name can be a two-part name: <span class="EquationVariables">schemaname.viewname</span>. When specifying a two-part name, the specified view must be defined in the specified schema, and you must have the privilege to alter objects in the specified schema. Caches on views are not currently supported in the product.</div> <div class="Body"><span class="Syntax"><a name="138803">REFERENCING</a></span> is an optional clause that specifies the name of the remote table(s) for which a relationship cache is to be created. See <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('reference', 'sqlsupport.12.02.html#138585', '');">â??Relational Cachesâ??</a></span> and <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('reference', 'sqlsupport.12.08.html#172873', '');">â??Referencing Clauseâ??</a></span> for a complete explanation.</div> <div class="Body"><span class="Syntax"><a name="138869">REFRESH_INTERVAL</a></span> is an optional clause that specifies the length of time the data in the cached table can be used before being refreshed. See <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('reference', 'sqlsupport.12.08.html#172886', '');">â??Refresh Interval Clauseâ??</a></span> for a complete explanation.</div> <div class="Body"><span class="Syntax"><a name="139080">INITIAL_CHECK</a></span> is an optional clause that specifies when the driver initially checks whether the data in the cache needs refreshed. See <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('reference', 'sqlsupport.12.08.html#172898', '');">â??Initial Check Clauseâ??</a></span> for a complete explanation.</div> <div class="Body"><span class="Syntax"><a name="139921">PERSIST</a></span> is an optional clause that specifies the life span of the data in the cached table or view. See <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('reference', 'sqlsupport.12.08.html#172907', '');">â??Persist Clauseâ??</a></span> for a complete explanation.</div> <div class="Body"><span class="Syntax"><a name="139922">ENABLED</a></span> is an optional clause that specifies whether the cache is enabled or disabled for use with SQL statements. See <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('reference', 'sqlsupport.12.08.html#172931', '');">â??Enabled Clauseâ??</a></span> for a complete explanation.</div> <div class="Body"><span class="Syntax"><a name="139932">CALL_LIMIT</a></span> is an optional clause that specifies the maximum number of Web service calls that can be used to populate or refresh the cache. See <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('reference', 'sqlsupport.12.08.html#172945', '');">â??Call Limit Clauseâ??</a></span> for a complete explanation.</div> <div class="Body"><span class="Syntax"><a name="139956">FILTER</a></span> is an optional clause that specifies a filter for the primary table to limit the number of rows that are cached in the primary table. See <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('reference', 'sqlsupport.12.08.html#172960', '');">â??Filter Clauseâ??</a></span> for a complete explanation.</div> <div class="Body"><a name="138584">NOTE: At least one of the optional clauses must be used. If two or more are specified, they </a>must be specified in the order shown in the grammar description.</div> <div class="head_2_no_TOC"><a name="138585">Relational Caches</a></div> <div class="Body"><a name="173966">If the Referencing clause is specified, the Alter Cache statement drops the existing cache </a>and any referenced caches and creates a new set of related caches, one for each of the tables specified in the statement. The cache attributes for the existing cache are the default cache attributes for the new relational cache. Any attributes specified in the Alter Cache statement override the default attributes. If the Referencing clause is not specified, the existing cache references, if any, are used. </div> <div class="Body"><a name="138586">If the cache being altered is a relational cache, the attributes specified in the Alter Cache </a>statement apply to all of the caches that comprise the relational cache.</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