int deptno2;
char dname2[20];
char loc2[20] ;
EXEC SQL END DECLARE SECTION;
//获取
int main()
{
int ret = 0;
printf("hello....\n");
//在C中是宿主变量
printf("serverid:%s \n", serverid);
//嵌入式SQL语言必须要以 EXEC SQL开头
//:serverid
EXEC SQL connect :serverid;
if (sqlca.sqlcode != 0)
{
ret = sqlca.sqlcode;
printf("EXEC SQL connect:err, %d\n", ret);
return ret;
}
printf("connect ok\n");
deptno = 50;
strcpy(dname, "50name");
strcpy(loc, "50loc");
EXEC SQL select deptno, dname, loc into :deptno2, :dname2, :loc2 from dept where deptno=:deptno;
printf("%d, %s, %s\n", deptno2, dname2, loc2);
EXEC SQL COMMIT RELEASE; //提交事务断开连接
return ret;
}