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