zOs/TX/QBPRBDDL

 SET CURRENT SQLID = 'S100447';
 $= db = DA540769
 $= creator = A540769

    drop   TABLESPACE $db.qbprbG;
    drop   TABLESPACE $db.qbprbP;
 -- drop   TABLE $creator.Tacct_general20140701;
    commit;
$@[
if $phase >= 1 then  $@=[
    CREATE TABLESPACE qbprbG
           in $db
           BUFFERPOOL BP2
           CLOSE YES
           LOCKMAX SYSTEM
           DEFINE YES
           LOGGED
           LOCKSIZE ANY
           MAXROWS 255
           CCSID unicode
           SEGSIZE 64
                     USING STOGROUP GSMS
                                    PRIQTY -1
                                    SECQTY -1
                                    ERASE NO
                     GBPCACHE CHANGED
                     COMPRESS YES
 ;
    CREATE TABLESPACE qbprbP
           in $db
           BUFFERPOOL BP2
           CLOSE YES
           LOCKMAX SYSTEM
           DEFINE YES
           LOGGED
           LOCKSIZE ANY
           MAXROWS 255
           CCSID unicode
           SEGSIZE 64
                     USING STOGROUP GSMS
                                    PRIQTY -1
                                    SECQTY -1
                                    ERASE NO
                     GBPCACHE CHANGED
                     COMPRESS YES
 ;


    CREATE TABLE $creator.Tacct_general20140701
         like pbxx.tacct_general_20140701
   in $db.qbprbG
   WITH RESTRICT ON DROP
   NOT VOLATILE CARDINALITY
   DATA CAPTURE changes
   AUDIT NONE
   CCSID unicode
;
    CREATE TABLE $creator.Tacct_program20140701
         like pbxx.tacct_program_20140701
   in $db.qbprbP
   WITH RESTRICT ON DROP
   NOT VOLATILE CARDINALITY
   DATA CAPTURE changes
   AUDIT NONE
   CCSID unicode
;
commit;
$]
$]