[Info-vax] CRTL and RMS vs SSIO

[Arne Vajhøj]

On 10/14/2021 4:34 AM, Jan-Erik Söderholm wrote:
> Den 2021-10-14 kl. 02:30, skrev Lawrence D’Oliveiro:
>> On Thursday, October 14, 2021 at 4:10:52 AM UTC+13, Dave Froble wrote:
>>> Also, I've noticed that doing some things with SQL can be much more 
>>> complex.
>>
>> Only if you have to do them in COBOL!
> 
> Doesn't really matter what language you use EXEC SQL and END EXEC in,
> the SQL within that block looks the same.

Embedded SQL in language X and embedded SQL in language Y are
obviously very similar.

But embedded SQL is not the only way to access a
relational database.

3 common ways are:
- embedded SQL
- call API
- ORM

(ignoring Rdb's rather unique compilable modules)

And the availability and industry usage of those
vary by language.

Availability:

          embedded SQL     call API        ORM
Cobol    some databases   rare            no
C        some databases   most databases  no
Java     yes              yes             yes
C#       no               yes             yes
PHP      no               yes             yes
Python   no               yes             yes

Usage:

          embedded SQL     call API        ORM
Cobol    lot              none            -
C        some             lot             -
Java     none             some            lot
C#       -                lot             lot
PHP      -                lot             some
Python   -                lot             little

Note that embedded SQL is not so bad code wise.

My expectation will be that:

code(ORM) < code (embedded SQL) < code(call API)

Cobol is a verbose language whether using SQL or not.

Arne