VSI-AXPVMS-SQLRELAY-V0109-0A-1-RNOTES.PDF

This document introduces the VSI SQL Relay client API for OpenVMS Alpha, based on the SQL Relay 1.9.0 open-source distribution.

Key Features & Purpose:

• SQL Relay is an open-source database connection management solution that sits between applications and databases.
• It provides functionality beyond direct database capabilities, including persistent connection pooling, proxying, throttling, high availability, query routing, filtering, translation, and connection scheduling.
• For OpenVMS, its proxying capabilities are particularly useful for accessing databases from unsupported platforms.
• Supported databases include Oracle, Sybase, Microsoft SQL Server, IBM DB2, MySQL, MariaDB, PostgreSQL, Firebird, SQLite, and ODBC sources.
• This OpenVMS port includes all open-source client functionality, SSL/TLS support (via OpenSSL 1.1.1g), a wrapper API for easier use with OpenVMS languages like COBOL, FORTRAN, Pascal, and BASIC, and command-line tools (sqlrsh, sqlr-export, sqlr-import).

Requirements:

• VSI OpenVMS Alpha Version 8.4-2L2 or higher.
• VSI, HPE, or MultiNet TCP/IP Services for OpenVMS.
• A C or other language compiler (VSI C++ V7.4-008 or higher for C++ applications).
• OpenSSL 1.1.1 (statically linked).
• Familiarity with OpenVMS and its development environment.

Installation & Configuration:

• The client API is provided as an OpenVMS PCSI kit (VSI-AXPVMS-SQLRELAY-V0109-0A-1.PCSI) and installed using $ PRODUCT INSTALL SQLRELAY.
• Post-installation, commands from the installation procedure should be added to SYSTARTUP_VMS.COM to define system-wide logical names (e.g., SQLR$ROOT, SQLR$SHR, and language-specific include directories).
• Crucially, this document covers only the client API. A separate SQL Relay server must be installed and configured on a Linux or Windows host where the target database resides.

Development & Samples:

• The kit includes sample programs in C, COBOL, FORTRAN, BASIC, and Pascal in SQLR$ROOT:[EXAMPLES], which can be built using BUILD_EXAMPLES.COM.
• These examples require a configured SQL Relay server environment and will need modification for specific connection details.
• Generally, no special quota or privilege requirements exist for applications, though a high BYTLM is recommended.

Future Plans:

• Subsequent releases for OpenVMS will include additional development tools, embedded SQL processors for various programming languages, and an enhanced interactive query tool.