[Info-vax] Oracle on VMS

[Arne Vajhøj]

On 11/20/2016 3:45 PM, Bill Gunshannon wrote:
> On 11/19/16 10:26 PM, Arne Vajhøj wrote:
>> On 11/19/2016 4:40 PM, Bill Gunshannon wrote:
>>> 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.
>>
>> That sounds like a very interesting project.
>
> Gotta do something to keep me busy.
>
>> May I ask what databases you are targeting?
>
> Probably Postgres first but once I do the first one adding
> others will be much easier.

PostgreSQL already have support for embedded SQL in C.

ECPG

Source code is available so that may be a good starting point.

You could also look at MySQL.

I don't think it has anything yet.

But libmysql is very straigthforward.

>> And whether you want to implement the pre-compiler in Cobol?
>
> I have thought of that, too.  It has pluses and minuses but it is
> definitely doable.  I also have an example partial pre-compiler for
> C that is done in awk and yacc and the permission of the author to
> extend it or develop further along those lines.

I don't think Cobol or Fortran would be the best languages
for the task. But they may be the best languages for the
task for you if you know them better.

Arne