Embedded SQL: Difference between revisions

Revision as of 14:05, 2 November 2023

Latest revision as of 15:28, 19 November 2024

(One intermediate revision by one other user not shown)

Line 1:

{{short description|Computer programming method}}

'''Embedded SQL''' is a method of combining the [[computing]] power of a [[programming language]] and the [[database]] [[Data Manipulation Language|manipulation]] capabilities of [[SQL]]. Embedded SQL [[statement (programming)|statements]] are SQL statements written inline with the program [[source code]], of the host language. The embedded SQL statements are [[parsing|parsed]] by an embedded SQL<ref> [[preprocessor]] and replaced by host-language [[call site|calls]] to a code [[library (computing)|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 [[:Category:C programming language family|C/C++]], [[COBOL]] and [[Fortran]]. This differs from SQL-derived programming languages that don't go through discrete preprocessors, such as [[PL/SQL]] and [[Transact-SQL|T-SQL]].

{{cite web

|url=https://usemynotes.com/embedded-sql-in-dbms/

|title=Embedded SQL in DBMS

|publisher=[[UseMyNotes]]

|accessdate=2023-10-13}}

</ref> [[preprocessor]] and replaced by host-language [[call site|calls]] to a code [[library (computing)|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 [[:Category:C programming language family|C/C++]], [[COBOL]] and [[Fortran]]. This differs from SQL-derived programming languages that don't go through discrete preprocessors, such as [[PL/SQL]] and [[Transact-SQL|T-SQL]].

The SQL standards committee defined the embedded SQL standard in two steps: a formalism called [[Module SQL|Module Language]] was defined, then the embedded SQL standard was derived from Module Language.<ref name="modulelang">

Line 110 ⟶ 104:

=== SAP Sybase ===

SAP Sybase ASE 15.7 supports embedded SQL for C and COBOL as part of the Software Developer Kit [[Sybase]].<ref>{{cite web

|url=http://www.sybase.com/products/allproductsa-z/softwaredeveloperkit/embeddedsql
|title=EmbeddedSQL

|work=SAP Sybase Products

|publisher=SAP Sybase

|accessdate=2012-09-05

|archive-date=2009-10-23

|archive-url=https://web.archive.org/web/20091023214433/http://www.sybase.com/products/allproductsa-z/softwaredeveloperkit/embeddedsql

|url-status=dead

}}</ref>