Interface: SQL / Host Language

Values get passed through shared variables.

Colons precede shared variables when they occur within the

SQL statements.

EXEC SQL: precedes every SQL statement in the host language.

The variable SQLSTATE provides error messages and status

reports (e.g., 00000 says that the operation completed with no

problem).

EXEC SQL BEGIN DECLARE SECTION;

char productName[30];

EXEC SQL END DECLARE SECTION;