OdxDisconnectEnv

OdxDisconnectEnv disconnects the connection to the Omnidex Environment Catalog.

Syntax

OdxDisconnectEnv @instance[, @options]

@instance integer input
The instance number that was assigned when the connection was established.

@options varchar input
List of options to be passed to CLoadisconnect. Optional.

Options

See OADISCONNECT for more options.

Example

This example checks to see if the passed cursor is open and closes it if it is. It then checkes to see if the passed instance number is connected and closes it if it is.

CREATE PROCEDURE prODXDisconnect
@cursor_num int,
@instance_num int
AS
declare @status int
exec @status = master.dbo.odx_is_opened @cursor_num
if @status <> 0
exec @status = master.dbo.odx_close_cursor @cursor_num

exec @status = master.dbo.odx_is_connected @instance_num
if @status <> 0
exec @status = master.dbo.odx_disconnect_env @instance_num
GO

Top