作者clv (给真相=封锁)
看板Database
标题[SQL ] -501的问题
时间Mon Feb 2 22:59:30 2015
不知为什麽
红字部份 有时会出现-501
但我程式明明就做OPEN与CLOSE不晓得哪里有问题
是否有人可以给我一个方向呢
内容/问题描述：
long rc = RC_OK;
memset( HV_BUFFER , '\0', sizeof( HV_BUFFER ) );
strcpy( HV_BUFFER,"SELECT CHAMBER_ID FROM"
" DI.MM_PCD_WAFERCHAMBER"\
strcat( HV_BUFFER, " ORDER BY CLAIM_TIME DESC" );
strcat( HV_BUFFER, " FOR READ ONLY" );
//--------------------------
// SQL
//--------------------------
EXEC SQL PREPARE PRE_PCD_CHAMBER FROM :HV_BUFFER;
if ( SQLCODE != 0 )
{
return SQLCODE;
}
EXEC SQL DECLARE PCD_CHAMBER CURSOR FOR PRE_PCD_CHAMBER;
EXEC SQL OPEN PCD_CHAMBER;
if( SQLCODE != 0 )
{
return SQLCODE;
}
memset( hCHAMBER , '\0', sizeof(hCHAMBER ) );
EXEC SQL FETCH PCD_CHAMBER INTO :hCHAMBER
;
Long retSqlCode = SQLCODE;
EXEC SQL CLOSE PCD_CHAMBER;
SQLCODE = retSqlCode ;
if( SQLCODE != 0 )
{
if ( SQLCODE == 100 )
{
return 2;
}
return SQLCODE;
}
return RC_OK;
}
--
※ 发信站: 批踢踢实业坊(ptt.cc), 来自: 180.177.156.249
※ 文章网址: https://webptt.com/cn.aspx?n=bbs/Database/M.1422889172.A.940.html