For Production Reporting for Sybase, Oracle, Informix, DB2, and Teradata, ensure that you have the proper database client software installed on the same machine as Production Reporting. Production Reporting for ODBC and DDO does not require additional libraries.
If you have your own user-defined functions, if a new version of the database libraries becomes available, or to apply OS-level patches, then you must relink the product as described in this section. The Production Reporting script uses standard environment variables for each database to identify the location of the libraries.
You must re-create the executables if the version of the operating system or database client software is different than when the original executables were created. Find the versions by using the following command line flag:
-id
To re-create the executables, enter the following commands from a shell:
cd EPM_ORACLE_HOME/products/biplus/bin/SQR/Server/db_name/lib ./sqrmake
where db_name is the name of one of the following database names: Oracle, Informix, DB2, Sybase, ODBC, DDO, or Teradata.
HYPERION_HOME and SQRDIR are required to re-create the executables. Set SQRDIR to EPM_ORACLE_HOME/products/biplus/bin/SQR/Server/db_name/bin.