Omnidex SQL: CONNECT

CONNECT establishes a connection to an Omnidex Environment. Before any Omnidex operations can be performed on an Omindex enhanced data store, a connection must be established.

- Connects with ODBC and JDBC

CONNECT [TO] filename 
        [ON host[:port]] 
        [AS [user]/[password]]
        [USING api] 
        [WITH options]

Specifies the Omnidex Environment.

Optional - Specify username and password if required by the application.

Options specific to the CONNECT 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

connect myenv