SQL adaptation guide For Oracle Database 9.2, 10.x, 11.x, 12x / Installation (Runtime Configuration) |
ORACLE version | Shared library environment setting |
---|---|
Oracle 9.2 and higher | UNIX: Add $ORACLE_HOME/lib to LD_LIBRARY_PATH (or its equivalent).Windows: Add %ORACLE_HOME%\bin to PATH. |
$ sqlplus username/password@service
dbi.database.dbname.ifxemul.datatype.serial.emulation = "(native|regtable)"
The value 'native' selects the SEQUENCE based method, and the value 'regtable' selects the SERIALREG based method. This entry has no effect if dbi.database.<dbname>.ifxemul.datatype.serial is set to 'false'.
The default is SERIAL emulation enabled with native method (SEQUENCE-based). See issue SERIAL data types for more details.
dbi.database.dbname.ora.schema = "name"
Here dbname identifies the database name used in the BDL program (DATABASE dbname) and name is the schema name to be used in the ALTER SESSION instruction. If this entry is not defined, no ALTER SESSION instruction is executed and the current schema defaults to the user's name.
dbi.database.dbname.ora.prefetch.rows = integer dbi.database.dbname.ora.prefetch.memory = integer # in bytes
These values will be applied to all application cursors.
The interface pre-fetches rows up to the prefetch.rows limit unless the prefetch.memory limit is reached, in which case the interface returns as many rows as will fit in a buffer of size prefetch.memory. By default, pre-fetching is on and defaults to 10 rows; the memory parameter is set to zero, so the memory size is not included in computing the number of rows to prefetch.
dbi.database.dbname.ora.sid.command = "SELECT ..."
This unique session identifier will be used to create table names for temporary table emulation.
By default, the database driver will use "SELECT USERENV('SESSIONID') FROM DUAL".
dbi.database.dbname.ifxemul.temptables.emulation = "global"
dbi.database.dbname.ora.cursor.scroll.emul = true