Set Up the SQLCLRTutorialSPGroupCall Solution - Call from SPD File using Group Variables

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

Copy the SQLCLRTutorialSPGroupCall solution

  1. Using Windows File Explorer or at a command prompt, create a subdirectory named SPDGroupDemo 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\SPDGroupDemo directory, to the C:\tutorials\HCOSS\SPDGroupDemo directory.

Open the SQLCLRTutorialSPGroupCall Solution

  1. In Enterprise Developer, click File > Open > Project/Solution.
  2. Browse to the c:\tutorials\HCOSS\SPDGroupDemo directory.
  3. Double-click SQLCLRTutorialSPGroupCall.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."