zOs/SQL/WM005
SET CURRENT SQLID='S100447';
drop INDEX oA1t.IWM005AQ ;
------------------------------------------------------------------------
--
CREATE INDEX OA1t.IWM005AQ
ON OA1t.TWM005A1
(CTYP ASC,
NKTO ASC,
NCIF2 ASC,
D$GUEB DESC)
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
COPY NO
defer yes
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
sdf;
drop INDEX oA1P.IWM005AE ;
drop INDEX OA1P.IWM005AA ;
drop INDEX OA1P.IWM005AC ;
drop INDEX OA1P.IWM005AF ;
drop INDEX OA1P.IWM005AG ;
drop INDEX OA1P.IWM005A5 ;
drop INDEX OA1P.IWM005A8 ;
drop INDEX OA1P.IWM005A2 ;
drop INDEX OA1P.IWM005A7 ;
commit;
--
--
------------------------------------------------------------------------
-- Database=WM01A1P
-- Index=OA1P.IWM005A2 On OA1P.TWM005A1
------------------------------------------------------------------------
--
CREATE INDEX OA1P.IWM005A2
ON OA1P.TWM005A1
(NCIF ASC,
NDEP ASC,
CKAT ASC,
CTYP ASC,
D$GUEB DESC)
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
CLUSTER
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
COPY NO
defer yes
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=WM01A1P
-- Index=OA1P.IWM005A5 On OA1P.TWM005A1
------------------------------------------------------------------------
--
CREATE INDEX OA1P.IWM005A5
ON OA1P.TWM005A1
(NDEP ASC,
CTYP ASC,
D$GUEB DESC)
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
COPY NO
defer yes
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=WM01A1P
-- Index=OA1P.IWM005A7 On OA1P.TWM005A1
------------------------------------------------------------------------
--
CREATE INDEX OA1P.IWM005A7
ON OA1P.TWM005A1
(CKAT ASC,
NKTO ASC,
CSTAT ASC,
CDEFAULT ASC,
D$GUEB DESC)
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
COPY NO
defer yes
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=WM01A1P
-- Index=OA1P.IWM005A8 On OA1P.TWM005A1
------------------------------------------------------------------------
--
CREATE INDEX OA1P.IWM005A8
ON OA1P.TWM005A1
(NVALOR ASC,
CTYP ASC,
D$GUEB DESC)
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
COPY NO
defer yes
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=WM01A1P
-- Index=OA1P.IWM005AA On OA1P.TWM005A1
------------------------------------------------------------------------
--
CREATE INDEX OA1P.IWM005AA
ON OA1P.TWM005A1
(NBU ASC,
CKAT ASC,
CTYP ASC,
D$GUEB DESC)
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
COPY NO
defer yes
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=WM01A1P
-- Index=OA1P.IWM005AC On OA1P.TWM005A1
------------------------------------------------------------------------
--
CREATE INDEX OA1P.IWM005AC
ON OA1P.TWM005A1
(CGA ASC,
CGAPH ASC,
CTYP ASC,
D$GUEB DESC)
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
COPY NO
defer yes
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=WM01A1P
-- Index=OA1P.IWM005AE On OA1P.TWM005A1
------------------------------------------------------------------------
--
CREATE INDEX OA1P.IWM005AE
ON OA1P.TWM005A1
(CTYP ASC,
TWMD1 ASC,
TWMD2 ASC,
TWMD3 ASC,
TWMD4 ASC,
TWMD5 ASC,
TWMD6 ASC,
D$GUEB DESC)
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
COPY NO
defer yes
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=WM01A1P
-- Index=OA1P.IWM005AF On OA1P.TWM005A1
------------------------------------------------------------------------
--
CREATE INDEX OA1P.IWM005AF
ON OA1P.TWM005A1
(TWMD1 ASC,
CGA ASC,
CTYP ASC,
D$GUEB DESC)
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
COPY NO
defer yes
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=WM01A1P
-- Index=OA1P.IWM005AG On OA1P.TWM005A1
------------------------------------------------------------------------
--
CREATE INDEX OA1P.IWM005AG
ON OA1P.TWM005A1
(TWMD2 ASC,
TWMD3 ASC,
TWMD4 ASC,
TWMD5 ASC,
CTYP ASC,
D$GUEB DESC)
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
COPY NO
defer yes
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=WM01A1P
-- Index=OA1P.IWM005AQ On OA1P.TWM005A1
--
-- REBIND PACKAGE(A390880.YYWM051.(WSIN000032))
--
-- REBIND PACKAGE(A540769.YYWM51E.(WSIN000101))
--
-- REBIND PACKAGE(HBDTEST.YYWM051.(WSIN000040))
--
-- REBIND PACKAGE(MST.YYWM005.(WSIN000032))
--
-- REBIND PACKAGE(MST.YYWM051.(WSIN000032))
--
-- REBIND PACKAGE(WM.WM0010.(WSIN000100))
--
-- REBIND PACKAGE(WM.WM0010.(WSIN000076))
--
-- REBIND PACKAGE(WM.WM0010.(WSIN000101))
--
-- REBIND PACKAGE(WM.WM0150.(WSIN000042))
--
-- REBIND PACKAGE(WM.WM0150.(WSIN000056))
--
-- REBIND PACKAGE(WM.WM0150.(WSIN000064))
--
-- REBIND PACKAGE(WM.WM8300.(WSIN000092))
--
-- REBIND PACKAGE(WM.WM8300.(WSIN000095))
--
-- REBIND PACKAGE(WM.WM8300.(WSIN000097))
--
-- REBIND PACKAGE(WM.YWMNSUP.(A06M027252))
--
-- REBIND PACKAGE(WM.YWM001.(A06M021462))
--
-- REBIND PACKAGE(WM.YWM001.(A06M023948))
--
-- REBIND PACKAGE(WM.YWM001N.(A06M023948))
--
-- REBIND PACKAGE(WM.YWM005.(A06M022736))
--
-- REBIND PACKAGE(WM.YWM005N.(A06M023948))
--
-- REBIND PACKAGE(WM.YWM006.(A06M022705))
--
-- REBIND PACKAGE(YY.YYWM001.(WSIN000034))
--
-- REBIND PACKAGE(YY.YYWM001.(WSIN000032))
--
-- REBIND PACKAGE(YY.YYWM001.(WSIN000036))
--
-- REBIND PACKAGE(YY.YYWM001.(WSIN000040))
--
-- REBIND PACKAGE(YY.YYWM001.(WSIN000041))
--
-- REBIND PACKAGE(YY.YYWM001.(WSIN000042))
--
-- REBIND PACKAGE(YY.YYWM001.(WSIN000049))
--
-- REBIND PACKAGE(YY.YYWM001.(WSIN000052))
--
-- REBIND PACKAGE(YY.YYWM005.(WSIN000034))
--
-- REBIND PACKAGE(YY.YYWM005.(WSIN000032))
--
-- REBIND PACKAGE(YY.YYWM005.(WSIN000036))
--
-- REBIND PACKAGE(YY.YYWM005.(WSIN000039))
--
-- REBIND PACKAGE(YY.YYWM005.(WSIN000040))
--
-- REBIND PACKAGE(YY.YYWM005.(WSIN000041))
--
-- REBIND PACKAGE(YY.YYWM005.(WSIN000042))
--
-- REBIND PACKAGE(YY.YYWM005.(WSIN000043))
--
-- REBIND PACKAGE(YY.YYWM005.(A18Q002827))
--
-- REBIND PACKAGE(YY.YYWM005.(WSIN000056))
--
-- REBIND PACKAGE(YY.YYWM005.(WSIN000058))
--
-- REBIND PACKAGE(YY.YYWM006.(A06M027252))
--
-- REBIND PACKAGE(YY.YYWM01E.(WSIN000043))
--
-- REBIND PACKAGE(YY.YYWM01E.(WSIN000052))
--
-- REBIND PACKAGE(YY.YYWM01E.(WSIN000066))
--
-- REBIND PACKAGE(YY.YYWM01E.(WSIN000081))
--
-- REBIND PACKAGE(YY.YYWM01E.(WSIN000084))
--
-- REBIND PACKAGE(YY.YYWM01E.(WSIN000086))
--
-- REBIND PACKAGE(YY.YYWM05E.(WSIN000042))
--
-- REBIND PACKAGE(YY.YYWM05E.(PLIH000120))
--
-- REBIND PACKAGE(YY.YYWM05E.(WSIN000043))
--
-- REBIND PACKAGE(YY.YYWM05E.(A18Q002827))
--
-- REBIND PACKAGE(YY.YYWM05E.(WSIN000056))
--
-- REBIND PACKAGE(YY.YYWM05E.(WSIN000058))
--
-- REBIND PACKAGE(YY.YYWM05E.(WSIN000063))
--
-- REBIND PACKAGE(YY.YYWM05E.(WSIN000066))
--
-- REBIND PACKAGE(YY.YYWM05E.(WSIN000067))
--
-- REBIND PACKAGE(YY.YYWM05E.(WSIN000074))
--
-- REBIND PACKAGE(YY.YYWM05E.(WSIN000064))
--
-- REBIND PACKAGE(YY.YYWM05E.(WSIN000077))
--
-- REBIND PACKAGE(YY.YYWM05E.(WSIN000081))
--
-- REBIND PACKAGE(YY.YYWM05E.(WSIN000084))
--
-- REBIND PACKAGE(YY.YYWM05E.(WSIN000086))
--
-- REBIND PACKAGE(YY.YYWM05E.(WSIN000095))
--
-- REBIND PACKAGE(YY.YYWM05E.(WSIN000097))
--
-- REBIND PACKAGE(YY.YYWM05E.(WSIN000101))
--
-- REBIND PACKAGE(YY.YYWM051.(WSIN000023))
--
-- REBIND PACKAGE(YY.YYWM051.(WSIN000032))
--
-- REBIND PACKAGE(YY.YYWM051.(WSIN000036))
--
-- REBIND PACKAGE(YY.YYWM051.(WSIN000039))
--
-- REBIND PACKAGE(YY.YYWM051.(WSIN000040))
--
-- REBIND PACKAGE(YY.YYWM051.(WSIN000041))
--
-- REBIND PACKAGE(YY.YYWM051.(WSIN000042))
--
-- REBIND PACKAGE(YY.YYWM051.(WSIN000043))
--
-- REBIND PACKAGE(YY.YYWM51E.(WSIN000042))
--
-- REBIND PACKAGE(YY.YYWM51E.(WSIN000043))
--
-- REBIND PACKAGE(YY.YYWM51E.(WSIN000063))
--
-- REBIND PACKAGE(YY.YYWM51E.(WSIN000064))
--
-- REBIND PACKAGE(YY.YYWM51E.(WSIN000066))
--
-- REBIND PACKAGE(YY.YYWM51E.(WSIN000081))
--
-- REBIND PACKAGE(YY.YYWM51E.(WSIN000086))
--
-- REBIND PACKAGE(YY.YYWM51E.(WSIN000076))
--
-- REBIND PACKAGE(YY.YYWM51E.(WSIN000092))
--
-- REBIND PACKAGE(YY.YYWM51E.(WSIN000097))
--
-- REBIND PACKAGE(YY.YYWM51E.(WSIN000101))
--
------------------------------------------------------------------------
-- ADB2GEN - End of generated DDL --
------------------------------------------------------------------------
--