Provides instructions that walk you through the process of creating the HCO_Test SQL Server database from a provided SQL script.
Both HCOSS Application Migration tutorials require that you have access to the HCO_Test SQL Server database that contains data
migrated from an IBMSYS schema in a DB2 database. To make this easy for you, we have provided a script that creates and populates
the database for you.
- Using UNIX terminal, navigate to the
$COBDIR/demo/sql/hcoss directory.
This directory contains the
CreateAndLoadHCO_Test.sql SQL script used to create the test database.
- Execute the following command to create the database:
> sqlcmd -S ServerName -U UserId -P Password -I CreateAndLoadHCO_Test.sql.
- Execute the following three HCOSS scripts against the newly created HCO_Test database:
- InstallSYSIBM.sql
- InstallBindProcs.sql
- InstallDigitsFunction.sql
Note: For more information about these scripts, see
Before Using HCO for SQL Server.