main()
{
exec sql begin declare section;
int uid,id_n,name_first,name_first_n,name_middle,name_middle_n,
name_last,name_last_n,company,company_n,address1,address1_n,
address2,address2_n,city,city_n,state,state_n,
country,country_n,zip,zip_n,phone_work,phone_work_n,
phone_home,phone_home_n,phone_fax,phone_fax_n,email,email_n,
billing_terms,billing_terms_n,confirmation_method,confirmation_method_n;

exec sql end declare section;
exec sql
      insert into
        customer(uid,id,name_first,name_middle,name_last,company,

        address1,address2,city,state,country,zip,phone_work,

        phone_home,phone_fax,email,date_entered,billing_terms,
                           confirmation_method)
      values (:uid,:uid:id_n,:name_first:name_first_n,
              :name_middle:name_middle_n, :name_last:name_last_n,
              :company:company_n,:address1:address1_n,
              :address2:address2_n,:city:city_n,:state:state_n,
              :country:country_n,:zip:zip_n,:phone_work:phone_work_n,

        :phone_home:phone_home_n,:phone_fax:phone_fax_n,:email:email_n,
              date('now'),:billing_terms:billing_terms_n,
              :confirmation_method:confirmation_method_n);
}