zOs/TX/QT002DDL

------------$-[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 tablespace $db.qt002;
commit;
$@[
if $phase >= 1 then $@=[
    CREATE TABLESPACE QT002
           IN $db
           BUFFERPOOL BP32K
           DSSIZE 1G
           CLOSE NO
           LOCKMAX SYSTEM
           LOGGED
           LOCKSIZE ANY
           MAXROWS 255
           COMPRESS YES
           CCSID EBCDIC
           NUMPARTS 20
           define no
;
    CREATE TABLE $creator.TQT002
        (qt002Part int not null
        ,qt002Int  int not null
        ,qt002Data  VARCHAR(32000) FOR SBCS DATA NOT NULL
        )
        IN $db.QT002
   APPEND NO
   WITH RESTRICT ON DROP
   NOT VOLATILE CARDINALITY
   DATA CAPTURE NONE
   AUDIT NONE
   CCSID EBCDIC
   PARTITION BY RANGE
        (QT002Part)
        ( partition 1 ending (1)
   $@do px=2 to 20 $@=[
        , PARTITION $px ending ($px)
        $]
        )
;

CREATE INDEX $creator.Iqt002A0
  ON $creator.TQT002
  (qt002Part              asc
  ,qt002Int               asc
  )
  partitioned
  USING STOGROUP GSMS
  ERASE  NO
  GBPCACHE CHANGED
  CLUSTER
  BUFFERPOOL BP1
  CLOSE YES
  COPY NO
  DEFER NO
  DEFINE no
;
commit;
$]
$]