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,
Enterprise Developer generates the COBOL wrapper program automatically when you save the completed SPD file.
Similarly, if you generate an SPD file using the HCOSS Generate SPD File Tool, HCOSS automatically adds the completed SPD
file and its generated COBOL wrapper program to the open solution in
Enterprise Developer.
- 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.
- Right-click the SPD file, and select
Properties.
- In the
Custom Tool field, type
SPDFileCodeGenerator.
- Save the project and close the
Properties window.
- 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.