#include <stdio.h>
#define NO_MORE_TUPLES (sqlca.sqlcode == ECPG_NOT_FOUND)

/**********************
·	main ()
  */
int main(int argc, char* argv[])
{
   EXEC SQL BEGIN DECLARE SECTION;
	char hid[10];
      	char city[10];
   	char state[10];
	char country[10];
	char mystr[30];
   EXEC SQL END DECLARE SECTION;

   /* initiation  stuff */
   EXEC SQL INCLUDE sqlca;
   EXEC SQL CONNECT TO xyz USER abc;
   EXEC SQL WHENEVER sqlerror sqlprint;

	printf("Enter Hotel details\n");
	printf("Enter hotel id:\n");
	scanf("%s", hid);
	printf("Enter city:\n");
	scanf("%s", city);
	printf("Enter state:\n");
	scanf("%s", state);
	printf("Enter country:\n");
	scanf("%s", country);
	
   /* insert some tuples */
   EXEC SQL INSERT INTO hotel ( hid, city, state, country) VALUES(:hid, :city, :state, :country);
   EXEC SQL COMMIT;
  
   return 0;
}