Embedded SQL
From Wikipedia, the free encyclopedia
Embedded SQL is a method of combining the computing power of a programming language and the database manipulation capabilities of SQL. It allows programmers to embed SQL statements in programs written in C/C++,Fortran, COBOL, Pascal, etc.
Embedded SQL statements are SQL statements written within application programming languages and preprocessed by a SQL preprocessor before the application program is compiled. There are two types of embedded SQL: static and dynamic.
The SQL standard defines embedding of SQL as embedded SQL and the language in which SQL queries are embedded is referred as host language. A popular host language is C and the mixed C and embedded SQL is called Pro*C in Oracle and Sybase database management systems.
