程序代码：

#include<stdio.h>
EXEC SQL INCLUDE sqlca;

void sqlerror();
int main(void)
{
EXEC SQL BEGIN DECLARE SECTION;
        char *uid="scott/scott@testdb";
        unsigned empno;
        char ename[11];
        double sal;
EXEC SQL END DECLARE SECTION;

EXEC SQL WHENEVER SQLERROR DO sqlerror();

EXEC SQL CONNECT :uid;

EXEC SQL DECLARE emp_cursor CURSOR FOR
SELECT empno,ename,sal from emp;
EXEC SQL OPEN emp_cursor;
while(1){
EXEC SQL WHENEVER NOT FOUND DO BREAK;
EXEC SQL FETCH emp_cursor INTO :empno,:ename,:sal;  //这里每次只fetch一行，想每次fetch100行的话，惯用法是什么？
fprintf(stdout,"%d %s %lf\n",empno,ename,sal);
}
EXEC SQL CLOSE emp_cursor;
        exit(0);
}
void sqlerror()
{
EXEC SQL WHENEVER SQLERROR CONTINUE;
fprintf(stderr,"sqlcode=%d\n%-70s\n",sqlca.sqlcode,sqlca.sqlerrm.sqlerrmc);
exit(1);
}

程序代码：

#include<stdio.h>
EXEC SQL INCLUDE sqlca;

void sqlerror();
int main(void)
{
   const int N = 3; //3条记录3条记录的取，表中一共13条记录
   EXEC SQL BEGIN DECLARE SECTION;
   char username[8];
   char password[8];
   char sid[8];
   struct Emp {
      unsigned empno;
      char ename[11];
      double sal;
   } stEMP[N];//如果以动态形式分配，则一次只能取一条

   EXEC SQL END DECLARE SECTION;

   strcpy(username, "scott");
   strcpy(password, "scott");
   strcpy(sid, "testdb");
   EXEC SQL WHENEVER SQLERROR DO sqlerror();

   EXEC SQL CONNECT:username IDENTIFIED BY:password USING:sid;

   EXEC SQL DECLARE emp_cursor CURSOR FOR
   SELECT empno,ename,sal from emp;
   EXEC SQL OPEN emp_cursor;
   EXEC SQL WHENEVER NOT FOUND DO BREAK;//当fetch的记录数小于数组的维数时（这里也就是数组元素的个数），会报not found
   int i,count;
   while(1){
   i=sqlca.sqlerrd[2];
        fprintf(stdout,"i=%d\n",i);
   EXEC SQL FETCH emp_cursor INTO :stEMP;
   printf("sqlca.sqlerrd[2]=%d\n",sqlca.sqlerrd[2]);
   for (count = 0; count < sqlca.sqlerrd[2]-i; count++)
      fprintf(stderr, "%d %s %.2lf\n", stEMP[count].empno, stEMP[count].ename,
              stEMP[count].sal);
   }
   for (count = 0; count < sqlca.sqlerrd[2]-i; count++)//不执行此句则结果不全
      fprintf(stderr, "%d %s %.2lf\n", stEMP[count].empno, stEMP[count].ename,
              stEMP[count].sal);
   EXEC SQL CLOSE emp_cursor;
   exit(0);
}

void sqlerror()
{
   EXEC SQL WHENEVER SQLERROR CONTINUE;
   fprintf(stderr, "sqlcode=%d\n%-70s\n", sqlca.sqlcode,
           sqlca.sqlerrm.sqlerrmc);
   exit(1);
}