CASE
can not use CASE WHEN statement within
FOR myloop AS
SELECT c1 FROM t1
DO
...
END FOR;
use IF ELSEIF instead.
SELECT INTO
can not use SELECT INTO statement within
FOR myloop AS
SELECT c1 FROM t1
DO
...
END FOR;
use SET var = (SELECT ... FROM ...) instead.
COLUMN
can not refer to the column name c1 as t1.c1 within
FOR ... AS SELECT c1 FROM tab AS t1
can only use c1 without schema.
- 文章信息
- 版权声明: 本文可以任意转载，转载时请务必以超链接形式标明文章原始出处和作者信息。
- 原文出处: http://www.aiview.com/
- 写于: 2006-03-22 [Edit]
- 作者: Alex (email &msn)
- 标签 Tags: DB2 Development (24)
