Select records from a database

/*--------------------------------------------------------------------
 * Very simple example Pro*C program to select records from a database
 *
 *--------------------------------------------------------------------
 */

#include <stdio.h> 
#include <sqlca.h>

void sqlerror(); 

EXEC SQL BEGIN DECLARE SECTION; 
char *connstr = "scott/tiger"; 
char db_ename[30];
int  db_deptno;
EXEC SQL END DECLARE SECTION; 

void main() { 
	EXEC SQL WHENEVER SQLERROR DO sqlerror(); 
	EXEC SQL WHENEVER SQLWARNING CONTINUE; 
	EXEC SQL CONNECT :connstr; 

	EXEC SQL WHENEVER NOTFOUND GOTO notfound; 
	EXEC SQL SELECT ENAME, DEPTNO
		 INTO   db_ename, db_deptno
        	 FROM   EMP
		 WHERE  EMPNO = 7369;

found:
	printf("%s is in department %i\n", db_ename, db_deptno);
	return; 

notfound:
	printf("Employee record not found in database.\n");
	return; 
} 

void sqlerror() { 
	printf("Stop Error:\t%25i\n", sqlca.sqlcode); 
	return; 
}