ONEDB_SERVER environment variable

The ONEDB_SERVER environment variable specifies the default database server to which an explicit or implicit connection is made by an SQL API client, the DB-Access utility, or other HCL OneDB™ products.

This environment variable must be set before you can use HCL OneDB client products. It has the following syntax.

1  setenv ONEDB_SERVER dbservername
dbservername
is the name of the default database server.

The value of ONEDB_SERVER can be a local or remote server, but must correspond to a valid dbservername entry in the $ONEDB_HOME/etc/sqlhosts file on the computer running the application. The dbservername must begin with a lower-case letter and cannot exceed 128 bytes. It can include any printable characters except uppercase characters, field delimiters (blank space or tab), the newline character, and the hyphen (or minus) symbol.

For example, this command specifies the coral database server as the default: 
setenv ONEDB_SERVER coral
ONEDB_SERVER specifies the database server to which an application connects if the CONNECT DEFAULT statement is executed. It also defines the database server to which an initial implicit connection is established if the first statement in an application is not a CONNECT statement.
Important: You must set ONEDB_SERVER even if the application or DB-Access does not use implicit or explicit default connections.