Requirements
Before attempting this tutorial, you must complete
Tutorial: Import a 32-bit JCL Enterprise Server Region.
Configure the JCLSP Imported Region
- If not showing in an
Enterprise Developer window, start
Enterprise Server Administration.
- 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.
- 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.
- Click
Apply.
- Click the
XA Resources tab.
- Click the
Edit button that corresponds to the
CALLSP XA resource name.
- 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.
- 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.
- Click
OK to save the changes.