部分代码如下:
char hshsParamUsage[2] = {0};
hshsParamUsage[0] = '0'
EXEC SQL declare dm_srv_param_cur cursor for select param_index, param_data
from TBL_SRV_PARAM where param_usage = :hsParamUsage order by param_index;
hshsParamUsage[0] = '1'
EXEC SQL open dm_srv_param_cur;
if (sqlca.sqlcode)
{
HtLog(gsLogFile, HT_LOG_MODE_ERROR, __FILE__,__LINE__, "Open cursor error, %d.", sqlca.sqlcode);
return -1;
}
打开游标将以param_usage =1来打开游标;