Home

Getting Started

Utilities

Indexing

Omnidex

Development

Tutorials

Quick Links

 

SQL Reference

Commands

Syntax

Options

Example

 

SQL Reference

Joins

Nested Queries

Set Operations

ON CURSOR | INSTANCE

WITH Options

Commands

Functions

 

DISCONNECT

DISCONNECT from an Omnidex Environment.

Specify the instance number to disconnect from one of multiple connections. If no instance is specified, the current instance is closed.

 

Syntax

DISCONNECT [ALL] [[ON] instance [WITH options]]

DISCONNECT
Required

[ALL]
Optional - Disconnect all connected environments for the current session.

[ON] instance
Optional - Specify which connected environment to disconnect from by passing the instance the connection was opened on.

[WITH options]
Optional - Specify options to be used for this command.

 

Options

FLUSH={[EA][,DA][,IA] } -- flushes the entire cache from memory for any or all of the EnvironmentAccess (EA), DataAccess (DA) or IndexAccess (IA) cache established through oaconnect.

 

Example

Enter DISCONNECT by itself to disconnect from the Omnidex environment open on the current instance.

>DISCONNECT
Disconnected
>

Specify which instance to disconnect the connection from when multiple connections have been opened. Only the connection opened on the specified instance will be closed. All others remain open.

>DISCONNECT ON 2
Disconnected from instance 2
>

Pass the ALL option with the DISCONNECT command to close all open connections on all instances for this OdxSQL session.

>DISCONNECT WITH ALL

Pass the FLUSH option with the DISCONNECT command to flush all resources associated with the current connection.

>DISCONNECT WITH FLUSH

Pass both the FLUSH and ALL options with the DISCONNECT command to close all connections and flush all resources associated with the current OdxSQL session.

>DISCONNECT WITH FLUSH, ALL

 

Top