To meet your needs, we constantly work to improve Querix products.
This means that Lycia documentation is developing as well.
In case you have found a certain dissonance between the provided information and the actual behavior of Lycia 3 and/or your applications, please, let us know about this via documentation@querix.com so that we can introduce the necessary changes to our documentation.
Thank you for your attention and cooperation.
CONNECT TO statement allows a program to connect to several databases at a time. The databases can be located on different servers and be of different types. The syntax of this statement is as follows:
|
Element |
Description |
|
Database |
A string expression indentifying the name of the database to connect to |
|
Session |
A string expression indentifying the session name for the connection |
|
Login |
A string expression indentifying the username valid on the database server |
|
Password |
A string expression indentifying the password valid for the username used |
The CONNECT TO statement establishes the connection to a database. A program can have several CONNECT TO statements located within program modules. Unlike the DATABASE statement, this statement cannot appear before the MAIN block. Use the DATABASE statement to specify the compile time database, if you need to compile DEFINE ... LIKE statements. The CONNECT TO statement is only used to specify the runtime database connections.
The current database connection that will be active is the session of the last CONNECT TO statement executed. The current connection can be changed with the help of the SET CONNECTION statement and closed using the DISCONNECT statement.
If you connect to Informix database running on a UNIX platform, the only restriction on establishing multiple connections to the same database environment is that an application can establish only one connection to each local server that uses the shared-memory connection mechanism. To find out whether a local server uses the shared-memory connection mechanism or the local-loopback connection mechanism, examine the $INFORMIXDIR/etc/sqlhosts file.