DATABASE
Use the DATABASE statement to open the database which will become the default database and the current database.
|
Database Name |
The name of the database |
|
Server |
The name of the host system where database resides |
|
Variable |
A variable that contains the database specification |
The DATABASE statement is required, if your 4GL program references a database at least once. This statement can be used in two ways:
- You can specify the current database during the runtime so that the statements could access the data in the database at runtime.
- You can specify the default database which will be opened automatically when the program is run and which will be used during compilation (it also allows the INITIALIZE and VALIDATE statements to access syscolatt or syscolval).
DATABASE statement should
be used if the application intends to connect to one database at a time.
For setting multiple database connections see the CONNECT
TO statement description.
Unlike
SQL statements, DATABASE
statement can include variables of the STRING
datatype.
Related articles