Set Up the SQLCLRTutorialSPCall Solution - Multi-project Data Name

Guides you through the process of setting up the provided SQLCLRTutorialSPCall Visual Studio solution for use with a data name, including 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 MultiProjDataName under your c:\tutorials\SQLCLR project parent directory.
  2. Copy all files and subdirectories in the %PUBLIC%\Documents\Micro Focus\Enterprise Developer\Samples\Mainframe\SQL\OpenESQL\JCLCallingSP\MultiProjDataName directory, to the c:\tutorials\SQLCLR\MultiProjDataName directory.

Open the SQLCLRTutorialSPCall solution

  1. From the Visual Studio main menu, click File > Open > Project/Solution.
  2. Browse to the c:\tutorials\SQLCLR\MultiProjDataName 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. Click Save Save.

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 Properties from the context menu.
  2. On the Project Settings tab (located on the left sidebar), use the Target platform drop-down list to select the version of SQL Server used on your deployment machine. In this case, this is the version of SQL Server installed on your local machine.
  3. Click Save Save.
  4. In the Solution Explorer, right-click the SQLCLRTutorial.Publish project; then select Publish from the context menu.
  5. On the Publish Database dialog box, click Edit.
  6. In the Server name field, type . (dot) to represent your local server.
  7. In the Select or enter database name field, select SQLCLR_Test from the drop-down list; then click OK.
  8. 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: Call a SQL CLR Stored Procedure Multi-project by Data Name
Next topic: Set Up the JCLSPMDN Enterprise Server Region