Centralized Run-Time Knowledge Base for the ODBC Extension

Note: This topic applies to the ODBC Extension only.

Because Data Express extension technology requires that the Run-Time Knowledge Base contains tables and indexes created using the DEKB schema, the DEKB schema must be in the source data store. If this requirement compromises production integrity when using the ODBC Extension, use a centralized Run-Time Knowledge Base.

To configure a centralized Run-Time Knowledge Base, you must create a new configuration file named hkblayer.ini and store it in the executables directory of the ODBC Extension installation (see Extension Technology Directories for more information). This configuration file defines the connection information required to access a centralized Run-Time Knowledge Base.

Include the following content in the hkblayer.ini file:

RDBMS = ODBC
DBNAME = ConnectionAlias
DBOWNER = TableOwner
USER = UserID
PSWD = Password

ConnectionAlias: The data store containing the Run-Time Knowledge Base tables. For the ODBC Extension, this is the data source name (DSN).
TableOwner: The table qualifier for the Run-Time Knowledge Base tables.
UserID and Password: The connection credentials required by the data store containing the Run-Time Knowledge Base tables.

For example:

RDBMS = ODBC
DBNAME = MYDSN
DBOWNER = MYOWNER
USER = MYUSER
PSWD = MYPASSWORD

After creating the hkblayer.ini file, start a command prompt and change to the executables directory that contains it. Enter the following command to generate the HKBLAYER.rc file required to access the centralized Run-Time Knowledge Base:

dxeencrypt hkblayer