Select records from a database

/*--------------------------------------------------------------------
 * Very simple example Pro*C program to select records from a database
 *
 *                                              Frank Naude - Sep 2000
 *--------------------------------------------------------------------
 */
#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; 
}