Tutorial: Configure the JCLSP Enterprise Server Region

Requirements

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

Configure the JCLSP 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 JCLSP enterprise server region.

    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\hcoss\JCLCallingSP\SPDDemo\SPCall.

    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.