To generate a SQL CLR stored procedure

  1. In Visual COBOL, open a SQL Server Database Project solution that contains a SQL CLR stored procedure.
  2. From the Solution Explorer, open the project properties for the COBOL project.
  3. On the SQL tab, set the DBMAN directive to ADO.
  4. Ensure that the BEHAVIOR compiler directive option is set to MAINFRAME for optimized performance.
  5. Open the project properties for the .Publish project.
  6. On the Project Settings tab, set the Target Platform to the version of Microsoft SQL Server that you are using.
  7. On the Debug tab, click the Edit button associated with the Target Connection String.
  8. In the Server Name field, type . (dot) to indicate a local SQL Server instance, type the name of a SQL Server instance, or select an instance from the drop-down list.
  9. In the Select or enter a database name field, type the name of a SQL Server database, or select one from the drop-down list.
  10. Click OK to save the new connection string.
  11. Save the solution.
  12. Right-click the .Publish project in your solution, and select Publish.
  13. On the Publish Database dialog box, click Edit.
  14. In the Server Name field, type . (dot) to indicate a local SQL Server instance, type the name of a SQL Server instance, or select an instance from the drop-down list.
  15. In the Select or enter database name field, type the name of a SQL Server database, or select one from the drop-down list; then click OK.
  16. On the Publish Database dialog box, click Publish. When the publishing process is complete, the Data Tools Operations window shows a status of Publish Completed Successfully.
Note: If you make changes at a later date, you can update the project using the Add SP to SQLCLR option from the context menu in the OpenESQL Assistant.