zOs/TX/WK932DDL
------------$-{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';
drop view $creator.vWk932A1 ;
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC";
CREATE View $creator.vWk932A1 as
select $phase phase from sysibm.sysDummy1;
$@[
if $phase <= 2 then $@=[
set current sqlid = '$creator';
create synonym swk9321A1 for $creator.vWk932A1;
$] else if $phase >= 5 then $@=[
set current schema = '$creator';
create synonym swk9321A1 for $creator.vWk932A1;
set current schema = '${creator}B';
create synonym swk9321A1 for $creator.vWk932A1;
$]
$]
commit;