zOs/REXX/ELARIDDL
-----------------------------------------------------------------------
-- Database=XBDHA001
-- Index=BUA.IPDHA001 On BUA.XBDHA001PS002001
------------------------------------------------------------------------
--
CREATE UNIQUE INDEX BUA.IPDHA001
ON BUA.XBDHA001PS002001
(EA1STRN ASC,
EN1PART ASC)
-- EN1ENTERTAG ASC, /*SKU PS002 table doesnot have column*/
USING STOGROUP GSMS1
PRIQTY -1 SECQTY -1
ERASE NO
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP20
CLOSE NO
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 8 G;
--
COMMIT;
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Index=BUA.IPDHA002
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Database=XBDHA001
-- Index=BUA.IPDHA002 On BUA.XBDHA001PS002001
------------------------------------------------------------------------
--
CREATE INDEX BUA.IPDHA002
ON BUA.XBDHA001PS002001
(EA1ATRN ASC)
-- en1entertag ASC)/*SKU PS002 table doesnot have column*/
USING STOGROUP GSMS1
PRIQTY -1 SECQTY -1
ERASE NO
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP20
CLOSE NO
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 8 G;
--
COMMIT;
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Index=BUA.IPDHA003
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Database=XBDHA001
-- Index=BUA.IPDHA003 On BUA.XBDHA001IT002001
------------------------------------------------------------------------
--
CREATE UNIQUE INDEX BUA.IPDHA003
ON BUA.XBDHA001IT002001
(EA1STRN ASC,
EN1STK1 ASC,
EN1STK2 ASC,
EN1PART ASC)
USING STOGROUP GSMS1
PRIQTY -1 SECQTY -1
ERASE NO
GBPCACHE CHANGED
CLUSTER
BUFFERPOOL BP20
CLOSE NO
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 8 G;
--
COMMIT;
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Index=BUA.IPDHA004
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Database=XBDHA001
-- Index=BUA.IPDHA004 On BUA.XBDHA001PS001001
------------------------------------------------------------------------
--
CREATE UNIQUE INDEX BUA.IPDHA004
ON BUA.XBDHA001PS001001
(EA1ATRN ASC,
en1entertag ASC,
EN1PART ASC)
USING STOGROUP GSMS1
PRIQTY -1 SECQTY -1
ERASE NO
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP20
CLOSE NO
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 8 G;
--
COMMIT;
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Index=BUA.IPDHA005
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Database=XBDHA001
-- Index=BUA.IPDHA005 On BUA.XBDHA001PS001001
------------------------------------------------------------------------
--
CREATE UNIQUE INDEX BUA.IPDHA005
ON BUA.XBDHA001PS001001
(EN1PAGINATOR ASC,
en1entertag ASC,
EN1PART ASC)
USING STOGROUP GSMS1
PRIQTY -1 SECQTY -1
ERASE NO
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP20
CLOSE NO
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 8 G;
--
COMMIT;
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Index=BUA.IPDHA006
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Database=XBDHA001
-- Index=BUA.IPDHA006 On BUA.XBDHA001PS001001
------------------------------------------------------------------------
--
CREATE INDEX BUA.IPDHA006
ON BUA.XBDHA001PS001001
(EN1CIF ASC,
en1entertag ASC,
ET1LOGPROD ASC)
USING STOGROUP GSMS1
PRIQTY -1 SECQTY -1
ERASE NO
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP20
CLOSE NO
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 8 G;
--
COMMIT;
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Index=BUA.IPDHA007
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Database=XBDHA001
-- Index=BUA.IPDHA007 On BUA.XBDHA001PS001001
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Index=BUA.IPDHA008
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Database=XBDHA001
-- Index=BUA.IPDHA008 On BUA.XBDHA001PS001001
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Index=BUA.IPDHA009
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Database=XBDHA001
-- Index=BUA.IPDHA009 On BUA.XBDHA001PS001001
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Index=BUA.IPDHA010
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Database=XBDHA001
-- Index=BUA.IPDHA010 On BUA.XBDHA001PS001001
------------------------------------------------------------------------
--
CREATE INDEX BUA.IPDHA010
ON BUA.XBDHA001PS001001
(EA1BEZNR ASC,
en1entertag ASC,
ET1LOGPROD ASC)
USING STOGROUP GSMS1
PRIQTY -1 SECQTY -1
ERASE NO
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP20
CLOSE NO
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 8 G;
--
COMMIT;
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Index=BUA.IPDHA011
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Database=XBDHA001
-- Index=BUA.IPDHA011 On BUA.XBDHA001PS001001
------------------------------------------------------------------------
--
CREATE INDEX BUA.IPDHA011
ON BUA.XBDHA001PS001001
(EA1KNAME ASC,
en1entertag ASC,
ET1LOGPROD ASC)
USING STOGROUP GSMS1
PRIQTY -1 SECQTY -1
ERASE NO
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP20
CLOSE NO
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 8 G;
--
COMMIT;
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Index=BUA.IPDHA012
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Database=XBDHA001
-- Index=BUA.IPDHA012 On BUA.XBDHA001PS001001
------------------------------------------------------------------------
--
CREATE INDEX BUA.IPDHA012
ON BUA.XBDHA001PS001001
(EB1WERT1 ASC,
en1entertag ASC,
ET1LOGPROD ASC)
USING STOGROUP GSMS1
PRIQTY -1 SECQTY -1
ERASE NO
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP20
CLOSE NO
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 8 G;
--
COMMIT;
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Index=BUA.IPDHY001
-- --
------------------------------------------------------------------------
--
--
------------------------------------------------------------------------
-- Stogroup=GSMS4
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Database=XBDHY001
-- Index=BUA.IPDHY001 On BUA.XBDHY001PS002001
------------------------------------------------------------------------
--
CREATE UNIQUE INDEX BUA.IPDHY001
ON BUA.XBDHY001PS002001
(EA1STRN ASC,
-- en1entertag ASC, does not exist |||
EN1PART ASC)
USING STOGROUP GSMS4
PRIQTY -1 SECQTY -1
ERASE NO
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP20
CLOSE NO
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 8 G;
--
COMMIT;
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Index=BUA.IPDHY002
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Database=XBDHY001
-- Index=BUA.IPDHY002 On BUA.XBDHY001PS002001
------------------------------------------------------------------------
--
CREATE INDEX BUA.IPDHY002
ON BUA.XBDHY001PS002001
(EA1ATRN ASC)
-- en1entertag ASC) does not exist |||
USING STOGROUP GSMS4
PRIQTY -1 SECQTY -1
ERASE NO
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP20
CLOSE NO
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 8 G;
--
COMMIT;
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Index=BUA.IPDHY003
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Database=XBDHY001
-- Index=BUA.IPDHY003 On BUA.XBDHY001IT002001
------------------------------------------------------------------------
--
CREATE UNIQUE INDEX BUA.IPDHY003
ON BUA.XBDHY001IT002001
(EA1STRN ASC,
EN1STK1 ASC,
EN1STK2 ASC,
-- en1entertag ASC, does not exist |||
EN1Part ASC)
USING STOGROUP GSMS4
PRIQTY -1 SECQTY -1
ERASE NO
GBPCACHE CHANGED
CLUSTER
BUFFERPOOL BP20
CLOSE NO
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 8 G;
--
COMMIT;
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Index=BUA.IPDHY004
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Database=XBDHY001
-- Index=BUA.IPDHY004 On BUA.XBDHY001PS001001
------------------------------------------------------------------------
--
CREATE UNIQUE INDEX BUA.IPDHY004
ON BUA.XBDHY001PS001001
(EA1ATRN ASC,
en1entertag ASC,
EN1PART ASC)
USING STOGROUP GSMS4
PRIQTY -1 SECQTY -1
ERASE NO
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP20
CLOSE NO
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 8 G;
--
COMMIT;
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Index=BUA.IPDHY005
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Database=XBDHY001
-- Index=BUA.IPDHY005 On BUA.XBDHY001PS001001
------------------------------------------------------------------------
--
CREATE UNIQUE INDEX BUA.IPDHY005
ON BUA.XBDHY001PS001001
(EN1PAGINATOR ASC,
en1entertag ASC,
EN1PART ASC)
USING STOGROUP GSMS4
PRIQTY -1 SECQTY -1
ERASE NO
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP20
CLOSE NO
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 8 G;
--
COMMIT;
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Index=BUA.IPDHY006
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Database=XBDHY001
-- Index=BUA.IPDHY006 On BUA.XBDHY001PS001001
------------------------------------------------------------------------
--
CREATE INDEX BUA.IPDHY006
ON BUA.XBDHY001PS001001
(EN1CIF ASC,
en1entertag ASC,
ET1LOGPROD ASC)
USING STOGROUP GSMS4
PRIQTY -1 SECQTY -1
ERASE NO
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP20
CLOSE NO
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 8 G;
--
COMMIT;
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Index=BUA.IPDHY007
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Database=XBDHY001
-- Index=BUA.IPDHY007 On BUA.XBDHY001PS001001
------------------------------------------------------------------------
--
CREATE INDEX BUA.IPDHY007
ON BUA.XBDHY001PS001001
(EN1CIF ASC,
en1entertag ASC)
USING STOGROUP GSMS4
PRIQTY -1 SECQTY -1
ERASE NO
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP20
CLOSE NO
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 8 G;
--
COMMIT;
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Index=BUA.IPDHY008
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Database=XBDHY001
-- Index=BUA.IPDHY008 On BUA.XBDHY001PS001001
------------------------------------------------------------------------
--
CREATE INDEX BUA.IPDHY008
ON BUA.XBDHY001PS001001
(EA1BEZNR ASC,
en1entertag ASC)
USING STOGROUP GSMS4
PRIQTY -1 SECQTY -1
ERASE NO
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP20
CLOSE NO
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 8 G;
--
COMMIT;
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Index=BUA.IPDHY009
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Database=XBDHY001
-- Index=BUA.IPDHY009 On BUA.XBDHY001PS001001
------------------------------------------------------------------------
--
CREATE INDEX BUA.IPDHY009
ON BUA.XBDHY001PS001001
(EA1KNAME ASC,
en1entertag ASC)
USING STOGROUP GSMS4
PRIQTY -1 SECQTY -1
ERASE NO
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP20
CLOSE NO
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 8 G;
--
COMMIT;
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Index=BUA.IPDHY010
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Database=XBDHY001
-- Index=BUA.IPDHY010 On BUA.XBDHY001PS001001
------------------------------------------------------------------------
--
CREATE INDEX BUA.IPDHY010
ON BUA.XBDHY001PS001001
(EA1BEZNR ASC,
EN1ENTERTAG ASC,
ET1LOGPROD ASC)
USING STOGROUP GSMS4
PRIQTY -1 SECQTY -1
ERASE NO
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP20
CLOSE NO
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 8 G;
--
COMMIT;
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Index=BUA.IPDHY011
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Database=XBDHY001
-- Index=BUA.IPDHY011 On BUA.XBDHY001PS001001
------------------------------------------------------------------------
--
CREATE INDEX BUA.IPDHY011
ON BUA.XBDHY001PS001001
(EA1KNAME ASC,
EN1ENTERTAG ASC,
ET1LOGPROD ASC)
USING STOGROUP GSMS4
PRIQTY -1 SECQTY -1
ERASE NO
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP20
CLOSE NO
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 8 G;
--
COMMIT;
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Index=BUA.IPDHY012
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Database=XBDHY001
-- Index=BUA.IPDHY012 On BUA.XBDHY001PS001001
------------------------------------------------------------------------
--
CREATE INDEX BUA.IPDHY012
ON BUA.XBDHY001PS001001
(EB1WERT1 ASC,
EN1ENTERTAG ASC,
ET1LOGPROD ASC)
USING STOGROUP GSMS4
PRIQTY -1 SECQTY -1
ERASE NO
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP20
CLOSE NO
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 8 G;
--
COMMIT;
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Index=BUA.IPEHL001
-- --
------------------------------------------------------------------------
--
--
------------------------------------------------------------------------
-- Stogroup=GSMS3
------------------------------------------------------------------------
------------------------------------------------------------------------
-- Database=XBEHL001
-- Index=BUA.IPEHL001 On BUA.XBEHL001PS002001
------------------------------------------------------------------------
--
CREATE INDEX BUA.IPEHL001
ON BUA.XBEHL001PS002001
(EA1ATRN ASC,
en1entertag ASC)
USING STOGROUP GSMS3
PRIQTY -1 SECQTY -1
ERASE NO
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP20
CLOSE NO
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 8 G;
--
COMMIT;
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Index=BUA.IPEHL002
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Database=XBEHL001
-- Index=BUA.IPEHL002 On BUA.XBEHL001PS002001
------------------------------------------------------------------------
--
CREATE UNIQUE INDEX BUA.IPEHL002
ON BUA.XBEHL001PS002001
(EA1STRN ASC,
en1entertag ASC,
EN1PART ASC)
USING STOGROUP GSMS3
PRIQTY -1 SECQTY -1
ERASE NO
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP20
CLOSE NO
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 8 G;
--
COMMIT;
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Index=BUA.IPEHL003
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Database=XBEHL001
-- Index=BUA.IPEHL003 On BUA.XBEHL001IT002001
------------------------------------------------------------------------
--
CREATE UNIQUE INDEX BUA.IPEHL003
ON BUA.XBEHL001IT002001
(EA1STRN ASC,
EN1STK1 ASC,
EN1STK2 ASC,
en1entertag ASC,
EN1PART ASC)
USING STOGROUP GSMS3
PRIQTY -1 SECQTY -1
ERASE NO
GBPCACHE CHANGED
CLUSTER
BUFFERPOOL BP20
CLOSE NO
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 8 G;
--
COMMIT;
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Index=BUA.IPEHL004
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Database=XBEHL001
-- Index=BUA.IPEHL004 On BUA.XBEHL001PS001001
------------------------------------------------------------------------
--
CREATE INDEX BUA.IPEHL004
ON BUA.XBEHL001PS001001
(EA1ANUM ASC,
EN1VALOR ASC,
en1entertag ASC,
ET1LOGPROD ASC)
USING STOGROUP GSMS3
PRIQTY -1 SECQTY -1
ERASE NO
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP20
CLOSE NO
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 8 G;
--
COMMIT;
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Index=BUA.IPEHL005
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Database=XBEHL001
-- Index=BUA.IPEHL005 On BUA.XBEHL001PS001001
------------------------------------------------------------------------
--
CREATE INDEX BUA.IPEHL005
ON BUA.XBEHL001PS001001
(EN1VALOR ASC,
en1entertag ASC,
ET1LOGPROD ASC)
USING STOGROUP GSMS3
PRIQTY -1 SECQTY -1
ERASE NO
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP20
CLOSE NO
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 8 G;
--
COMMIT;
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Index=BUA.IPEHL006
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Database=XBEHL001
-- Index=BUA.IPEHL006 On BUA.XBEHL001PS001001
------------------------------------------------------------------------
--
CREATE UNIQUE INDEX BUA.IPEHL006
ON BUA.XBEHL001PS001001
(EA1ANUM ASC,
EA1TEILAUSF ASC,
en1entertag ASC,
EN1PART ASC)
USING STOGROUP GSMS3
PRIQTY -1 SECQTY -1
ERASE NO
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP20
CLOSE NO
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 8 G;
--
COMMIT;
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Index=BUA.IPEHL007
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Database=XBEHL001
-- Index=BUA.IPEHL007 On BUA.XBEHL001PS001001
------------------------------------------------------------------------
--
CREATE UNIQUE INDEX BUA.IPEHL007
ON BUA.XBEHL001PS001001
(EA1ATRN ASC,
en1entertag ASC,
EN1PART ASC)
USING STOGROUP GSMS3
PRIQTY -1 SECQTY -1
ERASE NO
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP20
CLOSE NO
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 8 G;
--
COMMIT;
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Index=BUA.IPDJW001
-- --
------------------------------------------------------------------------
--
--
------------------------------------------------------------------------
-- Stogroup=GSMS2
------------------------------------------------------------------------
------------------------------------------------------------------------
-- Database=XBDJW001
-- Index=BUA.IPDJW001 On BUA.XBDJW001PS002001
------------------------------------------------------------------------
--
CREATE UNIQUE INDEX BUA.IPDJW001
ON BUA.XBDJW001PS002001
(EA1STRN ASC,
-- en1entertag ASC, does not exist |||
EN1PART ASC)
USING STOGROUP GSMS2
PRIQTY -1 SECQTY -1
ERASE NO
GBPCACHE CHANGED
CLUSTER
BUFFERPOOL BP20
CLOSE NO
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 8 G;
--
COMMIT;
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Index=BUA.IPDJW002
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Database=XBDJW001
-- Index=BUA.IPDJW002 On BUA.XBDJW001PS002001
------------------------------------------------------------------------
--
CREATE INDEX BUA.IPDJW002
ON BUA.XBDJW001PS002001
(EA1ATRN ASC)
-- en1entertag ASC) does not exist |||
USING STOGROUP GSMS2
PRIQTY -1 SECQTY -1
ERASE NO
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP20
CLOSE NO
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 8 G;
--
COMMIT;
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Index=BUA.IPDJW003
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Database=XBDJW001
-- Index=BUA.IPDJW003 On BUA.XBDJW001IT002001
------------------------------------------------------------------------
--
CREATE UNIQUE INDEX BUA.IPDJW003
ON BUA.XBDJW001IT002001
(EA1STRN ASC,
EN1STK1 ASC,
EN1STK2 ASC,
-- en1entertag ASC, does not exist ||||
EN1PART ASC)
USING STOGROUP GSMS2
PRIQTY -1 SECQTY -1
ERASE NO
GBPCACHE CHANGED
CLUSTER
BUFFERPOOL BP20
CLOSE NO
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 8 G;
--
COMMIT;
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Index=BUA.IPDJW004
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Database=XBDJW001
-- Index=BUA.IPDJW004 On BUA.XBDJW001PS001001
------------------------------------------------------------------------
--
CREATE UNIQUE INDEX BUA.IPDJW004
ON BUA.XBDJW001PS001001
(EA1ATRN ASC,
en1entertag ASC,
EN1PART ASC)
USING STOGROUP GSMS2
PRIQTY -1 SECQTY -1
ERASE NO
GBPCACHE CHANGED
CLUSTER
BUFFERPOOL BP20
CLOSE NO
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 8 G;
--
COMMIT;
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Index=BUA.IPDJW005
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Database=XBDJW001
-- Index=BUA.IPDJW005 On BUA.XBDJW001PS001001
------------------------------------------------------------------------
--
CREATE UNIQUE INDEX BUA.IPDJW005
ON BUA.XBDJW001PS001001
(EN1ENTERTAG ASC,
EA1SWVERSION ASC,
EA1FNAME ASC,
EA1SYSTEM ASC,
ET1LOGPROD ASC,
EN1PART ASC)
USING STOGROUP GSMS2
PRIQTY -1 SECQTY -1
ERASE NO
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP20
CLOSE NO
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 8 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- Index von Uwe 1.9.10 --
------------------------------------------------------------------------
--
CREATE INDEX BUA.IDRWPS001 -- ??? dups in pta
ON BUA.XBDRW001PS001001
( EA1IMATCHDB ASC, ---uwe9.9
EB1POSTENNUMMER ASC,
EB1MATCHID ASC,
ED1DATUMABGL ASC,
EN1ENTERTAG ASC,
ET1LOGPROD ASC ---uwe9.9
) --,EN1PART ASC)
USING STOGROUP GSMS2
PRIQTY -1 SECQTY -1
ERASE NO
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP20
CLOSE NO
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 8 G;
--
COMMIT;
--
CREATE INDEX BUA.IDRWPS002
ON BUA.XBDRW001PS001001
(EN1ENTERTAG ASC,
EN1KONTO ASC)
USING STOGROUP GSMS2
PRIQTY -1 SECQTY -1
ERASE NO
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP20
CLOSE NO
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 8 G;
--
COMMIT;
CREATE INDEX BUA.IDRWPS003
ON BUA.XBDRW001PS001001
( EB1AMOUNT ASC ,
EN1ENTERTAG ASC)
USING STOGROUP GSMS2
PRIQTY -1 SECQTY -1
ERASE NO
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP20
CLOSE NO
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 8 G;
--
COMMIT;
--
CREATE INDEX BUA.IDRWPS004
ON BUA.XBDRW001PS001001
(ED1VALUTA ASC ,
EN1ENTERTAG ASC)
USING STOGROUP GSMS2
PRIQTY -1 SECQTY -1
ERASE NO
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP20
CLOSE NO
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 8 G;
--
COMMIT;
--
CREATE INDEX BUA.IDRWPS005
ON BUA.XBDRW001PS001001
(EA1BUCHREF ASC,
EN1ENTERTAG ASC)
USING STOGROUP GSMS2
PRIQTY -1 SECQTY -1
ERASE NO
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP20
CLOSE NO
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 8 G;
--
COMMIT;
--
CREATE INDEX BUA.IDRWIT001
ON BUA.XBDRW001IT002001
(EA1STRN ASC,
EN1STK1 ASC,
EN1STK2 ASC)
USING STOGROUP GSMS2
PRIQTY -1 SECQTY -1
ERASE NO
GBPCACHE CHANGED
not CLUSTER --||| already has clustering index
BUFFERPOOL BP20
CLOSE NO
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 8 G;
--
COMMIT;
--