- 论坛徽章:
- 0
|
int queryDB_TB_FRA100(TABLE_ITEM *pTable_item_out)
{
int nCount = 0;
EXEC SQL BEGIN DECLARE SECTION;
VARCHAR sqlstr[512];
VARCHAR mesID[32+1];
VARCHAR mesData[4999+1];
VARCHAR mesDate[14+1];
VARCHAR matNo[32+1];
VARCHAR test[36];
EXEC SQL END DECLARE SECTION;
if (sqlca.sqlcode != 0)
{
etsDebug(0, "数据库关闭sqlca.sqlcode1[%d]", sqlca.sqlcode);
return -1;
}
/*执行sql语句*/
EXEC SQL DECLARE t_cursor CURSOR FOR SELECT Msg_id,MAT_no,Remark,crt_dtime FROM TB_FRA100 WHERE Flag = 0 ORDER BY Crt_dtime ASC;
EXEC SQL OPEN t_cursor;
if (sqlca.sqlcode != 0)
{
etsDebug(0, "数据库关闭sqlca.sqlcode3[%d]", sqlca.sqlcode);
EXEC SQL CLOSE t_cursor;
return -1;
}
while (1)
{
memset(mesID.arr, 0, sizeof(mesID.arr));
mesID.len = 0;
memset(mesData.arr, 0, sizeof(mesData.arr));
mesData.len = 0;
memset(matNo.arr, 0, sizeof(matNo.arr));
matNo.len = 0;
memset(mesDate.arr, 0, sizeof(mesDate.arr));
matNo.len = 0;
EXEC SQL FETCH t_cursor INTO :mesID, :matNo, :mesData, :mesDate;
if (sqlca.sqlcode == 1403)
{
break;
}
if (sqlca.sqlcode < 0)
{
etsDebug(0, "数据库关闭sqlca.sqlcode5[%d]", sqlca.sqlcode);
EXEC SQL CLOSE t_cursor;
return -1;
}
mesID.arr[mesID.len] = '\0';
mesData.arr[mesData.len] = '\0';
matNo.arr[matNo.len] = '\0';
mesDate.arr[mesDate.len] = '\0';
strncpy(pTable_item_out[nCount].mesID, mesID.arr, 32);
strncpy(pTable_item_out[nCount].mesData, mesData.arr, 4999);
strncpy(pTable_item_out[nCount].matNo, matNo.arr, 32);
strncpy(pTable_item_out[nCount].mesDate, mesDate.arr, 14);
++nCount;
}
EXEC SQL CLOSE t_cursor;
return nCount;
}
此段程序 运行一段时间后就停在EXEC SQL OPEN t_cursor;
也没有错误返回。 帮忙分析一下 谢谢。 |
|