zOs/TX/WK940DDK
------------$-{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';
drop tablespace $db.A940A;
commit;
------------------------------------------------------------------------
CREATE TABLESPACE A940A
IN $db
USING STOGROUP GSMS
PRIQTY 12 SECQTY 7200
FREEPAGE 0 PCTFREE 0
GBPCACHE CHANGED
TRACKMOD YES
BUFFERPOOL BP2
numparts 27
LOCKSIZE ANY
LOCKMAX SYSTEM
CLOSE YES
COMPRESS YES
CCSID EBCDIC
DEFINE YES
MAXROWS 255;
------------------------------------------------------------------------
create TABLE $creator.TMI100A1 like OA1A.TMI100A1
in $db.A940A
;
commit;
$@[
if $phase > 5 then $@=[
alter TABLE $creator.TMI100A1
add testOnly int not null with default -1;
commit;
$]
$]