Hi all,
In this post when I am referring to "Embedded SQL" I am thinking of
this http://en.wikipedia.org/wiki/Embedded_SQL.
That is, a programmer
embeds his SQL statements in some host language (e.g. Java) and runs a
preprocessor which compiles the SQL before passing on the result to
the host language compiler. That is, embedded SQL do not refer to ODBC
or JDBC (in this post).
I have often wondered why embedded SQL has not become more popular
than it has. While it is popular in the mainframe world, I atleast,
have not seen much use of it outside. In stead I have seen people use
ODBC or JDBC for purposes where embedded SQL could have been used.
However, ODBC/JDBC seems mostly inferior to embedded SQL as it lacks
syntax and type checking. And in my experience, most people do
consider ODBC/JDBC ***bersome to use.
To my questions:
Am I just "in the wrong circles" when I consider embedded SQL mostly
confined to the mainframe world?
And if not, why do people think ODBC/JDBC is so much more popular than
embedded SQL?
Greetings,
Mads Lindstr=F8m
|
