HCO for SQL Server (Known Issues)

HCOSS SQL Server databases created with an Enterprise Developer version of 2.2 Update 2 HotFix 3 or earlier might be missing HCOSS-provided scalar functions. To ensure your scalar functions are up to date, run the InstallDigitsFunction.sql script against each of your HCOSS databases. The script is located by default in the %ALLUSERSPROFILE%\Micro Focus\Enterprise Developer\hcoss directory. The user running the script must have read, update, and create permissions for the database SYSIBM and dbo schemas.
Starting with Enterprise Server 2.2 Update 1, HCOSS is not backwardly compatible with HCOSS databases created in earlier versions, and that also fit the following description:
- Use a 64-bit Enterprise Server
- SQL Server stored procedures called from an ODBC application
- Use DBRMLIB
To restore compatibility, use Enterprise Developer to recompile just the programs that call stored procedures. This resolves run-time system error messages and greatly improves the performance of the calls to stored procedures.

For example, if you have a 64-bit HCOSS application that uses SQL compiler directive options DBMAN=ODBC and DBRMLIB, recompile programs that call stored procedures from COBOL or PL/I code.