CONNX ODBC Connection String Parameters

This table lists the CONNX ODBC connection string parameters that can be used when opening a connection to the CONNX ODBC driver.

 

Connection Parameter Name

Description

Application

Specifies the CONNX application  to use when connecting.  The application can be a database within the CDD  or within an entire collection of databases.

ClientID

This is a user-defined identifier sent from the CONNX Client to the CONNX Server.  It can be used to run custom procedures on the server during a connection.

DBKey

This is an Rdb-only feature. The only valid option is ATTACH.  If DBKEY=ATTACH is specified, then Rdb DBKEYS is not reused throughout the lifetime of a connection.

DBREADONLY

A list of databases in the CDD, separated by commas, which are treated as read only.

DBREADWRITE

A list of databases in the CDD, separate by commas, which are treated as read/write.

DSN

The User or System DSN name to use for connecting. The correct DD, FILEDSN, or DSN must be specified.

DD

A full path to the name of the CONNX Data Dictionary to use for connecting. This can be used as a replacement for DSN or FILEDSN.  This option enables "DSN-less" connections. The correct DD, FILEDSN, or DSN must be specified.

Exclusive

Connect to all databases in "exclusive" mode.

FILEDSN

 

The name of the file data source to use during the connection. The correct DD, FILEDSN, or DSN must be specified.

Node

The name of the server to connect to.  This option is only useful if connecting to a CDD that only has one data source in it.

OEM

Key used for OEM redistributors.

Prompt

Options are "YES" or "NO".  Determines whether CONNX displays a logon dialog if sufficient connection information is not specified.

PWD

The CONNX password.

READONLY

This option connects to all databases in the CDD in read only mode.

RPC

The name of a CONNX RPC to execute right after a connection has been established.

UID

The CONNX UserID.

ADADBIDLIST

Allows dynamic rebinding of adabas DBIDs in the CONNX data dictionary.   This is useful if you have multiple Adabas databases with identical structures, but different data.  At connection time, you can redirect one or more databases in the CDD to different adabas DBIDs.  It is the responsibility of the user to ensure that the structure is the same between the database, otherwise error will occur during query processing.

ADADBIDLIST=(<logicalCDDDatabaseName>:<new DBID>,<logicalCDDDatabaseName>:<new DBID>,…)

Example:             ADADBIDLIST=(adatest:2,adalocal:1)

Where adatest and adalocal are database cylinder names in the CDD.