69
Using Shared Variables
Void  simpleInsert() {
    EXEC SQL BEGIN DECLARE SECTION;
              char    n[20], c[30]; /* product-name, company-name */
int      p, q; /* price, quantity */
              char    SQLSTATE[6];
    EXEC SQL END DECLARE SECTION;
           /*   get values for name, price and company  somehow   */
   EXEC SQL INSERT  INTO Product(pname, price, quantity, maker)
          VALUES  (:n, :p, :q, :c);
 }