Include an SQL descriptor area in a C program.
EXEC SQL INCLUDE SQLDA; EXEC SQL DECLARE C1 CURSOR FOR SELECT DEPTNO, DEPTNAME, MGRNO FROM TDEPT WHERE ADMRDEPT = 'A00'; EXEC SQL OPEN C1; while (SQLCODE==0) { EXEC SQL FETCH C1 INTO :dnum, :dname, mnum; /* Print results */ } EXEC SQL CLOSE C1;
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.