When you run an Embedded SQL application, SQL statements are executed as follows:
1. For every SQL statement, the application calls the appropriate Embedded SQL run-time services.
2. If the SQL statement is static, the run-time services execute the previously compiled stored procedure with the appropriate input parameters. If the statement is dynamic, the run-time services issue the SQL statements directly.
3. The run-time services use DB-Library calls to send and retrieve data to and from SQL Server.
4. The run-time services insert data into C program host variables (or SQLDA data structures). Status and error information is inserted into the SQLCA data structure.