zOs/JCL/MF15DNIX
set current sqlid = 'S100447';
CREATE INDEX OA1P.IMF150A2
ON OA1P.TMF150A1
(MF150023 ASC,
MF150013 DESC)
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 0 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE NO
COPY NO
define yes defer yes
PIECESIZE 8 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=MF01A1P
-- Index=OA1P.IMF150A3 On OA1P.TMF150A1
------------------------------------------------------------------------
--
CREATE INDEX OA1P.IMF150A3
ON OA1P.TMF150A1
(MF150066 ASC,
MF150013 DESC)
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 0 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE NO
COPY NO
define yes defer yes
PIECESIZE 8 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=MF01A1P
-- Index=OA1P.IMF150A4 On OA1P.TMF150A1
------------------------------------------------------------------------
--
CREATE INDEX OA1P.IMF150A4
ON OA1P.TMF150A1
(MF150067 ASC,
MF150013 DESC,
MF150019 DESC,
MF150066 DESC)
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 0 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE NO
COPY NO
define yes defer yes
PIECESIZE 4 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=MF01A1P
-- Index=OA1P.IMF150A5 On OA1P.TMF150A1
------------------------------------------------------------------------
--
CREATE UNIQUE INDEX OA1P.IMF150A5
ON OA1P.TMF150A1
(MF150004 ASC,
MF150059 ASC,
MF150005 ASC,
MF150013 ASC,
MF150023 ASC)
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 0 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE NO
COPY NO
define yes defer yes
PIECESIZE 8 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=MF01A1P
-- Index=OA1P.IMF150A6 On OA1P.TMF150A1
------------------------------------------------------------------------
--
CREATE INDEX OA1P.IMF150A6
ON OA1P.TMF150A1
(MF150085 ASC,
MF150084 ASC,
MF150060 ASC)
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 0 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE NO
COPY NO
define yes defer yes
PIECESIZE 8 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=MF01A1P
-- Index=OA1P.IMF150A7 On OA1P.TMF150A1
------------------------------------------------------------------------
--
CREATE INDEX OA1P.IMF150A7
ON OA1P.TMF150A1
(MF150084 ASC,
MF150085 ASC,
MF150022 ASC,
MF150023 ASC)
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 0 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE NO
COPY NO
define yes defer yes
PIECESIZE 8 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=MF01A1P
-- Index=OA1P.IMF150A8 On OA1P.TMF150A1
------------------------------------------------------------------------
--
CREATE UNIQUE INDEX OA1P.IMF150A8
ON OA1P.TMF150A1
(MF150023 ASC,
MF150013 ASC,
MF150001 ASC,
MF150019 ASC,
MF150083 ASC)
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 0 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE NO
COPY NO
define yes defer yes
PIECESIZE 8 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=MF01A1P
-- Index=OA1P.IMF150A0 On OA1P.TMF150A1
------------------------------------------------------------------------
--
CREATE UNIQUE INDEX OA1P.IMF150A0
ON OA1P.TMF150A1
(MF150001 ASC)
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 0 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE NO
COPY NO
define yes defer yes
PIECESIZE 8 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=MF01A1P
-- Index=OA1P.IMF150A1 On OA1P.TMF150A1
------------------------------------------------------------------------
--
CREATE INDEX OA1P.IMF150A1
ON OA1P.TMF150A1
(MF150013 ASC,
MF150067 ASC)
PARTITIONED
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
FREEPAGE 0 PCTFREE 10
GBPCACHE CHANGED
CLUSTER
BUFFERPOOL BP1
CLOSE NO
COPY NO
define yes defer yes;
--
COMMIT;
alter TABLE OA1P.TMF150A1
add CONSTRAINT MF150001
PRIMARY KEY (MF150001)
;
COMMIT;
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","OA1P" ;
CREATE VIEW OA1P.VMF150A1V(ID_MITTELFLUSS, RZ_HERKUNFT,
LIEFERANTENTYP, AUFTRAGSNUMMER, STORNO, NACHZUERFASSEN,
ZU_BEWERTEN, BEWEGUNGSART_DEPOT, PRODUKTENR_PROK, MF_PRODUKT,
PRODUKTEKLASSE, BEWEGUNGSVERDICHT, BUCHUNGSDATUM, GRUND,
URHEBER, WAEHRUNG, VALOR, BETRAG_FWHRG, BETRAG_CHF,
MUTATIONSPID, MUTATIONSDATUM, BUID_KUNDE, CIFNUMMER_KUNDE,
PVV_KUNDE, KUNDENART, KUNDENSEGMENT, KUNDENDOMIZIL,
KONTOARTENSCHLUESS, DEPOTARTENSCHLUESS, KUNDEN_BEZIEHUNGNR,
KUNDEN_GMZUSATZ, KUNDENBUERO_KUNDE, KUNDENVERANTWORTL,
BUID_GEGENPARTEI, GEGENPARTEI_TYP, GEGENPARTEI,
CSID_GEGENPARTEI, GP_BEZIEHUNGSNR, GP_GELDMARKTZUSATZ,
HAUPTGRUPPE_GP, UNTERGRUPPE_GP, BESTANDESWAEHRUNG,
BETR_BESTANDESWHRG, VALOREN_SEQUENZNR, GFM_LAUFNUMMER,
DEPOTSTELLE, BUCHUNGSART, DOMIZIL_GP, BEARBEITUNGSCODE,
VOLUMEN_NOM_STCK, LEITWEG, ZU_ABFLUSS, POLICENNUMMER,
AUFTRAGSLAUFNUMMER, ERSTELLUNGSTIMSTMP, COUPON_MANTEL,
MITTELFLUSS_IDENTI, EROEFFNUNGSDATUM, SALDIERUNGSDATUM,
INT_OE_FORM_PID_KV, INT_OE_KUNDENBUERO, INT_OE_KBUERO_GP,
BKST_KUNDENCIF, STAMM_KUNDENCIF, PRUEF_KUNDENCIF,
EDIT_STATUS_GP, EDIT_STATUS_GRUND, EDIT_STATUS_URHEB,
EDIT_STATUS_GESAMT, EDIT_STATUS_KOMMNT, BANKENCLEARING_NR,
VORHERIGER_GP_TYP, DEPOTUEBERTRAG, MUTIERBAR_BIS,
PREISKOMPONENTE, LADE_TIMESTAMP_ID, TRANSACTION_TYP,
RELEVANT_GROUP, LIFE_CYCLE_STATUS, NAME_AUFTRAGGEBER,
ORT_AUFTRAGGEBER, NAME_BEGUENSTIGTER, ORT_BEGUENSTIGTER,
LIMITEN_TYP, LIMITEN_HIERARCHIE, RM_INTERNATIONAL) AS
SELECT ALL OA1P.TMF150A1.MF150001, OA1P.TMF150A1.MF150002,
OA1P.TMF150A1.MF150003, OA1P.TMF150A1.MF150004,
OA1P.TMF150A1.MF150005, OA1P.TMF150A1.MF150006,
OA1P.TMF150A1.MF150007, OA1P.TMF150A1.MF150008,
OA1P.TMF150A1.MF150009, OA1P.TMF150A1.MF150010,
OA1P.TMF150A1.MF150011, OA1P.TMF150A1.MF150012,
OA1P.TMF150A1.MF150013, OA1P.TMF150A1.MF150014,
OA1P.TMF150A1.MF150015, OA1P.TMF150A1.MF150016,
OA1P.TMF150A1.MF150017, OA1P.TMF150A1.MF150018,
OA1P.TMF150A1.MF150019, OA1P.TMF150A1.MF150020,
OA1P.TMF150A1.MF150021, OA1P.TMF150A1.MF150022,
OA1P.TMF150A1.MF150023, OA1P.TMF150A1.MF150024,
OA1P.TMF150A1.MF150025, OA1P.TMF150A1.MF150026,
OA1P.TMF150A1.MF150027, OA1P.TMF150A1.MF150028,
OA1P.TMF150A1.MF150029, OA1P.TMF150A1.MF150030,
OA1P.TMF150A1.MF150031, OA1P.TMF150A1.MF150032,
OA1P.TMF150A1.MF150033, OA1P.TMF150A1.MF150034,
OA1P.TMF150A1.MF150035, OA1P.TMF150A1.MF150036,
OA1P.TMF150A1.MF150037, OA1P.TMF150A1.MF150038,
OA1P.TMF150A1.MF150039, OA1P.TMF150A1.MF150040,
OA1P.TMF150A1.MF150041, OA1P.TMF150A1.MF150042,
OA1P.TMF150A1.MF150043, OA1P.TMF150A1.MF150044,
OA1P.TMF150A1.MF150045, OA1P.TMF150A1.MF150046,
OA1P.TMF150A1.MF150047, OA1P.TMF150A1.MF150051,
OA1P.TMF150A1.MF150052, OA1P.TMF150A1.MF150053,
OA1P.TMF150A1.MF150054, OA1P.TMF150A1.MF150055,
OA1P.TMF150A1.MF150056, OA1P.TMF150A1.MF150059,
OA1P.TMF150A1.MF150060, OA1P.TMF150A1.MF150062,
OA1P.TMF150A1.MF150063, OA1P.TMF150A1.MF150064,
OA1P.TMF150A1.MF150065, OA1P.TMF150A1.MF150066,
OA1P.TMF150A1.MF150067, OA1P.TMF150A1.MF150068,
OA1P.TMF150A1.MF150069, OA1P.TMF150A1.MF150070,
OA1P.TMF150A1.MF150071, OA1P.TMF150A1.MF150072,
OA1P.TMF150A1.MF150073, OA1P.TMF150A1.MF150074,
OA1P.TMF150A1.MF150075, OA1P.TMF150A1.MF150076,
OA1P.TMF150A1.MF150077, OA1P.TMF150A1.MF150078,
OA1P.TMF150A1.MF150079, OA1P.TMF150A1.MF150080,
OA1P.TMF150A1.MF150081, OA1P.TMF150A1.MF150082,
OA1P.TMF150A1.MF150083, OA1P.TMF150A1.MF150084,
OA1P.TMF150A1.MF150085, OA1P.TMF150A1.MF150086,
OA1P.TMF150A1.MF150087, OA1P.TMF150A1.MF150088,
OA1P.TMF150A1.MF150089, OA1P.TMF150A1.MF150090,
OA1P.TMF150A1.MF150091, OA1P.TMF150A1.MF150092
FROM OA1P.TMF150A1 ;