zOs/TX/WK936DDL
------------$-{right(userid() sysvar(sysnode) date(s) time(), 60, '-')}
-- testCase $dsn
-- env $env phase $phase
-- subsys $subsys db $db creator $creator
------------------------------------------------------------------------
---||| begin ddl testcase $mbr env $env phase $phase
SET CURRENT SQLID='S100447';
drop tablespace $db.a936H;
commit;
CREATE LARGE TABLESPACE A936H
IN $db
USING STOGROUP GSMS
PRIQTY 12 SECQTY 7200
FREEPAGE 0 PCTFREE 0
GBPCACHE CHANGED
TRACKMOD YES
NUMPARTS $parts
BUFFERPOOL BP2
LOCKSIZE ANY
LOCKMAX SYSTEM
CLOSE YES
COMPRESS YES
CCSID EBCDIC
LOCKPART YES
DEFINE YES
MAXROWS 255;
commit;
CREATE TABLE $creator.Twk936
(MF150001 CHAR(16) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150002 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150003 CHAR(5) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150004 CHAR(25) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150005 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150006 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150007 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150008 CHAR(3) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150009 CHAR(5) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150010 CHAR(4) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150011 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150012 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150013 DATE NOT NULL WITH DEFAULT,
MF150014 CHAR(4) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150015 CHAR(4) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150016 CHAR(4) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150017 CHAR(12) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150018 DECIMAL(15, 3) NOT NULL WITH DEFAULT,
MF150019 DECIMAL(15, 3) NOT NULL WITH DEFAULT,
MF150020 CHAR(8) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150021 TIMESTAMP NOT NULL WITH DEFAULT,
MF150022 CHAR(4) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150023 CHAR(12) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150024 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150025 CHAR(3) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150026 CHAR(3) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150027 CHAR(3) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150028 CHAR(3) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150029 CHAR(3) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150030 CHAR(16) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150031 CHAR(2) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150032 CHAR(7) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150033 CHAR(7) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150034 CHAR(4) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150035 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150036 CHAR(18) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150037 DECIMAL(15, 0) NOT NULL WITH DEFAULT,
MF150038 CHAR(16) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150039 CHAR(2) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150040 CHAR(2) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150041 CHAR(2) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150042 CHAR(4) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150043 DECIMAL(15, 3) NOT NULL WITH DEFAULT,
MF150044 CHAR(5) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150045 CHAR(4) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150046 CHAR(4) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150047 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150051 CHAR(3) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150052 CHAR(3) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150053 DECIMAL(15, 3) NOT NULL WITH DEFAULT,
MF150054 CHAR(7) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150055 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150056 CHAR(8) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150059 CHAR(5) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150060 TIMESTAMP NOT NULL WITH DEFAULT,
MF150062 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150063 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150064 DATE NOT NULL WITH DEFAULT,
MF150065 DATE NOT NULL WITH DEFAULT,
MF150066 CHAR(16) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150067 CHAR(16) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150068 CHAR(16) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150069 CHAR(4) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150070 CHAR(7) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150071 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150072 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150073 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150074 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150075 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150076 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150077 CHAR(6) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150078 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150079 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150080 DATE NOT NULL WITH DEFAULT,
MF150081 CHAR(5) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150082 CHAR(26) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150083 SMALLINT NOT NULL WITH DEFAULT,
MF150084 SMALLINT NOT NULL WITH DEFAULT,
MF150085 SMALLINT NOT NULL WITH DEFAULT,
MF150086 CHAR(35) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150087 CHAR(35) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150088 CHAR(35) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150089 CHAR(35) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF150090 SMALLINT NOT NULL WITH DEFAULT,
MF150091 SMALLINT NOT NULL WITH DEFAULT,
MF150092 CHAR(16) FOR SBCS DATA NOT NULL
WITH DEFAULT,
CONSTRAINT MF150001
PRIMARY KEY (MF150001))
IN $db.A936H
AUDIT NONE
DATA CAPTURE NONE
CCSID EBCDIC
NOT VOLATILE;
--
LABEL ON TABLE $creator.Twk936 IS 'MF-History älter als ein Jahr';
--
LABEL ON $creator.Twk936
(MF150092 IS 'RM-PID international ',
MF150091 IS 'Limiten-Hierarchie',
MF150090 IS 'Limiten-Typ',
MF150089 IS 'Ort Begünstigter',
MF150088 IS 'Name Begünstigter',
MF150087 IS 'Ort Auftraggeber',
MF150086 IS 'Name Auftraggeber',
MF150085 IS 'Life-Cycle-Status',
MF150084 IS 'Relevant-Group',
MF150083 IS 'Transaction-Typ',
MF150082 IS 'Lade-Timestamp',
MF150081 IS 'Preiskomponente',
MF150080 IS 'mutierbar bis',
MF150079 IS 'Depot_Uebertrag',
MF150078 IS 'Vorheriger GP-Typ',
MF150077 IS 'Bankenclearing-Nr',
MF150076 IS 'Kommentar_Status',
MF150075 IS 'Edit-Status Gesamt',
MF150074 IS 'EDIT-STATUS URHEBER',
MF150073 IS 'EDIT-STATUS GRUND',
MF150072 IS 'Edit-Status Gegenpartei',
MF150071 IS 'Prüfziffer Kundencif',
MF150070 IS 'Stammnummer Kundencif',
MF150069 IS 'Bankstelle Kundencif',
MF150068 IS 'int. Form OE Kundenbüro GP',
MF150067 IS 'int. Form OE Kundenbüro',
MF150066 IS 'int. Form OE-ID KV',
MF150065 IS 'Cif-Saldierungsdatum',
MF150064 IS 'Cif-Eröffnungsdatum',
MF150063 IS 'Mittelfluss-Identifikation',
MF150062 IS 'Coupon-Mantel',
MF150060 IS 'Erstellungstimestamp',
MF150059 IS 'Auftragslaufnummer',
MF150056 IS 'Endverfall Obligationen',
MF150055 IS 'Richtung des Mittelflusses',
MF150054 IS 'Leitweg',
MF150053 IS 'Volumen in Nominal/Stück',
MF150052 IS 'Bearbeitungscode',
MF150051 IS 'Domizil Gegenpartei',
MF150047 IS 'Bestandestyp',
MF150046 IS 'effektive Depotstelle',
MF150045 IS 'Depotstelle',
MF150044 IS 'Sequenz-Nummer zu Valor',
MF150043 IS 'Betrag zu Bestandeswährung',
MF150042 IS 'Bestandeswährung',
MF150041 IS 'Untergruppe Gegenpartei',
MF150040 IS 'Hauptgruppe Gegenpartei',
MF150039 IS 'Gegenpartei-Geldmarktzusatz',
MF150038 IS 'Gegenpartei-Beziehungsnummer',
MF150037 IS 'CSID Gegenpartei',
MF150036 IS 'Gegenpartei',
MF150035 IS 'Gegenpartei-Typ',
MF150034 IS 'BUID Gegenpartei',
MF150033 IS 'KundenverantwortlicheR',
MF150032 IS 'Kundenbüro Kunde',
MF150031 IS 'Kunden-Geldmarktzusatz',
MF150030 IS 'Kunden-Beziehungsnummer',
MF150029 IS 'Depotartenschlüssel',
MF150028 IS 'Kontoartenschlüssel',
MF150027 IS 'Kundendomizil',
MF150026 IS 'Kundensegment',
MF150025 IS 'Kundenart',
MF150024 IS 'PVV-Kunde',
MF150023 IS 'Cifnummer Kunde',
MF150022 IS 'BUID Kunde',
MF150021 IS 'Mutationsdatum',
MF150020 IS 'MutationsPID',
MF150019 IS 'Betrag in CHF',
MF150018 IS 'Betrag in FWhrg',
MF150017 IS 'Valor',
MF150016 IS 'Währung',
MF150015 IS 'Urheber',
MF150014 IS 'Grund',
MF150013 IS 'Buchungsdatum',
MF150012 IS 'Bewegungsverdichtung',
MF150011 IS 'Produkteklassifizierung',
MF150010 IS 'MF-Produkt',
MF150009 IS 'Bewegungsart Konto',
MF150008 IS 'Bewegungsart Depot/Edelmetall',
MF150007 IS 'zu bewerten',
MF150006 IS 'nachzuerfassen',
MF150005 IS 'Storno',
MF150004 IS 'Auftragsnummer',
MF150003 IS 'Lieferantentyp',
MF150002 IS 'RZ-Herkunft',
MF150001 IS 'ID Mittelfluss (UUID)');
commit;
------------------------------------------------------------------------
CREATE UNIQUE INDEX $creator.IWK936H0
ON $creator.Twk936
(MF150001 ASC)
USING STOGROUP GSMS
PRIQTY 48 SECQTY 7200
ERASE NO
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 2 G;
------------------------------------------------------------------------
CREATE INDEX $creator.IWK936H4
ON $creator.Twk936
(MF150066 ASC,
MF150013 DESC)
USING STOGROUP GSMS
PRIQTY 48 SECQTY 7200
ERASE NO
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 4 G;
------------------------------------------------------------------------
CREATE INDEX $creator.IWK936H2
ON $creator.Twk936
(MF150023 ASC,
MF150013 ASC)
USING STOGROUP GSMS
PRIQTY 48 SECQTY 7200
ERASE NO
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 2 G;
------------------------------------------------------------------------
CREATE INDEX $creator.IWK936H1
ON $creator.Twk936
(MF150013 ASC,
MF150067 ASC)
USING STOGROUP GSMS
PRIQTY 48 SECQTY 7200
ERASE NO
FREEPAGE 0 PCTFREE 0
GBPCACHE CHANGED
CLUSTER
PARTITIONED
(PART 1 VALUES('31.08.1999'),
PART 2 VALUES('15.09.1999'),
PART 3 VALUES('30.09.1999'),
PART 4 VALUES('15.10.1999'),
PART 5 VALUES('31.10.1999')
$@[
if $parts > 5 then $@=[
, PART 6 VALUES('15.11.1999'),
PART 7 VALUES('30.11.1999'),
PART 8 VALUES('15.12.1999'),
PART 9 VALUES('31.12.1999'),
PART 10 VALUES('15.01.2000'),
PART 11 VALUES('31.01.2000'),
PART 12 VALUES('15.02.2000'),
PART 13 VALUES('29.02.2000'),
PART 14 VALUES('15.03.2000'),
PART 15 VALUES('31.03.2000'),
PART 16 VALUES('15.04.2000'),
PART 17 VALUES('30.04.2000'),
PART 18 VALUES('15.05.2000'),
PART 19 VALUES('31.05.2000'),
PART 20 VALUES('15.06.2000'),
PART 21 VALUES('30.06.2000'),
PART 22 VALUES('15.07.2000'),
PART 23 VALUES('31.07.2000'),
PART 24 VALUES('15.08.2000'),
PART 25 VALUES('31.08.2000'),
PART 26 VALUES('15.09.2000'),
PART 27 VALUES('30.09.2000'),
PART 28 VALUES('15.10.2000'),
PART 29 VALUES('31.10.2000'),
PART 30 VALUES('15.11.2000'),
PART 31 VALUES('30.11.2000'),
PART 32 VALUES('15.12.2000'),
PART 33 VALUES('31.12.2000'),
PART 34 VALUES('15.01.2001'),
PART 35 VALUES('31.01.2001'),
PART 36 VALUES('15.02.2001'),
PART 37 VALUES('28.02.2001'),
PART 38 VALUES('15.03.2001'),
PART 39 VALUES('31.03.2001'),
PART 40 VALUES('15.04.2001'),
PART 41 VALUES('30.04.2001'),
PART 42 VALUES('15.05.2001'),
PART 43 VALUES('31.05.2001'),
PART 44 VALUES('15.06.2001'),
PART 45 VALUES('30.06.2001'),
PART 46 VALUES('15.07.2001'),
PART 47 VALUES('31.07.2001'),
PART 48 VALUES('15.08.2001'),
PART 49 VALUES('31.08.2001'),
PART 50 VALUES('15.09.2001'),
PART 51 VALUES('30.09.2001'),
PART 52 VALUES('15.10.2001'),
PART 53 VALUES('31.10.2001'),
PART 54 VALUES('15.11.2001'),
PART 55 VALUES('30.11.2001'),
PART 56 VALUES('15.12.2001'),
PART 57 VALUES('31.12.2001'),
PART 58 VALUES('15.01.2002'),
PART 59 VALUES('31.01.2002'),
PART 60 VALUES('15.02.2002'),
PART 61 VALUES('28.02.2002'),
PART 62 VALUES('15.03.2002'),
PART 63 VALUES('31.03.2002'),
PART 64 VALUES('15.04.2002'),
PART 65 VALUES('30.04.2002'),
PART 66 VALUES('15.05.2002'),
PART 67 VALUES('31.05.2002'),
PART 68 VALUES('15.06.2002'),
PART 69 VALUES('30.06.2002'),
PART 70 VALUES('15.07.2002'),
PART 71 VALUES('31.07.2002'),
PART 72 VALUES('15.08.2002'),
PART 73 VALUES('31.08.2002'),
PART 74 VALUES('15.09.2002'),
PART 75 VALUES('30.09.2002'),
PART 76 VALUES('15.10.2002'),
PART 77 VALUES('31.10.2002'),
PART 78 VALUES('15.11.2002'),
PART 79 VALUES('30.11.2002'),
PART 80 VALUES('15.12.2002'),
PART 81 VALUES('31.12.2002'),
PART 82 VALUES('15.01.2003'),
PART 83 VALUES('31.01.2003'),
PART 84 VALUES('15.02.2003'),
PART 85 VALUES('28.02.2003'),
PART 86 VALUES('15.03.2003'),
PART 87 VALUES('31.03.2003'),
PART 88 VALUES('15.04.2003'),
PART 89 VALUES('30.04.2003'),
PART 90 VALUES('15.05.2003'),
PART 91 VALUES('31.05.2003'),
PART 92 VALUES('15.06.2003'),
PART 93 VALUES('30.06.2003'),
PART 94 VALUES('15.07.2003'),
PART 95 VALUES('31.07.2003'),
PART 96 VALUES('15.08.2003'),
PART 97 VALUES('31.08.2003'),
PART 98 VALUES('15.09.2003'),
PART 99 VALUES('30.09.2003'),
PART 100 VALUES('15.10.2003'),
PART 101 VALUES('31.10.2003'),
PART 102 VALUES('15.11.2003'),
PART 103 VALUES('30.11.2003'),
PART 104 VALUES('15.12.2003'),
PART 105 VALUES('31.12.2003'),
PART 106 VALUES('15.01.2004'),
PART 107 VALUES('31.01.2004'),
PART 108 VALUES('15.02.2004'),
PART 109 VALUES('29.02.2004'),
PART 110 VALUES('15.03.2004'),
PART 111 VALUES('31.03.2004'),
PART 112 VALUES('15.04.2004'),
PART 113 VALUES('30.04.2004'),
PART 114 VALUES('15.05.2004'),
PART 115 VALUES('31.05.2004'),
PART 116 VALUES('15.06.2004'),
PART 117 VALUES('30.06.2004'),
PART 118 VALUES('15.07.2004'),
PART 119 VALUES('31.07.2004'),
PART 120 VALUES('15.08.2004'),
PART 121 VALUES('31.08.2004'),
PART 122 VALUES('15.09.2004'),
PART 123 VALUES('30.09.2004'),
PART 124 VALUES('15.10.2004'),
PART 125 VALUES('31.10.2004'),
PART 126 VALUES('15.11.2004'),
PART 127 VALUES('30.11.2004'),
PART 128 VALUES('15.12.2004'),
PART 129 VALUES('31.12.2004'),
PART 130 VALUES('15.01.2005'),
PART 131 VALUES('31.01.2005'),
PART 132 VALUES('15.02.2005'),
PART 133 VALUES('28.02.2005'),
PART 134 VALUES('15.03.2005'),
PART 135 VALUES('31.03.2005'),
PART 136 VALUES('15.04.2005'),
PART 137 VALUES('30.04.2005'),
PART 138 VALUES('15.05.2005'),
PART 139 VALUES('31.05.2005'),
PART 140 VALUES('15.06.2005'),
PART 141 VALUES('30.06.2005'),
PART 142 VALUES('15.07.2005'),
PART 143 VALUES('31.07.2005'),
PART 144 VALUES('15.08.2005'),
PART 145 VALUES('31.08.2005'),
PART 146 VALUES('15.09.2005'),
PART 147 VALUES('30.09.2005'),
PART 148 VALUES('15.10.2005'),
PART 149 VALUES('31.10.2005'),
PART 150 VALUES('15.11.2005'),
PART 151 VALUES('30.11.2005'),
PART 152 VALUES('15.12.2005'),
PART 153 VALUES('31.12.2005'),
PART 154 VALUES('15.01.2006'),
PART 155 VALUES('31.01.2006'),
PART 156 VALUES('15.02.2006'),
PART 157 VALUES('28.02.2006'),
PART 158 VALUES('15.03.2006'),
PART 159 VALUES('31.03.2006'),
PART 160 VALUES('15.04.2006'),
PART 161 VALUES('30.04.2006'),
PART 162 VALUES('15.05.2006'),
PART 163 VALUES('31.05.2006'),
PART 164 VALUES('15.06.2006'),
PART 165 VALUES('30.06.2006'),
PART 166 VALUES('15.07.2006'),
PART 167 VALUES('31.07.2006'),
PART 168 VALUES('15.08.2006'),
PART 169 VALUES('31.08.2006'),
PART 170 VALUES('15.09.2006'),
PART 171 VALUES('30.09.2006'),
PART 172 VALUES('15.10.2006'),
PART 173 VALUES('31.10.2006'),
PART 174 VALUES('15.11.2006'),
PART 175 VALUES('30.11.2006'),
PART 176 VALUES('15.12.2006'),
PART 177 VALUES('31.12.2006'),
PART 178 VALUES('15.01.2007'),
PART 179 VALUES('31.01.2007'),
PART 180 VALUES('15.02.2007'),
PART 181 VALUES('28.02.2007'),
PART 182 VALUES('15.03.2007'),
PART 183 VALUES('31.03.2007'),
PART 184 VALUES('15.04.2007'),
PART 185 VALUES('30.04.2007'),
PART 186 VALUES('15.05.2007'),
PART 187 VALUES('31.05.2007'),
PART 188 VALUES('15.06.2007'),
PART 189 VALUES('30.06.2007'),
PART 190 VALUES('15.07.2007'),
PART 191 VALUES('31.07.2007'),
PART 192 VALUES('15.08.2007'),
PART 193 VALUES('31.08.2007'),
PART 194 VALUES('15.09.2007'),
PART 195 VALUES('30.09.2007'),
PART 196 VALUES('15.10.2007'),
PART 197 VALUES('31.10.2007'),
PART 198 VALUES('15.11.2007'),
PART 199 VALUES('30.11.2007'),
PART 200 VALUES('15.12.2007'),
PART 201 VALUES('31.12.2007'),
PART 202 VALUES('15.01.2008'),
PART 203 VALUES('31.01.2008'),
PART 204 VALUES('15.02.2008'),
PART 205 VALUES('29.02.2008'),
PART 206 VALUES('15.03.2008'),
PART 207 VALUES('31.03.2008'),
PART 208 VALUES('15.04.2008'),
PART 209 VALUES('30.04.2008'),
PART 210 VALUES('15.05.2008'),
PART 211 VALUES('31.05.2008'),
PART 212 VALUES('15.06.2008'),
PART 213 VALUES('30.06.2008'),
PART 214 VALUES('15.07.2008'),
PART 215 VALUES('31.07.2008'),
PART 216 VALUES('15.08.2008'),
PART 217 VALUES('31.08.2008'),
PART 218 VALUES('15.09.2008'),
PART 219 VALUES('30.09.2008'),
PART 220 VALUES('15.10.2008'),
PART 221 VALUES('31.10.2008'),
PART 222 VALUES('15.11.2008'),
PART 223 VALUES('30.11.2008'),
PART 224 VALUES('15.12.2008'),
PART 225 VALUES('31.12.2008'),
PART 226 VALUES('15.01.2009'),
PART 227 VALUES('31.01.2009'),
PART 228 VALUES('15.02.2009'),
PART 229 VALUES('28.02.2009'),
PART 230 VALUES('15.03.2009'),
PART 231 VALUES('31.03.2009'),
PART 232 VALUES('15.04.2009'),
PART 233 VALUES('30.04.2009'),
PART 234 VALUES('15.05.2009'),
PART 235 VALUES('31.05.2009'),
PART 236 VALUES('15.06.2009'),
PART 237 VALUES('30.06.2009'),
PART 238 VALUES('15.07.2009'),
PART 239 VALUES('31.07.2009'),
PART 240 VALUES('15.08.2009'),
PART 241 VALUES('31.08.2009'),
PART 242 VALUES('15.09.2009'),
PART 243 VALUES('30.09.2009'),
PART 244 VALUES('15.10.2009'),
PART 245 VALUES('31.10.2009'),
PART 246 VALUES('15.11.2009'),
PART 247 VALUES('30.11.2009'),
PART 248 VALUES('15.12.2009'),
PART 249 VALUES('31.12.2009'),
PART 250 VALUES('31.12.2099')
$]
$]
)
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER NO
DEFINE YES;
------------------------------------------------------------------------
CREATE INDEX $creator.IWK936H3
ON $creator.Twk936
(MF150067 ASC,
MF150013 ASC)
USING STOGROUP GSMS
PRIQTY 48 SECQTY 7200
ERASE NO
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 2 G;
commit;
------------------------------------------------------------------------
CREATE VIEW $creator.vWk936H1V(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 $creator.Twk936.MF150001, $creator.Twk936.MF150002,
$creator.Twk936.MF150003, $creator.Twk936.MF150004,
$creator.Twk936.MF150005, $creator.Twk936.MF150006,
$creator.Twk936.MF150007, $creator.Twk936.MF150008,
$creator.Twk936.MF150009, $creator.Twk936.MF150010,
$creator.Twk936.MF150011, $creator.Twk936.MF150012,
$creator.Twk936.MF150013, $creator.Twk936.MF150014,
$creator.Twk936.MF150015, $creator.Twk936.MF150016,
$creator.Twk936.MF150017, $creator.Twk936.MF150018,
$creator.Twk936.MF150019, $creator.Twk936.MF150020,
$creator.Twk936.MF150021, $creator.Twk936.MF150022,
$creator.Twk936.MF150023, $creator.Twk936.MF150024,
$creator.Twk936.MF150025, $creator.Twk936.MF150026,
$creator.Twk936.MF150027, $creator.Twk936.MF150028,
$creator.Twk936.MF150029, $creator.Twk936.MF150030,
$creator.Twk936.MF150031, $creator.Twk936.MF150032,
$creator.Twk936.MF150033, $creator.Twk936.MF150034,
$creator.Twk936.MF150035, $creator.Twk936.MF150036,
$creator.Twk936.MF150037, $creator.Twk936.MF150038,
$creator.Twk936.MF150039, $creator.Twk936.MF150040,
$creator.Twk936.MF150041, $creator.Twk936.MF150042,
$creator.Twk936.MF150043, $creator.Twk936.MF150044,
$creator.Twk936.MF150045, $creator.Twk936.MF150046,
$creator.Twk936.MF150047, $creator.Twk936.MF150051,
$creator.Twk936.MF150052, $creator.Twk936.MF150053,
$creator.Twk936.MF150054, $creator.Twk936.MF150055,
$creator.Twk936.MF150056, $creator.Twk936.MF150059,
$creator.Twk936.MF150060, $creator.Twk936.MF150062,
$creator.Twk936.MF150063, $creator.Twk936.MF150064,
$creator.Twk936.MF150065, $creator.Twk936.MF150066,
$creator.Twk936.MF150067, $creator.Twk936.MF150068,
$creator.Twk936.MF150069, $creator.Twk936.MF150070,
$creator.Twk936.MF150071, $creator.Twk936.MF150072,
$creator.Twk936.MF150073, $creator.Twk936.MF150074,
$creator.Twk936.MF150075, $creator.Twk936.MF150076,
$creator.Twk936.MF150077, $creator.Twk936.MF150078,
$creator.Twk936.MF150079, $creator.Twk936.MF150080,
$creator.Twk936.MF150081, $creator.Twk936.MF150082,
$creator.Twk936.MF150083, $creator.Twk936.MF150084,
$creator.Twk936.MF150085, $creator.Twk936.MF150086,
$creator.Twk936.MF150087, $creator.Twk936.MF150088,
$creator.Twk936.MF150089, $creator.Twk936.MF150090,
$creator.Twk936.MF150091, $creator.Twk936.MF150092
FROM $creator.Twk936 ;
--
COMMIT;
--
$@[
if $phase >= 2 then
if $parts = 5 then $@=[ $** alter index- to table-partitioned
ALTER TABLE $creator.TWK936
ALTER PARTITION 5 ENDING ('31.10.1999') ;
$] else $@=[
ALTER TABLE $creator.TWK936
ALTER PARTITION 250 ENDING ('31.12.2099') ;
$]
$]
------------------------------------------------------------------------
-- ADB2GEN - End of generated DDL --
------------------------------------------------------------------------
--
---||| end ddl testcase $mbr env $env phase $phase