Database concepts

Most BDL applications use only one database instance (in the meaning of Informix^®). But Informix servers can handle multiple database instances, while Genero db servers manage only one database instance. However, Genero db can manage multiple schemas.

SELECT * FROM stores.customer

Solution

With Genero db, you can create as many users as database schemas are needed. You typically dedicate a database user to administer each occurrence of the application database (i.e. schema in Genero db).

Any user can select the current database schema with the following SQL command:

SET SCHEMA "schema"

Using this instruction, any user can access the tables without giving the owner prefix, as long as the table owner has granted the privileges required to access the tables.

Genero db users can be associated to a default schema as follows:

CREATE USER "username" IDENTIFIED ... DEFAULT SCHEMA "schema"

This is the preferred way to assign a schema to DB users.

You can also make the database interface select the current schema automatically using the following FGLPROFILE entry:

dbi.database.dbname.ads.schema = "schema"

Note: double-quoted schema/user names are case-sensitive.