• Re: Database access from C++ on VMS

    From =?UTF-8?Q?Arne_Vajh=C3=B8j?=@arne@vajhoej.dk to comp.os.vms on Thu Apr 16 21:09:04 2026
    From Newsgroup: comp.os.vms

    On 4/16/2026 5:36 PM, Arne Vajh|+j wrote:
    On 4/16/2026 5:02 PM, bill wrote:
    On 4/15/2026 7:56 PM, Arne Vajh|+j wrote:
    In all fairness then SQLRelay does have one big
    advantage: it comes with an embedded SQL precompiler
    for C and Cobol.

    Any hint as to where one would find that?-a I looked at their
    web pages and could find no mention of a Pre-Compiler or COBOL.


    That is important for VMS, because a big part of
    existing VMS database applications use embedded SQL
    (because they were created at a time where embedded
    SQL was "the way").

    Also, no mention of VMS in the supported platforms.

    It is supported on VMS by VSI (to the extent they support
    the open source software they port).

    https://products.vmssoftware.com/libsqlrelay

    The page is actually outdated. It says V1.9-3G, but
    the actual SP has V2.0-0E for Itanium and x86-64.

    After install you do:

    $ presqlr :== $sqlr$root:[bin]presqlr.exe

    and:

    $ presqlr /lang=c /iname=pre.pc /oname=pre.c

    $ presqlr /lang=cob /iname=pre.pco /oname=pre.cob

    Note that like any other embedded SQL precompiler (except SQLJ),
    then it is for a specific target - in this case SQLRelay.

    And just to try and explain what is in what.

    The SQLRelay open source project provide:
    * server with integrations to all sorts of databases
    * client with:
    - C API library
    - C++ API library
    - Java, Python, PHP, Ruby, Perl and Tcl drivers

    VSI provide:
    * client only with
    - C API library
    - C++ API library
    - VMS API library (descriptors etc. for Pascal, Fortran, Basic etc.)
    - embedded SQL pre compiler for Cobol and C

    Arne

    --- Synchronet 3.21f-Linux NewsLink 1.2