zOs/TX/WK957DDL

----------$-[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   TABLESPACE $db.Awk957A;
  commit;
$@[
if $phase  >= 1 then $@=[
  CREATE TABLESPACE aWk957A
    IN $db
    USING STOGROUP GSMS
    PRIQTY -1 SECQTY -1
    FREEPAGE 0 PCTFREE 10
    GBPCACHE CHANGED
    TRACKMOD YES
$@[
if $phase   = 1 then $@=[
    segsize 64
    BUFFERPOOL BP2
$] else if $phase   = 2 then $@=[
    numparts 2
    BUFFERPOOL BP8K0
$] else if $phase   = 3 then $@=[
    numparts 2
    member cluster
    BUFFERPOOL BP32K
$]
$]
    LOCKSIZE ANY
    LOCKMAX SYSTEM
    CLOSE YES
    COMPRESS YES
    CCSID      EBCDIC
    DEFINE YES
    MAXROWS 255;
  CREATE TABLE $creator.Tqz91wk957A1
     (WK957A001            CHAR(3) FOR SBCS DATA NOT NULL
     ,WK957A002            CHAR(4) FOR SBCS DATA NOT NULL
     ,WK957A003            CHAR(20) FOR SBCS DATA NOT NULL
     )
$@[
if $phase   > 1 then $@=[
    partition by (wk957A001)
       ( part 1 values ('z'), part 2 values(x'FF'))
$]
$]
    IN $db.awk957A
  ;
  COMMIT;
  insert into $creator.Tqz91wk957A1
      values('abc', 'abcd', 'abc part 1');
  insert into $creator.Tqz91wk957A1
      VALUES('ABC', 'ABCD', 'ABC PART 2');
  insert into $creator.Tqz91wk957A1
      VALUES('EFG', 'EFGH', 'EFG PART 2');
$]
$]
---||| end   ddl testcase $mbr env $env phase $phase