- 论坛徽章:
- 0
|
大家帮忙看看!!!
#ifdef DECLSPEC_DEFN
extern __declspec(dllimport) struct xa_switch_t db2xa_switch;
#else
#define db2xa_switch (*db2xa_switch)
extern struct xa_switch_t db2xa_switch;
#endif
#include <ctype.h>
#include <time.h>
#include <stdio.h>
#include <stdlib.h>
#include <string.h>
#include <stdio.h>
#include <atmi.h>
#include <userlog.h>
EXEC SQL INCLUDE sqlca;
EXEC SQL BEGIN DECLARE SECTION;
char empno[7]="";
char t_firstnme[10]="";
char midinit[2];
char lastname[10];
char workdept[6];
char phoneno[7];
short hiredate;
char job[8];
short edlevel;
char sex;
char birthdate[11];
long salary;
long bonux;
long t_comm=0;
// EXEC SQL VAR ac_ename IS STRING(11);
EXEC SQL END DECLARE SECTION;
TEST1(TPSVCINFO *rqst)
{
userlog("rqst->data===%s",rqst->data);
strcpy(empno,rqst->data);
userlog("empno====%s",empno);
EXEC SQL delete from db2inst2.emp_act;
if(SQLCODE !=0)
{
userlog("delete failure,SQLCODE=%d,sqlerrms=%d===sqlerrml%s",SQLCODE,sqlca.sqlerrml);
}
EXEC SQL select firstnme into :t_firstnme from db2inst2.employee where empno=:empno;
userlog("firstnme===%s",t_firstnme);
if(SQLCODE !=0)
{
userlog("select from emp failure,SQLCODE=%d,SQLERRMC=%d",SQLCODE,sqlca.sqlerrd);
}
strcpy(rqst->data,t_firstnme);
tpreturn(TPSUCCESS,0,rqst->data,0,0);
} |
|