Path: nntp.eternal-september.org!news.eternal-september.org!eternal-september.org!feeder3.eternal-september.org!news.szaf.org!3.eu.feeder.erje.net!feeder.erje.net!usenet.goja.nl.eu.org!dotsrc.org!filter.dotsrc.org!news.dotsrc.org!not-for-mail
Date: Mon, 7 Jul 2025 14:21:58 -0400
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: VMS x86-64 database server
Newsgroups: comp.os.vms
References: <104ejo8$2cobv$1@dont-email.me>
 <686af3b4$0$686$14726298@news.sunsite.dk> <104f0a6$2gn2r$5@dont-email.me>
 <104f2ic$2h75q$2@dont-email.me> <104fc66$2n4ir$2@dont-email.me>
 <104h2d1$31cae$2@dont-email.me> <686c0f12$0$684$14726298@news.sunsite.dk>
Content-Language: en-US
From: =?UTF-8?Q?Arne_Vajh=C3=B8j?= <arne@vajhoej.dk>
In-Reply-To: <686c0f12$0$684$14726298@news.sunsite.dk>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Lines: 32
Message-ID: <686c1044$0$684$14726298@news.sunsite.dk>
Organization: SunSITE.dk - Supporting Open source
NNTP-Posting-Host: 9664544e.news.sunsite.dk
X-Trace: 1751912516 news.sunsite.dk 684 arne@vajhoej.dk/70.172.216.99:55034
X-Complaints-To: staff@sunsite.dk

On 7/7/2025 2:16 PM, Arne Vajhøj wrote:
> On 7/7/2025 2:07 PM, Arne Vajhøj wrote:
>> On 7/6/2025 10:42 PM, Lawrence D'Oliveiro wrote:
>>> On Sun, 6 Jul 2025 19:58:04 -0400, Arne Vajhøj wrote:
>>>> But in embedded SQL then it is the standard way to do queries.
>>>
>>> Not sure what “embedded SQL” means. I normally use SQL “embedded” in an
>>> app written in some other programming language.
>>
>> 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).
> 
> I believe the available pre-compilers (database and language combos)
> for VMS are:
> 
> Oracle DB - Cobol, C, Fortran [support is ended, will never be on x86-64]
> Oracle Rdb - Cobol, C, Pascal, Fortran [not on x86-64 yet but coming]
> Mimer - Cobol, C, Fortran
> ? via SQLRelay - Cobol, C
> any database with JDBC driver - Java [unsupported]

+the topic

PgSQL - C

:-)

Arne