Hi all,
Actually, I'm working with Tuxedo and Informix, all servers are
connected with Informix whit the sentence DATABASE:
tpsvrinit()
{
EXEC SQL DATABASE ladasoft;
if(sqlca.sqlcode < 0)
{
ReportaErr("TPSRVINIT","Al Ejecutar el
DATABASE",sqlca.sqlcode,"DATABASE
itrofcfalla");
}
}
After time, the servers are disconnected and appears the -349 error.
What happens? It could be indexes? is the query? is the session dead (I
don't know the diference between DATABASE / CONNECT) ?
For example, a server that use to be disconnected has this code:
sprintf(squery,"select UNIQUE PIC.telefono_pisa, PIC.item,
CAT.desc_item, CAT .nivel from pic@des:sereqp PIC, lada:items_internet
CAT where PIC.item = CAT.item and PIC.telefono_pisa in (select
AG.telefono_pisa from pic@des:agrupado AG where AG.tel_fact_pisa = '%s'
and AG.status = '0') order by pic.telefono_pisa, cat.nivel desc",sTel);
EXEC SQL PREPARE det_com_qa from :squery;
if (sqlca.sqlcode != 0)
{
userlog("Error en PREPARE sqlcode=%d",sqlca.sqlcode);
tpreturn(TPFAIL, 0,val, 0L,0);
}
In the ulog appers:
180135.k460!ladasoft14.5851: Error SELECT -349
Thanks in advance,
* Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
The fastest and easiest way to search and participate in Usenet - Free!