create view zytst.v as
select (case t.c1 when ... then ... end) as vc1,
(case vc1 when ... then ... end) as vc2
from zytst.t
@
this statement does not work, because vc1 is an unavailable reference. Use following code instead.
create view zytst.v as
with tmp as
(select (case t.c1 when ... then ... end) as vc1
from zytst.t)
select vc1 as vc1,
(case vc1 when ... then ... end) as vc2
from tmp
@
- 文章信息
- 版权声明: 本文可以任意转载，转载时请务必以超链接形式标明文章原始出处和作者信息。
- 原文出处: http://www.aiview.com/
- 写于: 2006-03-23 [Edit]
- 作者: Alex (email &msn)
- 标签 Tags: DB2 Development (24)
