...
Code Block |
---|
dbname { //dbname = alias that will be used in 4GL code as the database name driver = "dbtype" //driver = parameter which represents the database type (optional) source = "database" //source = name of the database as it is specified on the database server (optional) username = "user" //username = user's login (optional) password = "pwd" //password = user's password (optional) } |
CONNECT TO
This statement allows a program to connect to several databases at a time which can be located on different servers and be of different types. It can be used to specify only the runtime database connections. The syntaxis of this statement is as follows:
...
Step 2 - Add the database connection details to the database.cfg file.
Step 3 - Use the DATABASE statement in an application to connect to a single database and use the CONNECT TO statement to connect to several databases simultaneously.
...