zOs/TX/SZ003DDL

------------------------------------------------------------------------
SET CURRENT SQLID='S100447';
------------------------------------------------------------------------
DROP TABLESPACE $db.ASZ003A;
------------------------------------------------------------------------
COMMIT;
------------------------------------------------------------------------
$@ if $phase >= 1 then $@=/pha1/

CREATE TABLESPACE ASZ003A
    IN $db
    USING STOGROUP GSMS
    PRIQTY -1 SECQTY -1
    ERASE  NO
    FREEPAGE 0
    PCTFREE 10
    GBPCACHE CHANGED
    TRACKMOD YES
    SEGSIZE  64
    BUFFERPOOL BP2
    LOCKSIZE ANY
    LOCKMAX SYSTEM
    CLOSE YES
    COMPRESS YES
    CCSID EBCDIC
    DEFINE YES
    MAXROWS 255
;

------------------------------------------------------------------------

CREATE TABLE $creator.Tqz91SZ003A1
     (SZ003CH20            CHAR(20) FOR SBCS DATA not null with default
     ,SZ003CH5             CHAR(5) FOR SBCS DATA not null with default
     ,SZ003CH2             CHAR(2) FOR SBCS DATA not null with default
     ,SZ003TST             TIMESTAMP not null with default
     )
    IN $db.ASZ003A
    AUDIT NONE
    DATA CAPTURE NONE
    CCSID EBCDIC
    NOT VOLATILE
;

------------------------------------------------------------------------
COMMIT;
------------------------------------------------------------------------

CREATE INDEX $creator.Iqz91SZ003A0
  ON $creator.Tqz91SZ003A1
   (SZ003CH20             ASC)
  USING STOGROUP GSMS
  PRIQTY -1 SECQTY -1
  ERASE  NO
  FREEPAGE 0
  PCTFREE 10
  GBPCACHE CHANGED
  BUFFERPOOL BP1
  CLOSE YES
  COPY NO
  DEFINE YES
  PIECESIZE 2 G
$@ if $phase = 1 then $@=[
  CLUSTER
$] $@ else $@=[
  NOT CLUSTER
$]
;

------------------------------------------------------------------------
COMMIT;
------------------------------------------------------------------------

CREATE INDEX $creator.Iqz91SZ003A1
  ON $creator.Tqz91SZ003A1
   (SZ003CH5              ASC)
  USING STOGROUP GSMS
  PRIQTY -1 SECQTY -1
  ERASE  NO
  FREEPAGE 0
  PCTFREE 10
  GBPCACHE CHANGED
  BUFFERPOOL BP1
  CLOSE YES
  COPY NO
  DEFINE YES
  PIECESIZE 2 G
$@ if $phase = 1 then $@=[
  not CLUSTER
$] $@ else $@=[
  CLUSTER
$]
;

------------------------------------------------------------------------
COMMIT;
------------------------------------------------------------------------

INSERT INTO $creator.Tqz91SZ003A1
       (SZ003CH20,  SZ003CH5, SZ003CH2, SZ003TST ) VALUES
       ('erstens', 'e'      , '1'     , current timestamp           );

INSERT INTO $creator.Tqz91SZ003A1
       (SZ003CH20,  SZ003CH5, SZ003CH2, SZ003TST ) VALUES
       ('zweitens', 'zw'    , '2'     , current timestamp - 2 minute);

INSERT INTO $creator.Tqz91SZ003A1
       (SZ003CH20,  SZ003CH5, SZ003CH2, SZ003TST ) VALUES
       ('drittens', 'dre'   , '3'     , current timestamp - 3 hours);

INSERT INTO $creator.Tqz91SZ003A1
       (SZ003CH20,  SZ003CH5, SZ003CH2, SZ003TST ) VALUES
       ('viertens', 'vier',   '4',      current timestamp - 4 days);

INSERT INTO $creator.Tqz91SZ003A1
       (SZ003CH20,  SZ003CH5, SZ003CH2, SZ003TST ) VALUES
       ('fuenftens', 'fuenf', '5'     , current timestamp - 5 months );
$/pha1/