tpsvrinit(int argc,char *argv[])
{
if(tpopen()==-1){
printf("error to connect to oracle!\n");
}
printf("the oracleserv successfully to connect to db2 in linux!\n");
return 0;
}
ORACLES(TPSVCINFO *rqst)
{
exec sql begin declare section;
char db_string[50];
exec sql end declare section;
int i=0;
for(i=0;i<rqst->len-1;i++){
db_string=rqst->data;
}
exec sql delete from system.hmptest where username=:db_string;
if(sqlca.sqlcode!=0){
printf("delete error!\n");
tpreturn(TPFAIL,0,NULL,0,0);
}
tpreturn(TPSUCCESS,0,rqst->data,0L,0);
}
tpsvrinit(int argc,char *argv[])
{
if(tpopen()==-1){
printf("error to connect to oracle!\n");
}
printf("the oracleserv successfully to connect to db2 in linux!\n");
return 0;
}
ORACLES(TPSVCINFO *rqst)
{
exec sql begin declare section;
char db_string[50];
exec sql end declare section;
int i=0;
for(i=0;i<rqst->len-1;i++){
db_string=rqst->data;
}
exec sql delete from system.hmptest where username=:db_string;
if(sqlca.sqlcode!=0){
printf("delete error!\n");
tpreturn(TPFAIL,0,NULL,0,0);
}
tpreturn(TPSUCCESS,0,rqst->data,0L,0);
}
tpsvrinit(int argc,char *argv[])
{
if(tpopen()==-1){
printf("error to connect to oracle!\n");
}
printf("the oracleserv successfully to connect to db2 in linux!\n");
return 0;
}
ORACLES(TPSVCINFO *rqst)
{
exec sql begin declare section;
char db_string[50];
exec sql end declare section;
int i=0;
for(i=0;i<rqst->len-1;i++){
db_string=rqst->data;
}
exec sql delete from system.hmptest where username=:db_string;
if(sqlca.sqlcode!=0){
printf("delete error!\n");
tpreturn(TPFAIL,0,NULL,0,0);
}
tpreturn(TPSUCCESS,0,rqst->data,0L,0);
}