Deploying Native Applications

Deploy from a Non-development Machine

If you use HCOSS with SQL CLR stored procedures and you want to deploy to the SQL Server database from a machine other than your development machine, you must install HCOSS on that machine, and then copy your most recent mfhcocds.txt file to the %ALLUSERSPROFILE%\Micro Focus\Enterprise Developer directory on the same machine.

Deploy an Application Compiled Without DBRMLIB

To deploy an Enterprise Developer HCOSS application that was not compiled using the DBRMLIB directive, meaning that you did not bind the DBRM files for your application, complete the steps presented in the topic Deploying COBOL Applications. The steps presented there are necessary to successfully deploy your application to the deployment machine.

Development Machine

• Build and test the HCOSS application with a development SQL Server machine.

Deployment Machine

• Follow the steps defined in Deploying COBOL Applications, moving your HCOSS application as specified
• Create a connection to the deployment SQL Server machine
• Test the HCOSS application with the deployment SQL Server machine

Deploy an Application Compiled With DBRMLIB

To bind an Enterprise Developer HCOSS application using the DBRMLIB directive and deploy it to a deployment machine, you have two choices:

Bind the application from your development machine

Development Machine

• Build and test the HCOSS application with a development SQL Server machine
• Create a connection to the deployment SQL Server machine
• Bind the HCOSS application to the deployment SQL Server machine using the connection you created

Deployment Machine

• Follow the steps defined in Deploying COBOL Applications, moving your HCOSS application as specified

• Create a connection to the deployment SQL Server machine
• Test the HCOSS application with the deployment SQL Server machine

Bind the application from your deployment machine

Development Machine

• Build and test the HCOSS application with a development SQL Server machine.

Deployment Machine

1. Follow the steps defined in Deploying COBOL Applications.
2. Be sure that all prerequisite software is installed on the machine. See Additional Software Requirements for details.
3. Copy your HCOSS application from the development machine to the appropriate directory structure on the deployment machine.
   Important: You must create some or all of the required directory structure manually.

   Specifically, copy database request modules (DBRMs), that is, the DBRMName.hcodbrm files, from the development machine to the equivalent directory on the deployment machine. The location of your DBRM files varies on your development machine depending on your HCOSS options, and the specified DBRMLIB directive. The location on your development machine is:

   localHCOSSFiles\DBRMDataSets\DBRMLIBName

   Where localHCOSSFiles represents the value of the Local HCOSS Directory HCOSS option, and DBRMLIBName represents the value of the DBRMLIB directive.

   Note: If no value is provided for the DBRMLIB directive, the default value is DBRMLIB. SQL(DBRMLIB) is the equivalent of SQL(DBRMLIB=DBRMLIB).

   On the deployment machine, you must put the DBRM files into a subdirectory of the default directory: %LOCALAPPDATA%\Micro Focus\Enterprise Developer\hcoss\DBRMDataSets. The subdirectory name must match the DBRMLIB name.

   For example, assuming the following:

   Development machine Windows user ID	devuser
   Deployment machine Windows user ID	exeuser
   DBRMLIB directive	SQL(DBRMLIB=REX.PROJECT.DEMO)
   Value of Local HCOSS Directory HCOSS option on both machines	Default setting, %LOCALAPPDATA%\Micro Focus\Enterprise Developer\hcoss\DBRMDataSets

   You then copy the generated DBRM files using the following directory specifications:

   Development Machine	Deployment Machine
   c:\Users\devuser\AppData\Local\Micro Focus\Enterprise Developer\hcoss\DBRMDataSets\REX.PROJECT.DEMO	c:\Users\exeuser\AppData\Local\Micro Focus\Enterprise Developer\hcoss\DBRMDataSets\REX.PROJECT.DEMO

4. Start HCO for SQL Server from Start > All Programs > Micro Focus Enterprise Developer > Data Tools > HCO for SQL Server > HCO for SQL Server.
5. Using the Manage Connections tool, create a connection to the deployment SQL Server machine. For more information, see the Manage Connections Tool topic.
   Important: Be sure that the login credentials you use grant you the permissions necessary to successfully perform the tasks outlined in both the Schema Update Execution and Bind Script Execution sections of the DSN Bind Utility topic.
6. Using the Manage Packages and Plans tool, bind the DBRM to your deployment SQL Server machine by creating and executing a BIND PACKAGE script command. For complete details, see the Manage Packages and Plans topic.
7. Test your HCOSS application on the deployment SQL Server machine.
   Note: When running from the command line, if your Enterprise Developer installation directory contains spaces, do not enclose the directory specification in quotes when you add it to the PATH environment variable.

Deploy an Application with Customized SQL Error Codes

Copy the mfhcocds.txt file on your development machine, located in the %ALLUSERSPROFILE%\Micro Focus\Enterprise Developer directory by default, to the same directory on your deployment machine.

Deploy an Application with Customized SQL Name Mappings

Copy the DialectMappings.hcomap file on your development machine, located in the %ALLUSERSPROFILE%\Micro Focus\Enterprise Developer\hcoss directory by default, to the same directory on your deployment machine.