67
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;