zOs/TX/WK947DDL
------------$-{right(userid() sysvar(sysnode) date(s) time(), 60, '-')}
-- testCase $dsn
-- env $env phase $phase
-- subsys $subsys db $db creator $creator
------------------------------------------------------------------------
---||| begin ddl testcase $mbr env $env phase $phase
SET CURRENT SQLID='S100447';
SET CURRENT SCHEMA='$creator';
SET CURRENT PATH='$creator';
$=cr=-copies($creator'.', $wiCre)
drop view ${cr}wk947null;
drop view ${cr}wk947eins;
drop view ${cr}wk947zwei;
create view ${cr}wk947null as select $phase pha$phase
from sysibm.sysdummy1;
$@[
if $phase >= 1 then $@=[
create view ${cr}wk947eins as
select * from ${cr}wk947null;
$]
if $phase >= 2 then $@=[
create view ${cr}wk947zwei
as select * from ${cr}wk947eins;
$]
$]
commit;