Installing Functions for Db2

Important: You must install these functions within the database housing your datastores before you can use dbfhview to create the database views.
  1. Do one of the following:
    • For Windows: copy DbfhFuncsDB2.dll, located in the etc\mfdbfh\dbfhfuncs\x86 (32-bit), or etc\mfdbfh\dbfhfuncs\x64 (64-bit) sub-folder of the installation folder, into the \function sub-folder of the PostgreSQL database server's installation folder.
    • For UNIX, copy DbfhFuncsDB2.so, located in the etc/mfdbfh/dbfhfuncs/x86 (32-bit), or etc/mfdbfh/dbfhfuncs/x64 (64-bit) sub-folder of the installation folder, into the /function sub-folder of the PostgreSQL database server's installation folder.
  2. Within Enterprise Developer, create the functions script:
    dbfhadmin -script -provider:db2 -type:datastore_funcs -name:<datastore_name>

    By default, the command creates a script file named create_datastore_funcs_<datastore_name>_db2.sql

  3. Using db2 command, run the created script file.

    The external functions are installed in the database.