DISC

Contents | What's New | Quick Links

 

SQL Commands

Introduction

Software Installation

Concepts and Design

Designing Applications

Omnidex Environments

SQL Reference

Omnidex API's

Utilities

Interfaces

Performance Guide

Troubleshooting Guide

Appendix

 

 

DISCONNECT

 

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

 

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

ODXSQL Example

CONNECT

SQL Reference

Commands

Functions

 

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 applied to this disconnect.

top

 

OdxSQL 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

Dynamic Information Systems Corporation - Omnidex Version 3.8 Build 6 J15.03-Copyright © 2003

DISC | Documentation Home