CONNECT
CONNECT establishes a connection to an Omnidex Environment Catalog.
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 used for this command.
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
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
|