zOs/TX/PER23DDL

-- testcase tnz240 repartitionierung -------------------------
set current sqlid = 'S100447';
   DROP TABLESPACE  $db.aper23ts ;
   COMMIT ;
   ;
 $@[
if $phase >= 1 then $@=[
--
  CREATE TABLESPACE aper23ts
    IN $db
    USING STOGROUP GSMS
    PRIQTY -1 SECQTY -1
    FREEPAGE 0 PCTFREE 0
    GBPCACHE CHANGED
    TRACKMOD NO
    LOGGED
    SEGSIZE 64
    BUFFERPOOL BP2
    LOCKSIZE ANY
    LOCKMAX SYSTEM
    CLOSE YES
    COMPRESS YES
    CCSID      unicode
    DEFINE YES
    MAXROWS 255;
--
  CREATE TABLE $creator.tper23Ts
       (text char(20) not null
       ,decFl decFloat(34) not null
       )
    in $db.aper23ts
;
insert into $creator.tper23Ts values ('eins', 12.34);
commit;
$]
$]