[Info-vax] VMS Software: New US Mailing Address

[Bill Gunshannon]

On 10/13/22 19:14, Arne Vajhøj wrote:
> On 10/13/2022 6:25 PM, Bill Gunshannon wrote:
>> On 10/13/22 17:40, Jan-Erik Söderholm wrote:
>>> Think of it as a compiler for a language called "SQL".
>>> The default file type for these files (on VMS) is .SQLMOD
>>>
>>> It's more or less "just" as a compiler for any other language.
>>> And it creates a object files that are no different from any
>>> other object file, may it come from C, Pascal or whatever.
>>>
>>> That object file can then be linked into any other application
>>> following the VMS calling standard. That other language does not
>>> need to have any native support for Rdb, it just has to follow the
>>> VMS calling standard.
>>>
>>> It is just a function call with some parameters that returns some
>>> defined result. The caller does not need to know that it was Rdb
>>> that returned the result.
>>
>> Well, that's pretty cool.  I have never seen COBOL used that way
>> although there really is no reason not to.  Just like the libraries
>> linked to from the EXEC SQL parts of the code are actually C or C++
>> snippets.  You can directly link to the PostGres Libraries but, for
>> obvious reasons, using the Embedded SQL method is easier on the
>> programmer.
> 
> Embedded SQL is pretty efficient - few lines achieve much - way
> more efficient than library calls in compiled languages (probably
> less efficient than library calls in scripts languages and ORM).
> 
> But the industry is moving away from embedded SQL and precompilers.
> 
> Oracle DB - only supports C and Cobol - it has dropped Fortran

That means Fortran is out, not embedded SQL.

> 
> MySQL/MariaDB - no pre-compilers

No one has expressed a need or desire for it yet.  (I have done
some playing with making ESQL work but nothing production level.)
More a MySQL shortcoming than embedded SQL.

> 
> PostgreSQL - only C (from project itself - an open source Cobol exist)

And that's the way Open Source works.  If there was a need other
languages would be supported.

> 
> SQLServer - dropped all support

Typical MicroSoft.

> 
> DB2 - still support Cobol, PL/I and C (maybe also Fortran - not sure)

Pretty sure they do.  Basicly, they support everything their customer
ask for.

> 
> Sybase (or whatever SAP calls it today) - I believe they have dropped 
> all support

I didn't even think that Sybase was still around.

> 
> SQLite - no pre-compilers

See MySQL above.  Same rules apply.  Including me working on a
precompiler but nothing production ready.  Just research into
the level of difficulty.

> 
> NoSQL databases (MongoDB etc.) - obviously no embedded SQL  :-)

Obviously.  :-)

All of this shows a lack of interest in languages that most people
think are dying.  Also in database systems not being used for the
kind of work that Oracle, RDP, DB2 and Postgres are.  I see nothing
here that even hints at embedded SQL going away.

bill

> 
> Arne
> 
> 
> 
> 
>