Syntax
CONNECT [[TO] filename [AS [user] / [password]]
[WITH options]]
CONNECT
Required
[TO] filename
Optional - Specify the environment file to connect to. "filename"
is the environment filespec.
[AS [user]/[password]]
Optional - Specify username and password if required by the
application.
[WITH options]
Optional - Specify options to be applied to this connection.
top
OdxSQL Example
In OdxSQL, CONNECT establishes a connection to an Omnidex
Environment Catalog and opens a cursor.
Enter CONNECT followed by the environment catalog file spec
and any desired parameters at the prompt.
>connect orders.env
Connected to C:\Omnidex\Demodata\orders.env
>
Or, type CONNECT and press return to be prompted for each
parameter.
>connect
Environment file: /disctest/oracle/orders.env
User: guest
Password:
Options:
Enter / to exit the series of prompts at any time.
Specify a username and password in the AS [ user]/[ password]
clause.
Specify connect options in the WITH clause.
The NOCURSOR option, will cause a connection to be established
without opening a cursor.
top
Options
read
write
exclusive
ia
da
oa
envaccess
eapreload
eacache
iacache
dacache
iafiles
dbdirect
dbinstal
dbuser
dbaccess
maxfopens
maxmemory
cache
singledbconnect
userlocking
preprocessor
interrupts
clocks
autopseudocolumns
setcwd
top
|