VSI-I64VMS-LIBMARIADB-V0201-0A-1-RN.PDF

This document describes LibMariaDB for OpenVMS I64, version 2.1.0a, a port of the MariaDB C client API based on MySQL 3.23 and PHP's MySQLnd.

Purpose: It enables applications developed in C/C++, as well as other languages like COBOL, FORTRAN, Pascal, and BASIC via a language-agnostic API, to connect to MariaDB and MySQL databases, typically over TCP/IP.

New Features (v2.1.0a):

• Inclusion of a language-agnostic API.
• SSL/TLS support (based on OpenSSL 1.0.2r).
• Threads support for multi-threaded applications.

System Requirements:

• OpenVMS 8.4-1H1 I64.
• HP TCP/IP Services V5.7 ECO 2 or VSI TCP/IP (likely compatible with MultiNet).
• A preferred programming language compiler.
• Knowledge of OpenVMS and software development in that environment.

Installation: The software is installed via an OpenVMS PCSI kit using the PRODUCT INSTALL LIBMARIADB command. Post-installation, commands to start and stop LibMariaDB must be added to SYSTARTUP.COM and SYSHUTDWN.COM respectively. Logical names LIBMARIADB$ROOT and LIBMARIADB$SHR are defined for linking with either the shareable image (LIBMARIADB$SHR.EXE) or object library (LIBMARIADB.OLB). While no special privileges are strictly required, a high BYTLM and specific quotas are recommended. Installing to an alternative location using the /DESTINATION qualifier may require manually copying startup/shutdown files.

Development Notes: Sample applications for C, COBOL, and FORTRAN are provided in LIBMARIADB$ROOT:[EXAMPLES]. Developers using the C API should note that symbols are mixed-case and may require specific compiler options (e.g., /NAMES=(AS_IS,SHORTENED)); language-agnostic API symbols are uppercase. Comprehensive API documentation is recommended reading on the MariaDB website.

Current Limitations:

• Connector/C 3.0 functionality is not yet included.
• Conversion of double-precision values to strings with prepared SQL statements is not supported.
• The language-agnostic API is incomplete and does not implement all functionality supported by the C API.