following code would be fine:
declare var1 datatype;
declare mycur cursor for
select * from table1
where column = var1;
set var1 = 'varlue';
open mycur;
the results would be limited with the condition "where column = var1" as your wish.
- 文章信息
- 版权声明: 本文可以任意转载，转载时请务必以超链接形式标明文章原始出处和作者信息。
- 原文出处: http://www.aiview.com/
- 写于: 2006-03-29 [Edit]
- 作者: Alex (email &msn)
- 标签 Tags: DB2 Development (24)
