zOs/TX/WK971DDL
set current sqlid = 'S100447';
set current schema = '$creator';
drop tablespace $db.a971a;
commit;
$@[
$=len=- (10-$phase)$phase
if $phase >= 1 & $phase <= 2 then $@=[
CREATE TABLESPACE A971A
IN $db
USING STOGROUP GSMS
PRIQTY 12 SECQTY 7200
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
TRACKMOD YES
segsize 64
BUFFERPOOL BP2
LOCKSIZE ANY
LOCKMAX SYSTEM
CLOSE YES
COMPRESS YES
CCSID EBCDIC
DEFINE NO
MAXROWS 255
;
CREATE TABLE $creator.TWK971A1
(WK971CHA CHAR($len) NOT NULL
,WK971CHB CHAR($len) NOT NULL
)
IN $db.A971A
AUDIT NONE
DATA CAPTURE NONE
CCSID EBCDIC
NOT VOLATILE
;
commit
;
$]
$]