Is there an advantage to embedd SQL or RDO versus SQLMOD?

« Back to Previous Page

Many clients are using one of the two models with RDB. Having seen and supported both, I was wondering if there were situations where one was more advantageous that the other.

Posted by Peter Marquez (Questions: 1, Answers: 1)
Asked on October 17, 2014 5:05 pm
Category: Oracle RDB

RDO has Long been deprecated. SQLMOD is not widely supported. SQL Embedded is the Mainstream.
Modern databases tend toward Stored Procedures and the use of Standard Interface languages such as ODBC, JDBC, Open Access.
If Embedded SQL is to be used, then preferably encapsulated in a very few common routines. One of the biggest disadvantages with Embedded SQL is the fact that many of the source code and runtime Analysis programs do not function well due to the fact the original source code is not that which is compiled. DECset is an excellent example of this.
Summary: no RDO; SQLMOD is an excellent solution, but hardly supported; Embedded SQL should be encapsulated; modern Interface Technologies such as JDBC and Open Access should be used

Posted by John Apps (Questions: 0, Answers: 1)
Answered on January 10, 2015 1:01 pm

Millions of years ago when I was developing using RDB I preferred SQLMOD as it kept the SQL separate and avoided issues with embedded SQL with the debugger and DECset because the compiled source code and what I wrote originally looked very different. Keeping the database access code encapsulated is always a good idea.

(Ian Miller at January 13, 2015 12:11 pm)
« Back to Previous Page