zOs/SQL/WI101DDL

  SET CURRENT SQLID='S100447';
  SET CURRENT SCHEMA='OA1P';
--
--xrop   TABLESPACE WI02a1p.A101A;
  commit;
  CREATE TABLESPACE A101A
    IN WI02A1P
    USING STOGROUP GSMS
    FREEPAGE 5 PCTFREE 5
    DSSIZE 16 G
    NUMPARTS 43
    BUFFERPOOL BP2
    LOCKSIZE ANY
    CLOSE NO
    COMPRESS YES
    LOCKPART YES;
--
  COMMIT;
--
------------------------------------------------------------------------
--    Table=OA1P.twi101A1 In WI02A1P.A101A
------------------------------------------------------------------------
--
--
  CREATE TABLE OA1P.twi101A1
     (WI10101T             CHAR(4) NOT NULL,
      WI10101D             CHAR(8) NOT NULL,
      WI10101L             CHAR(5) NOT NULL,
      WI10101G             CHAR(2) NOT NULL,
      WI10101V             CHAR(4) NOT NULL,
      WI10101B             CHAR(2) NOT NULL,
      WI10101I             TIMESTAMP NOT NULL,
      WI10102A             CHAR(3) NOT NULL,
      WI10102S             CHAR(5) NOT NULL,
      WI10103              CHAR(1) NOT NULL,
      WI10104              CHAR(1) NOT NULL,
      WI10105              CHAR(8) NOT NULL,
      WI10106              CHAR(20) NOT NULL,
      WI10107              CHAR(1) NOT NULL,
      WI10108              CHAR(1) NOT NULL,
      WI10109              CHAR(1) NOT NULL,
      WI10110              CHAR(1) NOT NULL,
      WI10112              TIMESTAMP NOT NULL,
      WI10113              CHAR(2) NOT NULL,
      WI10114              CHAR(1) NOT NULL,
      WI101PK              SMALLINT NOT NULL WITH DEFAULT
      )
    IN WI02A1P.A101A
    PARTITION BY (WI10101T ASC,
                  WI101PK ASC)
      (PARTITION  1 ENDING AT ('BM85', 53),
       PARTITION  2 ENDING AT ('BW8F', 53),
       PARTITION  3 ENDING AT ('B0YK', 53),
       PARTITION  4 ENDING AT ('B2H1', 53),
       PARTITION  5 ENDING AT ('B4VG', 53),
       PARTITION  6 ENDING AT ('CUBD', 53),
       PARTITION  7 ENDING AT ('CUBE', 11),
       PARTITION  8 ENDING AT ('CUBE', 22),
       PARTITION  9 ENDING AT ('CUBE', 32),
       PARTITION 10 ENDING AT ('CUBE', 43),
       PARTITION 11 ENDING AT ('C0ED', 53),
       PARTITION 12 ENDING AT ('C32W', 53),
       PARTITION 13 ENDING AT ('C62Y', 53),
       PARTITION 14 ENDING AT ('FFF5', 53),
       PARTITION 15 ENDING AT ('F00E', 53),
       PARTITION 16 ENDING AT ('F031', 53),
       PARTITION 17 ENDING AT ('F032', 11),
       PARTITION 18 ENDING AT ('F032', 22),
       PARTITION 19 ENDING AT ('F032', 32),
       PARTITION 20 ENDING AT ('F032', 43),
       PARTITION 21 ENDING AT ('F033', 53),
       PARTITION 22 ENDING AT ('F048', 53),
       PARTITION 23 ENDING AT ('F054', 53),
       PARTITION 24 ENDING AT ('F063', 53),
       PARTITION 25 ENDING AT ('F108', 53),
       PARTITION 26 ENDING AT ('F136', 53),
       PARTITION 27 ENDING AT ('F471', 53),
       PARTITION 28 ENDING AT ('F504', 53),
       PARTITION 29 ENDING AT ('F520', 23),
       PARTITION 30 ENDING AT ('F520', 53),
       PARTITION 31 ENDING AT ('F806', 53),
       PARTITION 32 ENDING AT ('F811', 53),
       PARTITION 33 ENDING AT ('F814', 27),
       PARTITION 34 ENDING AT ('F814', 53),
       PARTITION 35 ENDING AT ('F824', 53),
       PARTITION 36 ENDING AT ('F830', 27),
       PARTITION 37 ENDING AT ('F830', 53),
       PARTITION 38 ENDING AT ('MFSS', 53),
       PARTITION 39 ENDING AT ('NPM1', 27),
       PARTITION 40 ENDING AT ('NPM5', 53),
       PARTITION 41 ENDING AT ('NPM6', 27),
       PARTITION 42 ENDING AT ('NPM9', 53),
       PARTITION 43 ENDING AT ('9999', 53));
--
  LABEL ON TABLE OA1P.twi101A1 IS 'STATUS HISTORY';
--
  LABEL ON OA1P.twi101A1
   (WI101PK IS 'PartitionKey',
    WI10114 IS 'H',
    WI10113 IS 'PH',
    WI10112 IS 'TS_geliefert',
    WI10110 IS 'Notiz',
    WI10109 IS 'Aktuell',
    WI10108 IS 'Statusart',
    WI10107 IS 'Kategorie',
    WI10106 IS 'Kurztext',
    WI10105 IS 'Referenz',
    WI10104 IS 'Betrieb',
    WI10103 IS 'TextArt',
    WI10102S IS 'StatusNr',
    WI10102A IS 'Appl_ID',
    WI10101I IS 'Insert_Time',
    WI10101G IS 'GA_Lfnr',
    WI10101L IS 'Laufnr',
    WI10101D IS 'Datum',
    WI10101T IS 'Terminal');
--
  COMMIT;
--