SQL identifiers syntax

Database object naming conventions are different for each database engine.

The table below describes the naming conventions for database objects (tables, sequences, stored procedures):

Table 1. Database server naming conventions for database objects
Database Server Type Naming Syntax
IBM® DB2® LUW
[[database.]owner.]identifier
IBM Informix®
[database[@dbservername]:][owner.]identifier
Microsoft™ SQL Server
[[[server.][database].][owner].]identifier
Oracle® MySQL / MariadDB
[database.]identifier
Oracle Database Server
[schema.]identifier[@database-link]
PostgreSQL
[[database.]schema.]identifier
SAP HANA®
[[database.]schema.]identifier
SQLite
[database.]identifier

As a general rule, use simple unqualified database object names and use database vendor specific configuration setting or SQL instruction to point to the expected schema.

When possible, Genero provides FGLPROFILE entries to define the database schema to be selected after connecting to the database server, with:
dbi.database.dbname.drivercode.schema = "schema-name"

For more details, see Database type specific parameters in FGLPROFILE.