Using Shared Variables

Void simpleInsert() {

EXEC SQL BEGIN DECLARE SECTION;

char productName[20], company[30];

char SQLSTATE[6];

EXEC SQL END DECLARE SECTION;

/* get values for productName and company

somehow */

EXEC SQL INSERT INTO Product(name, company)

VALUES (:productName, :company);

}