Embedded SQL

Embedded SQL is a method of combining the computing power of a programming language and the database manipulation capabilities of SQL.

Here’s the high level idea:

Commands

Questions

• Explain the conditions that must be satisfied by an application in order that it can be encoded using C, Structured Query Language and the static embedded SQL protocol
  • syntactically valid embedded SQL program
  • sqc format
  • static query
• What is a host variable
  • A variable that’s used in the embedded SQL portion of C code. It communicates values/information between SQL and the host language. Acts as a placeholder for dynamic values.
• Indicator variable
  • A variable that’s associated with a host variable, they’ll say if it’s NULL or not. If an indicator variable is not provided and the result is NULL, run-time error results.

Related

• SQL