zOs/TX/QBXC5DDL

 SET CURRENT SQLID = 'S100447';


    drop   TABLESPACE $db.qbxc5;
    commit;
    CREATE TABLESPACE qbXC5
           in $db
           BUFFERPOOL BP32K
           DSSIZE 16G
           CLOSE YES
           LOCKMAX SYSTEM
           SEGSIZE 64
           DEFINE YES
           LOGGED
           LOCKSIZE ANY
           MAXROWS 255
           CCSID EBCDIC
           NUMPARTS 5
                     USING STOGROUP "GSMS    "
                                    PRIQTY -1
                                    SECQTY -1
                                    ERASE NO
                     PCTFREE 5
                     FREEPAGE 0
                     GBPCACHE CHANGED
                     COMPRESS YES
                     TRACKMOD YES
 ;


    CREATE TABLE $creator.TQBXC5A1
        (XC502_PART_NUMBER CHARACTER(3) FOR SBCS DATA
                                                        NOT NULL
        ,XC502_DOC_UUID CHARACTER(36) FOR SBCS DATA
                                                        NOT NULL
        ,XC502_DOC_FORMAT CHARACTER(3) FOR SBCS DATA
                                                        NOT NULL
        ,XC502_DOC_CONTENT_SEQ INTEGER
                                                        NOT NULL
  WITH DEFAULT
        ,XC502_DOC_CONTENT VARCHAR(32000) FOR BIT DATA
                                                        NOT NULL
        ,CONSTRAINT XC502_PART_NUMBER PRIMARY KEY
        (XC502_PART_NUMBER
        ,XC502_DOC_UUID
        ,XC502_DOC_FORMAT
        ,XC502_DOC_CONTENT_SEQ
        )
        )
        IN $db.qbXC5
   APPEND NO
   WITH RESTRICT ON DROP
   NOT VOLATILE CARDINALITY
   DATA CAPTURE CHANGES
   AUDIT NONE
   CCSID EBCDIC
   PARTITION BY RANGE
        (XC502_PART_NUMBER NULLS LAST ASC
        )
        ( PARTITION 1
           ENDING ( '001'
        ) INCLUSIVE
        , PARTITION 2
           ENDING ( '002'
        ) INCLUSIVE
        , PARTITION 3
           ENDING ( '003'
        ) INCLUSIVE
        , PARTITION 4
           ENDING ( '004'
        ) INCLUSIVE
        , PARTITION 5
           ENDING ( '005'
        ) INCLUSIVE
        );

    create        unique index $creator.iqbxc5a0
           on $creator.tqbxc5a1
          (XC502_PART_NUMBER ASC
          ,XC502_DOC_UUID ASC
          ,XC502_DOC_FORMAT ASC
          ,XC502_DOC_CONTENT_SEQ ASC
          )
           CLUSTER
           PARTITIONED
           DEFINE YES
           COMPRESS NO
           BUFFERPOOL BP16K0
                     USING STOGROUP "GSMS    "
                                    PRIQTY -1
                                    SECQTY -1
                                    ERASE NO
           pctFree 50
           CLOSE YES
           DEFER NO
           COPY NO
;