- 论坛徽章:
- 0
|
回复 #14 ljmmail 的帖子
谢谢,ljmmail .
我改成了如下:
========
#include <stdio.h>
#include <stdlib.h>
#include <atmi.h>
#include <userlog.h>
EXEC SQL INCLUDE sqlca;
EXEC SQL BEGIN DECLARE SECTION;
long al_empno=0;
char ac_ename[20];
EXEC SQL VAR ac_ename IS STRING(20);
EXEC SQL END DECLARE SECTION;
TEST1(TPSVCINFO *rqst)
{
/* receive empno from client to get ename from emp */
//al_empno=(FBFR32 *)rqst->data;
al_empno=aotl(rqst->data);
EXEC SQL SELECT ENAME INTO :ac_ename FROM EMP WHERE EMPNO=:al_empno;
if(sqlca.sqlcode!=0)
{
userlog("select from EMP failure, sqlcode=%ld, sqlerr=%s\n", sqlca.sqlcode, (char *)sqlca.sqlerrm.sqlerrmc);
strcpy(rqst->data, sqlca.sqlerrm.sqlerrmc);
tpreturn(TPFAIL, 0, rqst->data, 0, 0);
}
/* return result to client */
strcpy(rqst->data, ac_ename);
tpreturn(TPSUCCESS, 0, rqst->data, 0, 0);
}
===========
[ 本帖最后由 simhare 于 2009-6-30 14:01 编辑 ] |
|