#include <stdio.h>

#include <string.h>

#include <string.h>

#include "sqlca.h"

//定义宿主变量 serverid

EXEC SQL BEGIN DECLARE SECTION ;

char *serverid = "scott/123456@orcl";

int deptno;

char dname[20];

char loc[20] ;

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;

}