Set Up the SQLCLRTutorialSPCall Solution - Call from SPD File

Guides you through the process of setting up the provided SQLCLRTutorialSPCall Visual Studio solution, enabling it to call a SQL CLR stored procedure from an SPD file. The instructions include setting SPCall project properties, building the solution, and publishing the stored procedures.

Copy the SQLCLRTutorialSPCall solution

  1. Using Windows File Explorer or at a command prompt, create a subdirectory named SPDDemo under your c:\tutorials\HCOSS project parent directory.
  2. Copy all files and subdirectories in the %PUBLIC%\Documents\Micro Focus\Enterprise Developer\Samples\Mainframe\SQL\hcoss\JCLCallingSP\SPDDemo directory, to the c:\tutorials\HCOSS\SPDDemo directory.

Open the SQLCLRTutorialSPCall solution

  1. In Enterprise Developer, click File > Open > Project/Solution.
  2. Browse to the c:\tutorials\HCOSS\SPDDemo directory.
  3. Double-click SQLCLRTutorialSPCall.sln.

Set Project Properties

  1. In the Solution Explorer, right-click the SPCall project; then select Properties from the context menu.
  2. On the Debug tab (located on the left sidebar), using the drop-down list, set Launch to JCL.
  3. In the Solution Explorer, double-click the Properties entry under the SQLCLRTutorial.Publish project.
  4. On the Project Settings tab (located on the left sidebar), using the drop-down list, set Target platform to your version of SQL Server.
  5. Click Save All Save All.

Build the Solution

  • In the Solution Explorer, right-click the solution; then select Build Solution from the context menu.

Publish SQL CLR Stored Procedures

  1. In the Solution Explorer, right-click the SQLCLRTutorial.Publish project; then select Publish from the context menu.
  2. On the Publish Database dialog box, click Edit.
  3. In the Server name field, type . (dot) to represent your local server.
  4. In the Select or enter database name field, select SQLCLR_Test from the drop-down list; then click OK.
  5. 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."

Parent topic: Tutorial: SQL CLR Stored Procedures - Call a Stored Procedure Defined in an SPD File
Next topic: Set Up the JCLSP Enterprise Server Region