Re: VMS x86-64 database server

On Tue, 8 Jul 2025 09:35:16 -0400, Arne Vajhøj wrote:

On 7/8/2025 4:14 AM, Louis Krupp wrote:

>
On 7/7/2025 4:07 PM, Lawrence D'Oliveiro wrote:

>
On Mon, 7 Jul 2025 14:07:31 -0400, Arne Vajhøj wrote:

>
Embedded SQL is a thing or was a thing 30-40-50 years ago.
>
Basically you write source code with SQL statements prefixed by EXEC
SQL, put it through a pre-compiler to get valid code in whatever
language (Cobol, PL/I, C or whatever).

>
OK, so it was a horrible nonstandard hack invented for programming
languages like COBOL, which didn’t have the best ability to deal with
dynamic strings, to make it easier for them to compose SQL statements.
>
And the horribleness of it is reinforced by your statement that you
need server-side cursors in the DBMS to make this hack a little less
difficult to work with.

 

As for embedded SQL being nonstandard, I think you might be interested
in this page:
 
https://www.iso.org/standard/84805.html
 
which contains this line:
 
    ISO/IEC 9075-2 specifies embedded SQL for the programming languages:
    Ada, C, COBOL, Fortran, MUMPS, Pascal, and PL/I.

 
Note that while -2 covers native languages, then -10 cover Java.
 
I am surprised that they still maintain embedded SQL for Java.
SQLJ has been out of fashion for like 25 years.

Yes, but “out of fashion” or not, it’s still supposed to be an official
standard according to ISO 9057, isn’t it? Otherwise we could apply the
“out of fashion” argument to some or all of those other parts of the spec
as well.

Either that, or you have to conclude that trying to patch up deficiencies
in one particular collection of official language specs by creating a
whole separate add-on spec that applies to that set of languages is not
exactly a scaleable endeavour.