zOs/TX/WK948DDL

------------$-{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';
drop view $creator.wk948null;
drop view $creator.wk948eins;
drop alias $creator.wk948alias;
drop alias $creator.wk948dreA;
drop alias $creator.wk948dreV;
drop view  $creator.wk948dreA;
drop view  $creator.wk948dreV;
$@[
if $phase >= 1 then $@=[
  create view $creator.wk948null as select *
      from sysibm.sysdummy1;
$]
if $phase >= 2 then $@=[
  create view wk948eins as select * from wk948null;
$]
if $phase >= 3 then $@[
  $$ $' ' create alias wk948alias for wk948eins;
  if $phase = 3 then $@=[
      create view wk948dreV as select * from wk948alias;
      create alias wk948dreA for wk948Eins;
  $] else $@=[
      create view wk948dreA as select * from wk948Alias;
      create alias wk948dreV for wk948Eins;
  $]
$]
$]
commit;