[Info-vax] Oracle on VMS

[Bill Gunshannon]

On 11/19/16 6:08 AM, Jan-Erik Soderholm wrote:
> Den 2016-11-19 kl. 00:30, skrev Bill Gunshannon:
>> On 11/18/16 12:16 PM, Jan-Erik Soderholm wrote:
>>> Den 2016-11-18 kl. 17:02, skrev Bill Gunshannon:
>>>>
>>>> Maybe I have been out of touch long enough to miss the
>>>> change, but wasn't Oracle ordered by the courts to continue
>>>> support for VMS?  I was looking at the pre-compilers for
>>>> embedded SQL and the absence of any for VMS is kinda obvious.
>>>> Was there never pre-compilers for VMS or have they dropped
>>>> all support at this point in time?  Of course, a pre-compiller
>>>> implies a linkable library for the supported languages. I assume
>>>> these don't exist either.  Or did I miss something subtle?
>>>>
>>>> bill
>>>
>>> Are you talkning about "Oracle Oracle" or "Oracle Rdb"?
>>
>> Oracle Oracle
>>
>> I have never used Rdb.
>
> It's nice and more integrated with the VMS environment
> then Oracle "Classic".
>
>> Were there pre-compilers for embedded SQL
>> for things like COBOL for Rdb?
>
> Of course. Ada, C, COBOL, FORTRAN, Pascal, and PL/I *are* supported.
> Why do you ask in past tense?

Because the oracle pre-compiler download page makes no mention of VMS
at all so I have to assume they were no longer supporting VMS.

>
> For a more language independant mode, you can also compile plain SQL
> modules (source files) using the Modular Language SQL compiler. That
> produces standard VMS OBJ object files that can be linked just as
> usual with any language on VMS that follows the VMS calling standard.
>
> The docs are here:
>
> http://www.oracle.com/technetwork/database/database-technologies/rdb/documentation/index.html
>
>
> And the embedded SQL info is in Volume 1 of the SQL ref manual.
> Updated as late as sept-2016, so it is up to date...

Might be worth a look.  Just so people understand where I am coming
from, I am not really interested in either of the databases but I am
interested in how embedded SQL is implemented on the commercial DBs
because I am trying to look into implementing it for open source DBs
and GnuCOBOL.

bill