zOs/TX/WK959DDL

------------$-{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 PATH='$creator' ,OA1A;
drop view $creator.vWk959A;
drop view $creator.vWk959B;
$@[
if $phase >= 1  then $@=[
create view $creator.vWk959A as
     select 'UPPERCASE' UpperCase,
            'MixedCase' "MixedCase",
$@[
if $phase <= 1  then $@=[
            'lowercase' "lowerCase"
$] else $@=[
            'lowercase' "lowercase"
$]
$]
     , fosFmte7(count(*)) "nativeUdf oa1a.*"
     from sysibm.sysdummy1;
create view $creator.vWk959B
$@[
if $phase <= 1  then $@=[
     (UpperCase, "MixedCase", "LowerCase")
$] else $@=[
     (UpperCase, "MixedCase", "lowercase")
$]
$]
    as  select 'UPPERCASE', 'MixedCase', 'lowercase'
     from sysibm.sysdummy1;
$]
$]
commit;
---||| end   ddl testcase $mbr env $env phase $phase