IBM DB2 specific FGLPROFILE parameters
dbi.database.dsname.db2.schema
Name of the database schema to be selected after connection is established.
dbi.database.stores.db2.schema = "store2"
Set this parameter to a specific schema in order to share the same table with all users.
Deferred prepare: Use db2cli.ini DeferredPrepare
Before version 3.20 of Genero BDL, it was possible to control the deferred prepare option with
the dbi.database.dbname.db2.prepare.deferred
FGLPROFILE
parameter. Starting with 3.20, this FGLPROFILE parameter is desupported/ignored, and deferred
prepare is the default.
If
PREPARE/DECLARE
instructions must raise an SQL error in case of invalid SQL,
DB2 CLI deferred prepare (SQL_ATTR_DEFERRED_PREPARE) can be disabled with the following
db2cli.ini parameter:DeferredPrepare = 0