Talk:Embedded SQL

This article is within the scope of WikiProject Databases, a project which is currently considered to be inactive.DatabasesWikipedia:WikiProject DatabasesTemplate:WikiProject DatabasesDatabases

copyvio?

http://www.cs.sfu.ca/CC/354/zaiane/material/notes/Chapter4/node33.html --Yurik 23:09, 21 November 2006 (UTC)[reply]

Direct copy and likely copyright violation. I have removed it. 68.39.174.238 18:16, 10 February 2007 (UTC)[reply]

MySql...so does it or doesn't it?

MySql is listed in both the support and not support. The text under support seems to be copy-pasted from the Microsoft SQL above it. The reference for the does NOT support does indeed say that it's not natively supported, but seems to be a project to add support. It's not clear at all and I don't want to muddy the waters by changing things to fit my best guesses. 66.14.187.7 (talk) 00:27, 28 July 2010 (UTC)[reply]

Database engines do not support Embedded SQL

I suppose this is a nit, but statements such as "xxx SQL does not support Embedded SQL." are incorrect. It may be that the "xxx SQL" vendor does not provide an Embedded SQL preprocessor.

Support for Embedded SQL is in the compiler tool chain, not the database engine itself. Therefore, any database engine that can be accessed by a high level language (i.e., has an SDK) does support Embedded SQL; whether there is an actual preprocessor provided by the vendor is irrelevant. The SQL engine does know, or care, if the SQL interface calls were hand coded or the result of Embedded SQL preprocessing.

Suggest rephrasing the statements to indicate whether the database engine vendor provides/supports an Embedded SQL Preprocessor tool.

Hi

Embedded SQL is a method of combining the computing power of a programming language and the database manipulation capabilities of SQL. Embedded SQL statements are SQL statements written inline with the program source code, of the host language. The embedded SQL statements are parsed by an embedded SQL preprocessor and replaced by host-language calls to a code library. The output from the preprocessor is then compiled by the host compiler. This allows programmers to embed SQL statements in programs written in any number of languages such as C/C++, COBOL and Fortran. This differs from SQL-derived programming languages that don't go through discrete preprocessors, such as PL/SQL and T-SQL.

The SQL standards committee defined the embedded SQL standard in two steps: a formalism called Module Language was defined, then the embedded SQL standard was derived from Module Language.[1] The SQL standard defines embedding of SQL as embedded SQL and the language in which SQL queries are embedded is referred to as the host language. A popular host language is C. Host language C and embedded SQL, for example, is called Pro*C in Oracle and Sybase database management systems, ESQL/C in Informix, and ECPG in the PostgreSQL database management system. SQL may also be embedded in languages like PHP etc. 117.217.37.254 (talk) 08:50, 28 February 2023 (UTC)[reply]