This is an old revision of the document!


DRAFT

Omnidex SQL: CONNECT

Description

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.

Note that when using the Omnidex ODBC and Omnidex JDBC driver, connections are established using ODBC and JDBC calls.

The Omnidex CONNECT Statement is primarily used within OdxSQL.

Syntax

CONNECT [TO] [ [host:port] ]environment_filespec[ [node_name] ]
        [ON host[:port]] 
        [AS [user]/[password]]
        [USING < ODBC | JDBC | CLOA > ] 
        [WITH options]

Discussion

[TO] [ [host:port] ]Environment_filespec

Specifies the Omnidex XML Environment containing the Omnidex metadata.

connect odx.xml;

ON host:port

Specifies that the Environment Catalog is located on a remote server and the Omnidex Network Services (OdxNet) will be used for access.

[AS [user]/[password]]

Used to specify a username and password if required by the underlying relational database.

connect odxoracle.xml as orauser/pass;

USING api

Used to specify the either the ODBC or JDBC api to use for access. This is primarily used to test ODBC and JDBC access using OdxSQL.

[WITH options]

Options specific to the CONNECT command.

MAINTENANCE - Accesses the Omnidex Environment exclusively to facilitate changes.

connect to odx.xml with maintenance;
 
Back to top
dev/sql/statements/connect/home.1278048017.txt.gz ยท Last modified: 2016/06/28 22:38 (external edit)