zOs/TX/WK942DDL
-----------$-[right(userid() sysvar(sysnode) date(s) time(), 60, '-')$]
-- testCase $dsn
-- env $env phase $phase
-- dbSys $dbSys db $db creator $creator
------------------------------------------------------------------------
---||| begin ddl testcase $mbr env $env phase $phase
SET CURRENT SQLID='S100447';
drop view $creator.vQz91Wk942null;
drop alias $creator.vQz91Wk942;
drop view $creator.vQz91Wk942;
create view $creator.vQz91Wk942null as select * from sysibm.sysdummy1;
$@[
if $phase = 1 then $@=[
create view $creator.vQz91Wk942 as
select * from $creator.vQz91Wk942null;
$] else if $phase = 2 then $@=[
create alias $creator.vQz91Wk942 for $creator.vQz91Wk942null;
$]
$]