zOs/SQL/WI101DIX

  SET CURRENT SQLID='S100447';
  SET CURRENT SCHEMA='OA1P';
------------------------------------------------------------------------
-- Database=WI02A1P
--    Index=OA1P.iwi101A0 On OA1P.twi101A1
------------------------------------------------------------------------
--
--CREATE INDEX OA1P.iwi101A0 -- Dani willst Du den noch????
--  ON OA1P.twi101A1
--   (WI10101T              ASC,
--    WI10102A              ASC,
--    WI10102S              ASC)
--- PARTITIONED
--  USING STOGROUP GSMS
--  not CLUSTER
--  BUFFERPOOL BP1;
--
--COMMIT;
--
------------------------------------------------------------------------
-- Database=WI02A1P
--    Index=OA1P.iwi101A1 On OA1P.twi101A1
------------------------------------------------------------------------
--
  CREATE UNIQUE INDEX OA1P.iwi101A1
    ON OA1P.twi101A1
     (WI10101T              ASC,
      WI10101D              ASC,
      WI10101L              ASC,
      WI10101G              ASC,
      WI10102A              ASC,
      WI10102S              ASC,
      WI10101I              ASC)
    not CLUSTER
    USING STOGROUP GSMS
    FREEPAGE 5 PCTFREE 10
    BUFFERPOOL BP1
    defer yes;
    CLOSE NO;
--
    alter table OA1P.twi101A1
      add CONSTRAINT WI10101T
      PRIMARY KEY (WI10101T,
                   WI10101D,
                   WI10101L,
                   WI10101G,
                   WI10102A,
                   WI10102S,
                   WI10101I);
  COMMIT;
--
------------------------------------------------------------------------
-- Database=WI02A1P
--    Index=OA1P.iwi101A2 On OA1P.twi101A1
------------------------------------------------------------------------
--
--
--
  CREATE INDEX oa1P.iwi101A2
    ON OA1P.twi101A1
     (WI10101T              ASC,
      WI10101D              ASC,
      WI10101L              ASC,
      WI10112               DESC,
      WI10101I              DESC,
      WI10108               ASC,
      WI10101G              ASC,
      WI10101V              ASC,
      WI10101B              ASC,
      WI10102A              ASC,
      WI10102S              ASC,
      WI10104               ASC)
    USING STOGROUP GSMS
    CLUSTER
    FREEPAGE 5 PCTFREE 10
    BUFFERPOOL BP1
    defer yes;
    CLOSE NO;
--
  COMMIT;
--
------------------------------------------------------------------------
-- Database=WI02A1P
--    Index=OA1P.iwi101A3 On OA1P.twi101A1
------------------------------------------------------------------------
--
  CREATE INDEX oa1P.iwi101A3
    ON OA1P.twi101A1
     (WI10102A              ASC,
      WI10102S              ASC,
      WI10101T              ASC,
      WI10101D              ASC,
      WI10101L              ASC,
      WI10101G              ASC,
      WI10101V              ASC,
      WI10101B              ASC)
    USING STOGROUP GSMS
    FREEPAGE 5 PCTFREE 10
    not CLUSTER
    BUFFERPOOL BP1
    defer yes;
    CLOSE NO;
--
  COMMIT;
--
------------------------------------------------------------------------
-- ADB2GEN - End of generated DDL                                     --
------------------------------------------------------------------------
--