Creating the CONNX Library in an Adabas-Managed Space
The Adabas SQL Gateway provides an automated installation client application that transfers the CONNX server components to the target VSE host via TCP/IP FTP. To succeed, the automated FTP step requires a target VSE library defined in VSAM-managed space. The target library must be defined manually, either via the following CONNX-supplied template and FTP, or by using the VSE resource-definition panels. To use the CONNX installation template, follow the following steps:
1. The CONNX VSE installation template is copied to the CONNX VSE installation directory on the client machine. The default name is C:\connx32\adabas\templates\ftp\vse\cnxlibv_.dat
2. Make the following substitutions for the template variables defined in the following table:

Variable | Definition
[CNXLIB] | The 1-7 character Adabas SQL Gateway library name defined in the [CNXLIBP] CONNX library cluster; the default is CNXVVRR.
[CNXLIBP] | The 1-44 character fully-qualified VSE cluster name which contains the CONNX Adabas SQL Gateway library; the default is CONNX..LIBRARY.
[CNXCATL] | The 1-7 character VSE standard label which references the physical data set name of the Adabas SQL Gateway user or system catalog ([CNXCATP] ).
[CNXCATP] | The 1-to-44 character physical data set name of the VSE Adabas SQL Gateway user catalog into which the Adabas SQL Gateway-managed library [CNXLIBP] is defined. If left blank, the CONNX library is defined in the default VSE system catalog.
[SAMPLEVOLSER] | The 1-6 character DASD volume serial number on which the VSE Adabas SQL Gateway-managed library is installed: no default.

3. Visually inspect the JCL and move each line continuation character (a rightmost capital X preceded by a comma and one or more blanks ) to column 72; truncate all data beyond column 72.
The control records for the standard label delete and add job steps are column-sensitive.
4. Delete the column rule lines in the template and save the cnxlibv_.dat file as a new file.
5. Via the Windows command prompt, start an ftp session to the target VSE host. Change directory to the VSE POWER Reader queue and submit the cnxlibv0.jcl job:
>ftp
>open 123.456.788.812
>user user
>password password
>cd POWER\RDR\A
>put cnxlibv0.jcl
6. This job should execute in less than a minute. Within the same ftp session, retrieve the output JCL from the POWER List Queue:
>cd "..\..\LST\A"
>dir
7. Retrieve the job output by issuing the following command:
>get CNXLIB.00037.00
For a first-time run, the return codes from the first step // EXEC LIBR,PARM='MSHP' is 8, which is expected.
For a first-time run, the return code from the IDCAMS statement is 8, which is expected. All subsequent return codes should be 0 or 4.
8. The VSE volume and Adabas SQL Gateway user catalog physical data set and data label names are substituted into template variables.
9. Make the CONNX for Adabas SQL Gateway - VSE library available for FTP access.
10. Depending on the TCP/IP security rules of the target VSE system, the newly allocated CONNX library may not be immediately available for ftp read/write access. The Adabas SQL Gateway library can be manually defined to the VSE TCP/IP partition via VSE console commands as follows:
msg f7
AR 0015 1I40I READY
F7-0100 IPN300I Enter TCP/IP Command
102 def file,pub=CNXVVRR,dlbl=CNXVVRR,type=lib,READONLY=NO
F7 0098 IPN264I File defined, Dataset: CNXVVR
The CONNX for VSE-Adabas SQL Gateway library can be permanently defined to the TCP/IP partition via the batch JCL provided in member IPINIT00 of the TCP/IP for VSE installation library. The control record syntax is identical to the console command:
DEFINE FILE,PUBLIC='CNXVVRR',DLBL=CNXV8R8,TYPE=LIBRARY,READONLY=NO
To verify that the new CNXVVRR library is defined and available for ftp, start a Command Prompt window, and then an ftp session to the target host. Once logged on, you can navigate to the CNXVVRR directory and list the subdirectories.