This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
dev:sql:statements:disconnect:home [2010/05/11 00:30] tdo created |
dev:sql:statements:disconnect:home [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| {{page>:top_add&nofooter&noeditbtn}} | {{page>:top_add&nofooter&noeditbtn}} | ||
| <html><div align="center"><span style="color:red">DRAFT</span></div></html> | <html><div align="center"><span style="color:red">DRAFT</span></div></html> | ||
| + | ====== Omnidex SQL: DISCONNECT ===== | ||
| + | {{page>:sql_bar&nofooter&noeditbtn}} | ||
| - | ====== Omnidex SQL: DISCONNECT ====== | ||
| ===== Description ===== | ===== Description ===== | ||
| Disconnect from an Omnidex Environment. | Disconnect from an Omnidex Environment. | ||
| - | |||
| ===== Syntax ===== | ===== Syntax ===== | ||
| + | <code> | ||
| + | DISCONNECT [ALL] [[ON [INSTANCE]] instance] [WITH options] | ||
| + | </code> | ||
| + | disconnect all with flush; | ||
| - | DISCONNECT [ALL] [[ON [INSTANCE]] instance] [WITH options] | + | A DISCONNECT with the ALL modifier causes all instances to be closed. The with FLUSH option instructs the caches to flush any aged entries. This pair of options causes all entries in the caches to be released and freed. |
| + | |||
| - | |||
| ===== Discussion ===== | ===== Discussion ===== | ||