Embedded SQL
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.
- Comment
- enEmbedded 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.
- Has abstract
- enEmbedded 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. 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.
- Hypernym
- Method
- Is primary topic of
- Embedded SQL
- Label
- enEmbedded SQL
- Link from a Wikipage to an external page
- tahiti.oracle.com/pls/db92/db92.show_toc%3Fpartno=a58231
- www.postgresql.org/docs/current/ecpg.html
- www.oreillynet.com/pub/a/databases/2006/12/07/embedded-sql-with-pro-c.html
- www.ibm.com/support/knowledgecenter/SSGU8G_14.1.0/com.ibm.esqlc.doc/esqlc.html
- docs.oracle.com/javaee/6/tutorial/doc/gjrij.html
- infolab.stanford.edu/%7Eullman/fcdb/oracle/or-proc.html
- Link from a Wikipage to another Wikipage
- Ada (programming language)
- Altibase
- C++
- Call site
- Category:C programming language family
- Category:Database APIs
- Category:Data modeling languages
- Category:Declarative programming languages
- Category:Query languages
- Category:SQL
- Category:SQL data access
- COBOL
- Compiler
- Computing
- Database
- Data Manipulation Language
- ECPG
- Fortran
- I
- IBM Db2
- IBM Informix
- Informix
- Java (programming language)
- Java Object Oriented Querying
- Java Persistence API
- Language binding
- Language Integrated Query
- Library (computing)
- List of CLI languages
- MacOS
- Microsoft SQL Server
- Mimer SQL
- OLB
- OpenVMS
- Oracle Corporation
- Oracle Database
- Parsing
- Pascal (programming language)
- PostgreSQL
- Preprocessor
- Pro*C
- Programming language
- Source code
- SQL
- SQL
- SQL Anywhere
- SQL PL
- Statement (programming)
- Sybase
- Sybase IQ
- Transact-SQL
- SameAs
- Embedded SQL
- Embedded SQL
- Embedded SQL
- Embedded SQL
- m.0g rrz
- MYwe
- Q1335009
- 埋め込みSQL
- 嵌入式SQL
- 임베디드 SQL
- Subject
- Category:Database APIs
- Category:Data modeling languages
- Category:Declarative programming languages
- Category:Query languages
- Category:SQL
- Category:SQL data access
- WasDerivedFrom
- Embedded SQL?oldid=1084756453&ns=0
- WikiPageLength
- 8548
- Wikipage page ID
- 7002377
- Wikipage revision ID
- 1084756453
- WikiPageUsesTemplate
- Template:Cn
- Template:Short description