Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
SQL statementsThis chapter describes the syntax and semantics of SQL statements that are recognized by HCL OneDB™.
CONNECT statementUse the CONNECT statement to connect to a database environment. This statement is an extension to the ANSI/ISO standard for SQL.
Database Environment
Specifying the Database Environment
Only Database Specified

Only Database Specified

The dbname option establishes a connection to the default database server or to another database server in the DBPATH environment variable. It also locates and opens the specified database. (The same is true of the db_var option if this specifies only a database name.)

If you specify only dbname, its database server is read from the DBPATH environment variable. The database server in the INFORMIXSERVER environment variable is always added before the DBPATH value.

On UNIX™, set the INFORMIXSERVER and DBPATH environment variables as the following example (for the C shell) shows:

setenv INFORMIXSERVER srvA
setenv DBPATH //srvB://srvC

On Windows™, choose Start > Programs > HCL OneDB™ > setnet32 from the Task Bar and set the INFORMIXSERVER and DBPATH environment variables:

set INFORMIXSERVER = srvA
set DBPATH = //srvA://srvB://srvC

The next example shows the resulting DBPATH that your application uses:

//srvA://srvB://srvC

The application first establishes a connection to the database server that INFORMIXSERVER specifies. The database server uses parameters in the configuration file to locate the database. If the database does not reside on the default database server, or if the default database server is not online, the application connects to the next database server in DBPATH. In the previous example, that database server would be srvB.