To generate a COBOL wrapper for a SQL CLR stored procedure

Note: This task is required only when you have manually added a stored procedure definition (SPD) file to SQL Server Database project. Otherwise, if you create an SPD file directly from the project, Visual COBOL generates the COBOL wrapper program automatically when you save the completed SPD file.
  1. In Visual Studio, open a SQL Server Database project that contains a SQL CLR stored procedure and Stored Procedure Definition (.spd) file, or add an existing SPD file to a SQL Server Database project that contains a SQL CLR stored procedure.
  2. Right-click the SPD file, and select Properties.
  3. In the Custom Tool field, type SPDFileCodeGenerator.
  4. Save the project and close the Properties window.
  5. From the Solution Explorer, right-click the stored procedures definition file, and select Run Custom Tool. This generates the COBOL wrapper code, adding it to the project as the file SPDName.mssp.cbl.