Home

Getting Started

Utilities

Indexing

Omnidex

Development

Tutorials

Quick Links

 

SQL Reference

Commands

Syntax

Options

Example

 

SQL Reference

Joins

Nested Queries

Set Operations

ON CURSOR | INSTANCE

WITH Options

Commands

Functions

 

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