zOs/TX/SZ001DDL

$=db=DA586114
$=creator=A586114
------------------------------------------------------------------------
SET CURRENT SQLID='S100447';
------------------------------------------------------------------------
DROP TABLESPACE $db.ASZ001A;
------------------------------------------------------------------------
COMMIT;
------------------------------------------------------------------------
$@ if $phase >= 1 then $@=/pha1/ $**************************************

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

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

CREATE TABLE $creator.TQZ91SZ001A1
     (SZ001CH20            CHAR(20) FOR SBCS DATA not null with default
     ,SZ001CH5             CHAR(5) FOR SBCS DATA not null with default
     ,SZ001CH2             CHAR(2) FOR SBCS DATA not null with default
     ,SZ001TST             TIMESTAMP not null with default
$@ if $phase = 1 then $@=[ $********************************************

$] $@ else $@=[ $*******************************************************
     ,SZ001CH3             CHAR(3) FOR SBCS DATA not null with default
$] $********************************************************************
     )
    IN $db.ASZ001A
    AUDIT NONE
    DATA CAPTURE NONE
    CCSID EBCDIC
    NOT VOLATILE
;

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

CREATE INDEX $creator.IQZ91SZ001A0
  ON $creator.TQZ91SZ001A1
   (SZ001CH20             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
  CLUSTER
;

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

$@ if $phase = 1 then $@=[ $********************************************

INSERT INTO $creator.Tqz91SZ001A1
       (SZ001CH20,  SZ001CH5, SZ001CH2, SZ001TST ) VALUES
       ('erstens', 'e'      , '1'     , current timestamp           );

INSERT INTO $creator.Tqz91SZ001A1
       (SZ001CH20,  SZ001CH5, SZ001CH2, SZ001TST ) VALUES
       ('zweitens', 'zw'    , '2'     , current timestamp - 2 minute);

INSERT INTO $creator.Tqz91SZ001A1
       (SZ001CH20,  SZ001CH5, SZ001CH2, SZ001TST ) VALUES
       ('drittens', 'dre'   , '3'     , current timestamp - 3 hours);

INSERT INTO $creator.Tqz91SZ001A1
       (SZ001CH20,  SZ001CH5, SZ001CH2, SZ001TST ) VALUES
       ('viertens', 'vier',   '4',      current timestamp - 4 days);

INSERT INTO $creator.Tqz91SZ001A1
       (SZ001CH20,  SZ001CH5, SZ001CH2, SZ001TST ) VALUES
       ('fuenftens', 'fuenf', '5'     , current timestamp - 5 months );

$] $@ else $@=[ $*******************************************************

INSERT INTO $creator.Tqz91SZ001A1
       (SZ001CH20,  SZ001CH5, SZ001CH2, SZ001TST, SZ001CH3 ) VALUES
       ('erstens', 'e'      , '1'     , current timestamp           ,
        'C11');

INSERT INTO $creator.Tqz91SZ001A1
       (SZ001CH20,  SZ001CH5, SZ001CH2, SZ001TST, SZ001CH3 ) VALUES
       ('zweitens', 'zw'    , '2'     , current timestamp - 2 minute,
        'C22');

INSERT INTO $creator.Tqz91SZ001A1
       (SZ001CH20,  SZ001CH5, SZ001CH2, SZ001TST, SZ001CH3 ) VALUES
       ('drittens', 'dre'   , '3'     , current timestamp - 3 hours,
        'C33');

INSERT INTO $creator.Tqz91SZ001A1
       (SZ001CH20,  SZ001CH5, SZ001CH2, SZ001TST, SZ001CH3 ) VALUES
       ('viertens', 'vier',   '4',      current timestamp - 4 days,
        'C44');

INSERT INTO $creator.Tqz91SZ001A1
       (SZ001CH20,  SZ001CH5, SZ001CH2, SZ001TST, SZ001CH3 ) VALUES
       ('fuenftens', 'fuenf', '5'     , current timestamp - 5 months,
        'C55');

$] $********************************************************************
$/pha1/ $***************************************************************