查询:
vi opsql.ec
C代码
EXEC SQL include sqlca.h;
#include
#include
intmain(intargc,char**argv)
{
EXEC SQL BEGIN DECLARE SECTION;
charname[50];
chardbname[20];
EXEC SQL END DECLARE SECTION;
strcpy(dbname,"hostdb");
EXEC SQL CONNECT TO :dbname;
if(sqlca.sqlcode)
{
printf("opeb db error,code=%d\n",sqlca.sqlcode);
return-1;
}
EXEC SQL DECLARE cur1 CURSOR FOR
SELECT khxm FROM accoinfo;
EXEC SQL OPEN cur1;
if(sqlca.sqlcode)
{
printf("open cur1 error,code=%d\n",sqlca.sqlcode);
return-1;
}
while(1)
{
memset(name,0x00,sizeof(name));
EXEC SQL FETCH cur1 INTO :name;
if(sqlca.sqlcode==100)break;
elseif(sqlca.sqlcode){
printf("open cur1 error,code=%d\n",sqlca.sqlcode);
return-1;
}
printf("name is [%s]\n",name);
}
EXEC SQL CLOSE cur1;
EXEC SQL DISCONNECT CURRENT;
return0;
}
EXEC SQL include sqlca.h;
#include
#include
int main(int argc,char **argv)
{
EXEC SQL BEGIN DECLARE SECTION;
char name[50];
char dbname[20];
EXEC S