zOs/JCL/PLOADTEO
//A540769D JOB (CP00,KE50), 00010001
// MSGCLASS=T,TIME=1440,
// NOTIFY=A540769
//*MAIN CLASS=LOG
//S01 EXEC PGM=IKJEFT01,DYNAMNBR=200,TIME=99 00020001
//SYSTSIN DD *
DSN SYSTEM(DBAF)
RUN PROGRAM(DSNTEP2) PARMS('ALIGN(LHS)') PLAN(DSNTEP2)
//SYSTSPRT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSTERM DD DUMMY
//SYSIN DD *
set current sqlId = 's100447';
--
------------------------------------------------------------------------
-- TWK811X1 is a clone of TMF200A1
------------------------------------------------------------------------
--
CREATE TABLESPACE A811X
IN DA540769
USING STOGROUP GSMS
PRIQTY 48 SECQTY 7200
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
TRACKMOD YES
NUMPARTS 32
(PART 16 FREEPAGE 0 PCTFREE 5)
BUFFERPOOL BP2
LOCKSIZE ANY
LOCKMAX SYSTEM
CLOSE YES
COMPRESS YES
CCSID EBCDIC
DEFINE YES
MAXROWS 255;
--
------------------------------------------------------------------------
-- Table=oa1a.Twk811X1 In DA540769.A811X
------------------------------------------------------------------------
--
CREATE TABLE oa1a.Twk811X1
(MF200001 CHAR(16) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200002 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200003 CHAR(5) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200004 CHAR(25) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200005 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200006 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200007 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200008 CHAR(3) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200009 CHAR(5) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200010 CHAR(4) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200011 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200012 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200013 DATE NOT NULL WITH DEFAULT,
MF200014 CHAR(4) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200015 CHAR(4) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200016 CHAR(4) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200017 CHAR(12) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200018 DECIMAL(15, 3) NOT NULL WITH DEFAULT,
MF200019 DECIMAL(15, 3) NOT NULL WITH DEFAULT,
MF200020 CHAR(8) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200021 TIMESTAMP NOT NULL WITH DEFAULT,
MF200022 CHAR(4) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200023 CHAR(12) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200024 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200025 CHAR(3) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200026 CHAR(3) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200027 CHAR(3) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200028 CHAR(3) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200029 CHAR(3) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200030 CHAR(16) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200031 CHAR(2) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200032 CHAR(7) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200033 CHAR(7) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200034 CHAR(4) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200035 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200036 CHAR(18) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200037 DECIMAL(15, 0) NOT NULL WITH DEFAULT,
MF200038 CHAR(16) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200039 CHAR(2) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200040 CHAR(2) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200041 CHAR(2) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200042 CHAR(4) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200043 DECIMAL(15, 3) NOT NULL WITH DEFAULT,
MF200044 CHAR(5) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200045 CHAR(4) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200046 CHAR(4) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200047 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200051 CHAR(3) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200052 CHAR(3) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200053 DECIMAL(15, 3) NOT NULL WITH DEFAULT,
MF200054 CHAR(7) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200055 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200056 CHAR(8) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200059 CHAR(5) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200060 TIMESTAMP NOT NULL WITH DEFAULT,
MF200062 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200063 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200064 DATE NOT NULL WITH DEFAULT,
MF200065 DATE NOT NULL WITH DEFAULT,
MF200066 CHAR(16) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200067 CHAR(16) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200068 CHAR(16) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200069 CHAR(4) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200070 CHAR(7) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200071 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200072 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200073 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200074 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200075 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200076 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200077 CHAR(6) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200078 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200079 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200080 DATE NOT NULL WITH DEFAULT,
MF200081 CHAR(5) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200082 CHAR(26) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200083 SMALLINT NOT NULL WITH DEFAULT,
MF200084 SMALLINT NOT NULL WITH DEFAULT,
MF200085 SMALLINT NOT NULL WITH DEFAULT,
MF200086 CHAR(35) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200087 CHAR(35) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200088 CHAR(35) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200089 CHAR(35) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200090 SMALLINT NOT NULL WITH DEFAULT,
MF200091 SMALLINT NOT NULL WITH DEFAULT,
MF200092 CHAR(16) FOR SBCS DATA NOT NULL
WITH DEFAULT,
CONSTRAINT MF200001
PRIMARY KEY (MF200001))
IN DA540769.A811X
AUDIT NONE
DATA CAPTURE NONE
CCSID EBCDIC
NOT VOLATILE;
--
------------------------------------------------------------------------
-- Database=DA540769
-- Index=oa1a.Iwk811X6 On oa1a.Twk811X1
------------------------------------------------------------------------
--
CREATE INDEX oa1a.Iwk811X6
ON oa1a.Twk811X1
(MF200092 ASC,
MF200085 ASC,
MF200013 DESC)
USING STOGROUP GSMS
PRIQTY 48 SECQTY 7200
ERASE NO
FREEPAGE 0 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFINE YES
PIECESIZE 2 G;
--
------------------------------------------------------------------------
-- Database=DA540769
-- Index=oa1a.Iwk811X5 On oa1a.Twk811X1
------------------------------------------------------------------------
--
CREATE INDEX oa1a.Iwk811X5
ON oa1a.Twk811X1
(MF200085 ASC,
MF200084 ASC)
USING STOGROUP GSMS
PRIQTY 48 SECQTY 7200
ERASE NO
FREEPAGE 0 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFINE YES
PIECESIZE 1 M;
--
------------------------------------------------------------------------
-- Database=DA540769
-- Index=oa1a.Iwk811X4 On oa1a.Twk811X1
------------------------------------------------------------------------
--
CREATE INDEX oa1a.Iwk811X4
ON oa1a.Twk811X1
(MF200066 ASC,
MF200085 ASC,
MF200013 DESC)
USING STOGROUP GSMS
PRIQTY 48 SECQTY 7200
ERASE NO
FREEPAGE 0 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFINE YES
PIECESIZE 8 M;
--
------------------------------------------------------------------------
-- Database=DA540769
-- Index=oa1a.Iwk811X3 On oa1a.Twk811X1
------------------------------------------------------------------------
--
CREATE INDEX oa1a.Iwk811X3
ON oa1a.Twk811X1
(MF200023 ASC,
MF200085 ASC,
MF200013 DESC)
USING STOGROUP GSMS
PRIQTY 48 SECQTY 7200
ERASE NO
FREEPAGE 0 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFINE YES
PIECESIZE 2 M;
--
------------------------------------------------------------------------
-- Database=DA540769
-- Index=oa1a.Iwk811X2 On oa1a.Twk811X1
------------------------------------------------------------------------
--
CREATE INDEX oa1a.Iwk811X2
ON oa1a.Twk811X1
(MF200067 ASC,
MF200085 ASC,
MF200013 DESC)
USING STOGROUP GSMS
PRIQTY 48 SECQTY 7200
ERASE NO
FREEPAGE 0 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFINE YES
PIECESIZE 1 M;
--
------------------------------------------------------------------------
-- Database=DA540769
-- Index=oa1a.Iwk811X0 On oa1a.Twk811X1
------------------------------------------------------------------------
--
CREATE UNIQUE INDEX oa1a.Iwk811X0
ON oa1a.Twk811X1
(MF200001 ASC)
USING STOGROUP GSMS
PRIQTY 48 SECQTY 7200
ERASE NO
FREEPAGE 0 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFINE YES
PIECESIZE 2 M;
--
------------------------------------------------------------------------
-- Database=DA540769
-- Index=oa1a.Iwk811X1 On oa1a.Twk811X1
------------------------------------------------------------------------
--
CREATE INDEX oa1a.Iwk811X1
ON oa1a.Twk811X1
(MF200067 ASC,
MF200013 DESC)
USING STOGROUP GSMS
PRIQTY 48 SECQTY 7200
FREEPAGE 0 PCTFREE 10
GBPCACHE CHANGED
CLUSTER
(PART 1 VALUES('0010ZZZZZZZZ9999'),
PART 2 VALUES('0011BACOBACO1299'),
PART 3 VALUES('0011BACOBACO1399'),
PART 4 VALUES('0011BACOBACO1599'),
PART 5 VALUES('0011BACOBACO1699'),
PART 6 VALUES('0011BACOBACO1799'),
PART 7 VALUES('0011BACOBACO2299'),
PART 8 VALUES('0011BACOBACO2599'),
PART 9 VALUES('0011BACOBACO2799'),
PART 10 VALUES('0011BAHEBAHE9999'),
PART 11 VALUES('0011BAHTBAHT9999'),
PART 12 VALUES('0011BCMBBCMB9999'),
PART 13 VALUES('0011BCMSBCMS9999'),
PART 14 VALUES('0011BCRFBCRF9999'),
PART 15 VALUES('0011BCTLBCTL9999'),
PART 16 VALUES('0011BCZTBCZT9999'),
PART 17 VALUES('0011BCZWBCZW9999'),
PART 18 VALUES('0011BDNUBDNU9999'),
PART 19 VALUES('0011BGBABGBA9999'),
PART 20 VALUES('0011CKZFCKZF9999'),
PART 21 VALUES('0012PZZZPZZZ9999'),
PART 22 VALUES('0012SCNNSCNN9999'),
PART 23 VALUES('0012SCRRSCRR9999'),
PART 24 VALUES('0012SCZSSCZS9999'),
PART 25 VALUES('0012SWESSWES9999'),
PART 26 VALUES('0012SWLNSWLN9999'),
PART 27 VALUES('0013ZZZZZZZZ9999'),
PART 28 VALUES('0014ZZZZZZZZ9999'),
PART 29 VALUES('0015NCZZNCZZ9999'),
PART 30 VALUES('0015NZZZNZZZ9999'),
PART 31 VALUES('0020ZZZZZZZZ9999'),
PART 32 VALUES('9999ZZZZZZZZ9999'))
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFINE YES;
--
------------------------------------------------------------------------
-- View=oa1a.Vwk811X1V
------------------------------------------------------------------------
--
--
CREATE VIEW oa1a.Vwk811X1V(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 oa1a.Twk811X1.MF200001, oa1a.Twk811X1.MF200002,
oa1a.Twk811X1.MF200003, oa1a.Twk811X1.MF200004,
oa1a.Twk811X1.MF200005, oa1a.Twk811X1.MF200006,
oa1a.Twk811X1.MF200007, oa1a.Twk811X1.MF200008,
oa1a.Twk811X1.MF200009, oa1a.Twk811X1.MF200010,
oa1a.Twk811X1.MF200011, oa1a.Twk811X1.MF200012,
oa1a.Twk811X1.MF200013, oa1a.Twk811X1.MF200014,
oa1a.Twk811X1.MF200015, oa1a.Twk811X1.MF200016,
oa1a.Twk811X1.MF200017, oa1a.Twk811X1.MF200018,
oa1a.Twk811X1.MF200019, oa1a.Twk811X1.MF200020,
oa1a.Twk811X1.MF200021, oa1a.Twk811X1.MF200022,
oa1a.Twk811X1.MF200023, oa1a.Twk811X1.MF200024,
oa1a.Twk811X1.MF200025, oa1a.Twk811X1.MF200026,
oa1a.Twk811X1.MF200027, oa1a.Twk811X1.MF200028,
oa1a.Twk811X1.MF200029, oa1a.Twk811X1.MF200030,
oa1a.Twk811X1.MF200031, oa1a.Twk811X1.MF200032,
oa1a.Twk811X1.MF200033, oa1a.Twk811X1.MF200034,
oa1a.Twk811X1.MF200035, oa1a.Twk811X1.MF200036,
oa1a.Twk811X1.MF200037, oa1a.Twk811X1.MF200038,
oa1a.Twk811X1.MF200039, oa1a.Twk811X1.MF200040,
oa1a.Twk811X1.MF200041, oa1a.Twk811X1.MF200042,
oa1a.Twk811X1.MF200043, oa1a.Twk811X1.MF200044,
oa1a.Twk811X1.MF200045, oa1a.Twk811X1.MF200046,
oa1a.Twk811X1.MF200047, oa1a.Twk811X1.MF200051,
oa1a.Twk811X1.MF200052, oa1a.Twk811X1.MF200053,
oa1a.Twk811X1.MF200054, oa1a.Twk811X1.MF200055,
oa1a.Twk811X1.MF200056, oa1a.Twk811X1.MF200059,
oa1a.Twk811X1.MF200060, oa1a.Twk811X1.MF200062,
oa1a.Twk811X1.MF200063, oa1a.Twk811X1.MF200064,
oa1a.Twk811X1.MF200065, oa1a.Twk811X1.MF200066,
oa1a.Twk811X1.MF200067, oa1a.Twk811X1.MF200068,
oa1a.Twk811X1.MF200069, oa1a.Twk811X1.MF200070,
oa1a.Twk811X1.MF200071, oa1a.Twk811X1.MF200072,
oa1a.Twk811X1.MF200073, oa1a.Twk811X1.MF200074,
oa1a.Twk811X1.MF200075, oa1a.Twk811X1.MF200076,
oa1a.Twk811X1.MF200077, oa1a.Twk811X1.MF200078,
oa1a.Twk811X1.MF200079, oa1a.Twk811X1.MF200080,
oa1a.Twk811X1.MF200081, oa1a.Twk811X1.MF200082,
oa1a.Twk811X1.MF200083, oa1a.Twk811X1.MF200084,
oa1a.Twk811X1.MF200085, oa1a.Twk811X1.MF200086,
oa1a.Twk811X1.MF200087, oa1a.Twk811X1.MF200088,
oa1a.Twk811X1.MF200089, oa1a.Twk811X1.MF200090,
oa1a.Twk811X1.MF200091, oa1a.Twk811X1.MF200092
FROM oa1a.Twk811X1 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- ADB2GEN - End of generated DDL --
------------------------------------------------------------------------
--