>SET CURSORDISPLAY ON
>connect /users/garment.env
Connected to /users/garment.env on instance 2,
cursor 2
SELECT COMPANY, CONTACT, PHONE FROM CUSTOMERS
WHERE STATE='CO' ON CURSOR 2
The ON CURSOR n clause is optional. If it is not specified,
the SQL statement will be executed on the current cursor defined
in the cursor parameter of the status array.
The ON INSTANCE n clause can only be used by statements that
do not require a cursor to be open. This includes statements
like INSERT, INSERTINDEX, and many more. See the individual
statement definitions for information on whether the statement
uses an instance or a cursor. If omitted, the SQL statement
will be executed on the instance owning the cursor passed
in the cursor parameter of oaexecsql or in the instance member
of the status array.
Each
individual JDBC Statement object and ODBC CLI HSTMT objects
are created on their own cursors. Likewise, each Connection
object in both types of applications are created on their
own instances. Therefore, the use of the ON CURSOR and ON
INSTANCE clauses is unnecessary. To switch between multiple
cursors or instances, simply reference the appropriate object.
Syntax
statement [ON [CURSOR] n | [INSTANCE] n] [WITH
options]
statement
Required. Any valid SQL statement supported by Omnidex.
ON
Required if specifying the cursor or instance number. Omit
if using the default current cursor or instance.
[CURSOR | INSTANCE]
Optional. The CURSOR and INSTANCE keywords are optional.
n
Required if specifying the cursor or instance number. Omit
if using the default current cursor or instance. This is the
cursor or instance number that the current command will be
executed on. Cursors and instances are numbered automatically
as they are created. In OdxSQL, use the CURSORDISPLAY ON set
option to automatically display the current cursor and instance
numbers.
[WITH options]
Optional. A comma separated list of options to use for the
current statement.
top
ODXSQL Example
>SET CURSORDISPLAY ON
>connect /users/garment.env
Connected to /users/garment.env on instance 1,
cursor 1
>connect / users/orders.env
Connected to /users/orders.env on instance 2,
cursor 2
SELECT COMPANY, CONTACT, PHONE FROM CUSTOMERS
WHERE STATE='CO' ON CURSOR 2
...
INSERT INTO CUSTOMERS (COMPANY, CONTACT) VALUES
('New Wave', 'Mr. Smith') ON CURSOR 1
...
top
|