SET Options

INSTANCE

SET INSTANCE n

The INSTANCE set option defines the "current" instance in OdxSQL. This is the instance contained in the instance element of the status array and is the instance that will be used by default if no instance is specified in commands that support an ON INSTANCE n clause.

Each time a connection is made in OdxSQL, an "instance" is established. Use the INSTANCE set option to switch between the different instances. Use the CURSORDISPLAY set option to display the instance and cursor numbers as they are changed.

The current cursor becomes undefined when the instance is set with the INSTANCE set option, because each instance can have multiple cursors. However, the current instance is automatically set when the cursor is set using the CURSOR set option, because each cursor is associated with a single instance.

Example

The current cursor must also be set when the current instance is set in this manner.

C:\omnidex\Demodata>odxsql orders.env
Connected to C:\omnidex\Demodata\orders.env

> set cursordisplay on

> connect star.env
Connected to C:\omnidex\Demodata\star.env on instance 2, cursor 2

>set instance 1
Current instance is now 1, however the current cursor is undefined.

>set cursor 1
Current instance is now 1, and current cursor is now 1

top