Embedded SQL
SQL commands can be called from within a host language (e.g., C or COBOL) program.
- SQL statements can refer to host variables (including special variables used to return status).
- Must include a statement to connect to the right database.
- Requires compiler preprocessing
- SQL relations are (multi-) sets of records, with no a priori bound on the number of records. No such data structure in C.
- SQL supports a mechanism called a cursor to handle this.