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.
database.cfg file is created empty during Lycia installation.
Its structure when a database configuring should be as follows:
dbname {
driver = "dbtype"
source = "database"
username = "user"
password = "pwd"
}
The options listed above should have the following values:
database_alias = the alias that will be used in 4GL code as the database name, for example, in the DATABASE statement or in the CONNECT TO statement;
driver = its values should be of the database type. This parameter is optional, if it is not set the value of the LYCIA_DB_DRIVER variable will be taken as the driver. It can be one of the following: informix, oracle, odbc, sserver or db2;
source = its values should be the name of the database as it is specified on the database server. For Informix it can be database@server specification, for Oracle it should be tnsname. For the format of the database name see Source section in the 'Database Connectivity' chapter. This parameter is optional, if it is not set for the given database connection, the database alias is treated as the source;
username = should contain the login of the user. This parameter is optional;
password = should contain the access password for the given user login. Note, that the password is stored as a plain text. This parameter is optional. For the security reasons use the USING clause of the CONNECT TO statement instead.
A single database.cfg file may contain several database specifications without no limits for their number. Here is an example of this file containing two database specifications:
or_db {
driver = "oracle"
source = "stores"
username = "john"
password = "123456"
}
ifx_db {
driver = "informix"
source = "stores@ixserv"
username = "jane"
password = "567890"
}