Overview

Passing data between a C program and SQL statements is particularly simple in embedded SQL. Instead of having the program paste data into the statements, you can simply write the name of a C variable into the SQL statement, prefixed by a colon. The following is an example.

EXEC SQL INSERT INTO sometable VALUES (:v1, 'foo', :v2);