保存动态SQL的执行结果

EXEC SQL PREPARE viewsql from :sqlstr;EXEC SQL declare cur_count1 CURSOR FOR viewsql;EXEC SQL OPEN cur_count1;while(1){    EXEC SQL fetch cur_count1 into:tmpRecord;    if ( SQLCODE == SQLNOTFOUND )        break;}