Installing CONNX Embedded SQL for Adabas - z/OS
To install CONNX Embedded SQL for Adabas:
1. Start Adabas SQL Gateway Embedded SQL Setup (located in Start menu > All Programs > CONXX Driver) on a Windows computer that has the CONNX Server Installation component installed.
The Adabas SQL Gateway Embedded SQL Setup is also ran when you select Adabas SQL Gateway or the Adabas Mainframe Server Components, and the Adabas SQL Gateway Embedded SQL option during installation.
2. On the z/OS tab, fill in the server's Login Information in the respected fields.
Fill in the server's TCP/IP symbolic host name or dotted numeric address, a privileged user account name, and a user account password (for example, MVS1, CONNX, and Password). The password appears as *******.
Important:
All fields in the Login Information section are required.
3. Under Code Page, enter the code page the zOS system is using.
4. See Required and Optional Fields for a detailed explanation on what information to input in the rest of the fields and which fields are optional.
5. Click the Install button. This action starts an FTP session and copies the selected CONNX components from the client PC to the target host. Copying alert and FTP windows are displayed.
6. Once the FTP successfully completes, you are ready to install the selected Adabas SQL Gateway Embedded components on the host. Log on to TSO on the target system. Under ISPF, navigate to the data set identified by the DSN HLQ parameter ( Required and Optional Fields). Verify that the following data sets exist:

Dataset | Purpose
CNTL | Location of the installation JCL and Utility procedure JCL
OBJ | Location of Adabas SQL Gateway Embedded SQL object files
SAMP | Location of utility JCL for running the CNTL procedures and for compiling the C and COBOL sample files (Available only if Samples were selected for installation)

The SAMP data set contains the following utility JCLs:

Member | Purpose
CMEMPCC | Sample JCL to compile, link, and run the C example. This JCL is specific to SAS/C.
CMEMPCOB | Sample JCL to compile, link and run the COBOL example.
PCCCSMP | Sample C source with embedded SQL.
PCCOBSMP | Sample COBOL source with embedded SQL.
RNACECC | Sample JCL to run the C/C++ pre-compiler.
RNACECOB | Sample JCL to run the COBOL pre-compiler.
RNACEINT | Sample JCL to run ACEINT with dynamic SQL commands.

7. Browse the CNTL data set and verify that the following members exist:

Member | Purpose
INST | Installation script
ACEINT | JCL Procedure for executing the ACEINT utility
PCACECC | JCL Procedure for executing the C/C++ Precompiler
PCACECOB | JCL Procedure for executing the COBOL Precompiler

8. Edit the job card for the INST member and submit. The installation is a success if all the return codes are 4 or less.