Tutorial: Configure an Enterprise Server Region

Requirements

Before attempting this tutorial, you must complete Tutorial: Import 32-bit JCL Enterprise Server Regions.

Configure an Imported Region

1. If not showing in an Enterprise Developer window, start Enterprise Server Administration.
2. On the Enterprise Server Administration Home page, click the Edit button that corresponds to the enterprise server region used in the tutorial you plan to follow:

   Tutorial	Region Name
   Call a SQL CLR Stored Procedure Single-project by Literal	JCLSPSL
   Call a SQL CLR Stored Procedure Single-project by Data Name	JCLSPSDN
   Call a SQL CLR Stored Procedure Multi-project by Literal	JCLSPML
   Call a SQL CLR Stored Procedure Multi-project by Data Name	JCLSPMDN

   By default, this takes you to the Server > Properties > General page.

3. In the Configuration Information field, ensure that it includes an [ES-Environment] entry with JCLPROJ set to the fully expanded path to the SPCall project directory. By default, this is C:\Users\Public\Documents\Micro Focus\Enterprise Developer\Samples\Mainframe\SQL\OpenESQL\JCLCallingSP\projLocDir\SQLCLRTutorial\SPCall.

   Where projLocDir is one of the following project location directory names:

   Tutorial	Project Location Directory
   Call a SQL CLR Stored Procedure Single-project by Literal	SingleProjLiteral
   Call a SQL CLR Stored Procedure Single-project by Data Name	SingleProjDataName
   Call a SQL CLR Stored Procedure Multi-project by Literal	MultiProjLiteral
   Call a SQL CLR Stored Procedure Multi-project by Data Name	MultiProjDataName

   For example:

   [ES-Environment]
   JCLPROJ=C:\Users\Public\Documents\Micro Focus\Enterprise Developer\Samples\Mainframe\SQL\hcoss\JCLCallingSP\SPDDemo\SPCall

   If your SPCall project directory is in a different location, edit the path to point to it.
4. Click Apply.
5. Click the XA Resources tab.
6. Click the Edit button that corresponds to the CALLSP XA resource name.
7. Ensure that the Module field is set to the fully expanded path to the ESODBCXA.dll file, which by default is C:\Program Files (x86)\Micro Focus\Enterprise Developer\src\enterpriseserver\xa\ESODBCXA.dll.
8. If you are using SQL Server authentication for your ODBC connection, append the USRPASS parameter to the open string so that it reads as follows:

   DSN=SQLCLRTutorial, USRPASS=userid.password

   Where userid.password is the user ID and password used to log onto SQL Server.

   If you are using Windows authentication, skip this step.

9. Click OK to save the changes.