Application Database Support

HCOSS database migration tools transfer customer data from mainframe DB2 databases to SQL Server databases.

HCOSS also provides SQL Server functions and metadata tables that enable SQL Server databases to emulate DB2 mainframe behavior and facilities. This additional SQL Server support consists of:

You can add HCOSS DB2 emulation support to a new or an existing SQL Database using either of these methods, depending on whether or not you use the DBRMLIB HCOSS SQL compiler directive option:

When using DBRMLIB
All additional SQL Server support is added to your database at BIND time. If your HCOSS installation has been updated by a new release of Enterprise Developer, or by a Hot Fix installation, new versions or additional functions are updated automatically at the first BIND after the new installation. For more information, see Binding Applications
When not using DBRMLIB
Run the following scripts manually from SQL Server Management Studio. We recommend that you run all three scripts on a new database even if you do not plan to use the DBRMLIB support. The user running these scripts must have read, update, and create permissions to the SYSIBM and dbo schemas in the database.

By default, these scripts are installed in the %ALLUSERSPROFILE%\Micro Focus\Enterprise Developer\hcoss directory:

  • InstallDigitsFunction.sql - adds DB2 SQL emulation functions
  • InstallSYSIBM.sql - installs HCOSS metadata tables
  • InstallBindProcs.sql - installs the functions required to maintain HCOSS metadata tables
Note: After you have run these scripts once, subsequent release or HotFix installations require that you run just the InstallDigitsFunction.sql script unless the readme that accompanies the new installation specifies otherwise.