#include <stdio.h>



EXEC SQL WHENEVER sqlerror sqlprint;
EXEC SQL WHENEVER sqlwarning sqlprint;
EXEC SQL WHENEVER not found sqlprint;



void main (){

EXEC SQL BEGIN DECLARE SECTION;
	
	struct employee {
   		int empno;
	   char ename[11];
	   char job[15];
	   int	arr_col[3];
	}; 

	int i;
	struct employee emp[14];

	EXEC SQL END DECLARE SECTION;


	
	EXEC SQL CONNECT TO 'unix:postgresql://localhost/postgres' AS main USER ashutosh;

    EXEC SQL DECLARE cur1 CURSOR FOR  select empno, ename, job, arr_col from emp;

    EXEC SQL OPEN cur1;

  	/* Fetch multiple columns into one structure. */
    EXEC SQL FETCH 3 FROM cur1 INTO :emp;
	printf("\n+++++++++++++++++++++++++++++++++++++++++++++++\n");
    
	/* Print members of the structure. */
	for ( i = 0 ;i < 3; i++){
	    printf("empno=%d, ename=%s, job=%s, arr_col[2]=%d\n", emp[i].empno, emp[i].ename, emp[i].job, emp[i].arr_col[2]);
		
	}
	EXEC SQL CLOSE cur1;

	EXEC SQL COMMIT;

   
	
}