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:

• Scalar SQL functions that emulate mainframe DB2 SQL; required when you use DIALECT=MAINFRAME
• Metadata tables and SQL functions that emulate mainframe DB2 packages and plans; required when you use the DBRMLIB directive and the DSN BIND utility

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.