zOs/TX/WK954DDT
------------------------------------------------------------------------
-- --
-- Database 2 Administration Tool (DB2 Admin) , program 5697-L90 --
-- --
-- ADB2GEN - Extract object definitions from the DB2 Catalog tables --
-- --
-- Title : TRG FI04030C 1 --
-- --
-- Input prepared on : DBAF (915) Extract time : 2010-04-12 13:34 --
-- --
-- Catalog values overridden : none
-- --
-- Generate : SG=Y DB=Y TS=Y TB=Y VW=Y IX=Y SY=Y AL=Y LB=Y CM=Y FK=Y --
-- TG=Y UT=Y UF=Y SP=Y SQ=Y RO=Y TC=Y --
-- Grants : SG=N DB=Y TS=Y TB=Y VW=Y SC=Y UT=Y UF=Y SP=Y SQ=Y --
-- --
------------------------------------------------------------------------
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Table space=A010A In Database FI04A1A --
-- --
------------------------------------------------------------------------
--
--
------------------------------------------------------------------------
-- Stogroup=GSMS
------------------------------------------------------------------------
--
SET CURRENT SQLID='S100447';
drop tablespace FI04A1A.a010a;
drop tablespace FI04A1A.a011a;
drop tablespace FI04A1A.a021a;
drop tablespace FI04A1A.a025A;
drop tablespace FI04A1A.a040a;
commit;
--
------------------------------------------------------------------------
-- Database=FI04A1A Stogroup=GSMS (for partition 1)
-- Table space=FI04A1A.A010A
CREATE TABLESPACE A010A
IN FI04A1A
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
FREEPAGE 10 PCTFREE 12
GBPCACHE CHANGED
TRACKMOD YES
DSSIZE 8 G
NUMPARTS 254
BUFFERPOOL BP2
LOCKSIZE ANY
LOCKMAX SYSTEM
CLOSE YES
COMPRESS YES
CCSID EBCDIC
DEFINE YES
MAXROWS 255;
--
COMMIT;
--
------------------------------------------------------------------------
-- Table=OA1A.TFI010A1 In FI04A1A.A010A
------------------------------------------------------------------------
--
CREATE TABLE OA1A.TFI010A1
(FI01001A DECIMAL(13, 0) NOT NULL,
FI01002A CHAR(12) FOR SBCS DATA NOT NULL,
FI01003A CHAR(4) FOR SBCS DATA NOT NULL,
FI01004A DATE NOT NULL,
FI01005A SMALLINT NOT NULL WITH DEFAULT 0,
FI01006A TIMESTAMP NOT NULL WITH DEFAULT,
FI01007A CHAR(5) FOR SBCS DATA NOT NULL
WITH DEFAULT,
FI01008A DECIMAL(13, 0) NOT NULL WITH DEFAULT,
FI01009A SMALLINT NOT NULL WITH DEFAULT,
FI01010A DECIMAL(13, 0) NOT NULL WITH DEFAULT,
FI01011A DECIMAL(31, 15) NOT NULL WITH DEFAULT,
FI01012A DECIMAL(31, 15) NOT NULL WITH DEFAULT,
FI01013A CHAR(3) FOR SBCS DATA NOT NULL
WITH DEFAULT,
FI01014A CHAR(5) FOR SBCS DATA NOT NULL
WITH DEFAULT '00000',
FI01015A CHAR(5) FOR SBCS DATA NOT NULL
WITH DEFAULT,
FI01016A CHAR(5) FOR SBCS DATA NOT NULL
WITH DEFAULT,
FI01017A CHAR(5) FOR SBCS DATA NOT NULL
WITH DEFAULT,
FI01018A CHAR(30) FOR SBCS DATA NOT NULL
WITH DEFAULT,
FI01019A CHAR(3) FOR SBCS DATA NOT NULL
WITH DEFAULT,
FI01020A CHAR(30) FOR SBCS DATA NOT NULL
WITH DEFAULT,
FI01021A CHAR(4) FOR SBCS DATA NOT NULL
WITH DEFAULT,
FI01022A CHAR(30) FOR SBCS DATA NOT NULL
WITH DEFAULT,
FI01023A DECIMAL(31, 15) NOT NULL WITH DEFAULT,
FI01024A DECIMAL(31, 15) NOT NULL WITH DEFAULT,
FI01025A DECIMAL(31, 15) NOT NULL WITH DEFAULT,
FI01026A CHAR(3) FOR SBCS DATA NOT NULL
WITH DEFAULT,
FI01027A CHAR(3) FOR SBCS DATA NOT NULL
WITH DEFAULT,
FI01028A DECIMAL(31, 15) NOT NULL WITH DEFAULT,
FI01029A CHAR(3) FOR SBCS DATA NOT NULL
WITH DEFAULT,
FI01030A CHAR(4) FOR SBCS DATA NOT NULL
WITH DEFAULT,
FI01031A CHAR(3) FOR SBCS DATA NOT NULL
WITH DEFAULT,
FI01032A DECIMAL(31, 15) NOT NULL WITH DEFAULT,
FI01033A DECIMAL(15, 6) NOT NULL WITH DEFAULT,
FI01034A SMALLINT NOT NULL WITH DEFAULT,
FI01035A CHAR(2) FOR SBCS DATA NOT NULL
WITH DEFAULT,
FI01036A CHAR(8) FOR SBCS DATA NOT NULL
WITH DEFAULT,
FI01037A CHAR(8) FOR SBCS DATA NOT NULL
WITH DEFAULT,
FI01038A SMALLINT NOT NULL WITH DEFAULT,
FI01039A CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
FI01040A CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT '0',
FI01041A CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT '0',
FI01042A CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT '0',
FI01043A CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT '0',
FI01044A CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT '0',
FI01045A CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT '0',
FI01046A CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT '0',
FI01047A CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT '0',
FI01048A DATE NOT NULL WITH DEFAULT '9999-12-31',
FI01049A CHAR(2) FOR SBCS DATA NOT NULL
WITH DEFAULT,
FI01050A CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
FI01051A CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
FI01052A CHAR(12) FOR SBCS DATA NOT NULL
WITH DEFAULT,
FI01053A CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
FI01054A SMALLINT NOT NULL WITH DEFAULT,
FI01055A SMALLINT NOT NULL WITH DEFAULT,
FI01056A SMALLINT NOT NULL WITH DEFAULT,
FI01057A SMALLINT NOT NULL WITH DEFAULT,
FI01058A CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
FI01059A DATE NOT NULL WITH DEFAULT,
FI01060A CHAR(10) FOR SBCS DATA NOT NULL
WITH DEFAULT,
FI01061A CHAR(8) FOR SBCS DATA NOT NULL
WITH DEFAULT USER ,
FI01062A DECIMAL(31, 15) NOT NULL WITH DEFAULT,
FI01063A DECIMAL(31, 15) NOT NULL WITH DEFAULT,
FI01064A SMALLINT NOT NULL WITH DEFAULT,
FI01065A CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
FI01066A VARCHAR(30) FOR SBCS DATA NOT NULL
WITH DEFAULT,
FI01067A CHAR(4) FOR SBCS DATA NOT NULL
WITH DEFAULT,
CONSTRAINT FI01001A
PRIMARY KEY (FI01001A,
FI01002A,
FI01003A,
FI01004A,
FI01005A,
FI01006A))
IN FI04A1A.A010A
AUDIT NONE
DATA CAPTURE NONE
CCSID EBCDIC
NOT VOLATILE;
--
LABEL ON TABLE OA1A.TFI010A1 IS 'LISTING-TABLE';
--
COMMENT ON TABLE OA1A.TFI010A1
IS '"Listing"-Tabelle: Version vom 30may2006/wah';
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=FI04A1A
-- Index=OA1A.IFI010A1 On OA1A.TFI010A1
------------------------------------------------------------------------
--
CREATE UNIQUE INDEX OA1A.IFI010A1
ON OA1A.TFI010A1
(FI01001A ASC,
FI01002A ASC,
FI01003A ASC,
FI01004A ASC,
FI01005A DESC,
FI01006A DESC)
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
CLUSTER
(PART 1 VALUES(43994.),
PART 2 VALUES(75448.),
PART 3 VALUES(105269.),
PART 4 VALUES(139940.),
PART 5 VALUES(180579.),
PART 6 VALUES(229467.),
PART 7 VALUES(268346.),
PART 8 VALUES(296399.),
PART 9 VALUES(330923.),
PART 10 VALUES(354601.),
PART 11 VALUES(385505.),
PART 12 VALUES(416278.),
PART 13 VALUES(448134.),
PART 14 VALUES(480183.),
PART 15 VALUES(510789.),
PART 16 VALUES(541793.),
PART 17 VALUES(571712.),
PART 18 VALUES(600204.),
PART 19 VALUES(625158.),
PART 20 VALUES(656291.),
PART 21 VALUES(683360.),
PART 22 VALUES(713395.),
PART 23 VALUES(748805.),
PART 24 VALUES(763327.),
PART 25 VALUES(784410.),
PART 26 VALUES(805426.),
PART 27 VALUES(829891.),
PART 28 VALUES(847017.),
PART 29 VALUES(868389.),
PART 30 VALUES(894183.),
PART 31 VALUES(912738.),
PART 32 VALUES(926850.),
PART 33 VALUES(941372.),
PART 34 VALUES(955585.),
PART 35 VALUES(970477.),
PART 36 VALUES(985805.),
PART 37 VALUES(1002882.),
PART 38 VALUES(1019255.),
PART 39 VALUES(1037844.),
PART 40 VALUES(1057746.),
PART 41 VALUES(1078077.),
PART 42 VALUES(1094995.),
PART 43 VALUES(1111388.),
PART 44 VALUES(1130424.),
PART 45 VALUES(1147862.),
PART 46 VALUES(1165501.),
PART 47 VALUES(1183418.),
PART 48 VALUES(1200209.),
PART 49 VALUES(1216835.),
PART 50 VALUES(1231935.),
PART 51 VALUES(1246898.),
PART 52 VALUES(1261515.),
PART 53 VALUES(1277391.),
PART 54 VALUES(1293130.),
PART 55 VALUES(1308585.),
PART 56 VALUES(1322064.),
PART 57 VALUES(1337513.),
PART 58 VALUES(1354958.),
PART 59 VALUES(1371265.),
PART 60 VALUES(1389012.),
PART 61 VALUES(1405869.),
PART 62 VALUES(1421420.),
PART 63 VALUES(1436112.),
PART 64 VALUES(1452102.),
PART 65 VALUES(1471047.),
PART 66 VALUES(1489123.),
PART 67 VALUES(1505940.),
PART 68 VALUES(1523045.),
PART 69 VALUES(1540368.),
PART 70 VALUES(1556517.),
PART 71 VALUES(1573930.),
PART 72 VALUES(1591324.),
PART 73 VALUES(1608174.),
PART 74 VALUES(1625028.),
PART 75 VALUES(1641654.),
PART 76 VALUES(1659444.),
PART 77 VALUES(1676757.),
PART 78 VALUES(1692456.),
PART 79 VALUES(1708786.),
PART 80 VALUES(1723884.),
PART 81 VALUES(1738003.),
PART 82 VALUES(1752950.),
PART 83 VALUES(1767818.),
PART 84 VALUES(1781899.),
PART 85 VALUES(1798882.),
PART 86 VALUES(1815578.),
PART 87 VALUES(1831723.),
PART 88 VALUES(1846743.),
PART 89 VALUES(1859734.),
PART 90 VALUES(1876742.),
PART 91 VALUES(1894506.),
PART 92 VALUES(1909901.),
PART 93 VALUES(1925468.),
PART 94 VALUES(1941416.),
PART 95 VALUES(1957102.),
PART 96 VALUES(1970900.),
PART 97 VALUES(1985387.),
PART 98 VALUES(1998093.),
PART 99 VALUES(2012507.),
PART 100 VALUES(2026970.),
PART 101 VALUES(2041366.),
PART 102 VALUES(2054177.),
PART 103 VALUES(2067838.),
PART 104 VALUES(2081912.),
PART 105 VALUES(2096814.),
PART 106 VALUES(2112518.),
PART 107 VALUES(2128050.),
PART 108 VALUES(2146026.),
PART 109 VALUES(2164106.),
PART 110 VALUES(2178536.),
PART 111 VALUES(2192791.),
PART 112 VALUES(2206070.),
PART 113 VALUES(2219567.),
PART 114 VALUES(2232240.),
PART 115 VALUES(2245585.),
PART 116 VALUES(2259277.),
PART 117 VALUES(2273452.),
PART 118 VALUES(2287908.),
PART 119 VALUES(2300283.),
PART 120 VALUES(2312833.),
PART 121 VALUES(2326378.),
PART 122 VALUES(2337589.),
PART 123 VALUES(2348563.),
PART 124 VALUES(2360146.),
PART 125 VALUES(2373153.),
PART 126 VALUES(2385893.),
PART 127 VALUES(2397034.),
PART 128 VALUES(2407081.),
PART 129 VALUES(2418103.),
PART 130 VALUES(2429461.),
PART 131 VALUES(2439356.),
PART 132 VALUES(2449547.),
PART 133 VALUES(2460722.),
PART 134 VALUES(2470759.),
PART 135 VALUES(2481259.),
PART 136 VALUES(2490829.),
PART 137 VALUES(2498446.),
PART 138 VALUES(2507005.),
PART 139 VALUES(2515772.),
PART 140 VALUES(2523473.),
PART 141 VALUES(2528510.),
PART 142 VALUES(2533930.),
PART 143 VALUES(2543059.),
PART 144 VALUES(2556387.),
PART 145 VALUES(5016006.),
PART 146 VALUES(5018748.),
PART 147 VALUES(5058297.),
PART 148 VALUES(5082534.),
PART 149 VALUES(5091653.),
PART 150 VALUES(5101548.),
PART 151 VALUES(5129288.),
PART 152 VALUES(5160824.),
PART 153 VALUES(5184469.),
PART 154 VALUES(5199568.),
PART 155 VALUES(5216705.),
PART 156 VALUES(5249020.),
PART 157 VALUES(5293929.),
PART 158 VALUES(5316202.),
PART 159 VALUES(5323572.),
PART 160 VALUES(5331591.),
PART 161 VALUES(5340535.),
PART 162 VALUES(5361272.),
PART 163 VALUES(5394421.),
PART 164 VALUES(5423091.),
PART 165 VALUES(5435112.),
PART 166 VALUES(5441321.),
PART 167 VALUES(5449449.),
PART 168 VALUES(5458577.),
PART 169 VALUES(5484829.),
PART 170 VALUES(5508524.),
PART 171 VALUES(5530279.),
PART 172 VALUES(5540379.),
PART 173 VALUES(5549907.),
PART 174 VALUES(5559921.),
PART 175 VALUES(5573029.),
PART 176 VALUES(5591165.),
PART 177 VALUES(5613777.),
PART 178 VALUES(5628486.),
PART 179 VALUES(5655289.),
PART 180 VALUES(5671308.),
PART 181 VALUES(5678895.),
PART 182 VALUES(5686693.),
PART 183 VALUES(5693607.),
PART 184 VALUES(5701582.),
PART 185 VALUES(5712622.),
PART 186 VALUES(5729228.),
PART 187 VALUES(5743750.),
PART 188 VALUES(5760365.),
PART 189 VALUES(5779866.),
PART 190 VALUES(5790992.),
PART 191 VALUES(5794418.),
PART 192 VALUES(5798227.),
PART 193 VALUES(5802213.),
PART 194 VALUES(5805830.),
PART 195 VALUES(5809656.),
PART 196 VALUES(5812404.),
PART 197 VALUES(5818101.),
PART 198 VALUES(5830003.),
PART 199 VALUES(5832617.),
PART 200 VALUES(5838286.),
PART 201 VALUES(5848573.),
PART 202 VALUES(5865407.),
PART 203 VALUES(5879005.),
PART 204 VALUES(5889407.),
PART 205 VALUES(5903115.),
PART 206 VALUES(5914072.),
PART 207 VALUES(5921394.),
PART 208 VALUES(5930062.),
PART 209 VALUES(5934496.),
PART 210 VALUES(5937844.),
PART 211 VALUES(5940478.),
PART 212 VALUES(5943131.),
PART 213 VALUES(5945850.),
PART 214 VALUES(5948864.),
PART 215 VALUES(5954771.),
PART 216 VALUES(5963894.),
PART 217 VALUES(5976746.),
PART 218 VALUES(5987077.),
PART 219 VALUES(5996145.),
PART 220 VALUES(6006086.),
PART 221 VALUES(6022351.),
PART 222 VALUES(6037994.),
PART 223 VALUES(6055428.),
PART 224 VALUES(6064096.),
PART 225 VALUES(6074834.),
PART 226 VALUES(6096145.),
PART 227 VALUES(6116051.),
PART 228 VALUES(6134365.),
PART 229 VALUES(6152973.),
PART 230 VALUES(6968149.),
PART 231 VALUES(7349532.),
PART 232 VALUES(7905006.),
PART 233 VALUES(8254210.),
PART 234 VALUES(8372174.),
PART 235 VALUES(8387195.),
PART 236 VALUES(8465183.),
PART 237 VALUES(8588918.),
PART 238 VALUES(8818179.),
PART 239 VALUES(9010513.),
PART 240 VALUES(9107064.),
PART 241 VALUES(9263097.),
PART 242 VALUES(9388252.),
PART 243 VALUES(9455415.),
PART 244 VALUES(9511516.),
PART 245 VALUES(9585601.),
PART 246 VALUES(9650393.),
PART 247 VALUES(9653172.),
PART 248 VALUES(9708231.),
PART 249 VALUES(9749496.),
PART 250 VALUES(9791301.),
PART 251 VALUES(9803710.),
PART 252 VALUES(9845923.),
PART 253 VALUES(9899799.),
PART 254 VALUES(9999999999999.))
BUFFERPOOL BP1
CLOSE NO
COPY NO
DEFER NO
DEFINE YES;
--
COMMIT;
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Table space=A011A In Database FI04A1A --
-- --
------------------------------------------------------------------------
--
--
------------------------------------------------------------------------
-- Stogroup=GSMS
------------------------------------------------------------------------
-- Database=FI04A1A Stogroup=GSMS (for partition 1)
-- Table space=FI04A1A.A011A
------------------------------------------------------------------------
--
CREATE TABLESPACE A011A
IN FI04A1A
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
FREEPAGE 8 PCTFREE 25
GBPCACHE CHANGED
TRACKMOD YES
DSSIZE 4 G
NUMPARTS 254
BUFFERPOOL BP2
LOCKSIZE ANY
LOCKMAX SYSTEM
CLOSE YES
COMPRESS YES
CCSID EBCDIC
DEFINE YES
MAXROWS 255;
--
COMMIT;
--
------------------------------------------------------------------------
-- Table=OA1A.TFI011A1 In FI04A1A.A011A
------------------------------------------------------------------------
--
CREATE TABLE OA1A.TFI011A1
(FI01101A DECIMAL(13, 0) NOT NULL,
FI01102A SMALLINT NOT NULL WITH DEFAULT,
FI01103A DATE NOT NULL,
FI01104A DECIMAL(31, 15) NOT NULL WITH DEFAULT,
FI01105A DECIMAL(31, 15) NOT NULL WITH DEFAULT,
FI01106A CHAR(5) FOR SBCS DATA NOT NULL
WITH DEFAULT '00000',
FI01107A TIMESTAMP NOT NULL WITH DEFAULT,
FI01108A DECIMAL(13, 0) NOT NULL,
FI01109A CHAR(20) FOR SBCS DATA NOT NULL
WITH DEFAULT,
CONSTRAINT FI01101A
PRIMARY KEY (FI01101A,
FI01102A,
FI01103A,
FI01104A,
FI01105A,
FI01106A,
FI01107A))
IN FI04A1A.A011A
AUDIT NONE
DATA CAPTURE NONE
CCSID EBCDIC
NOT VOLATILE;
--
LABEL ON TABLE OA1A.TFI011A1 IS 'UMSETZUNG-VALOR';
--
COMMENT ON TABLE OA1A.TFI011A1
IS 'Schlüssel-Tabelle "Valor": Version vom 10jan2006/wah';
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=FI04A1A
-- Index=OA1A.IFI011A1 On OA1A.TFI011A1
------------------------------------------------------------------------
--
CREATE UNIQUE INDEX OA1A.IFI011A1
ON OA1A.TFI011A1
(FI01101A ASC,
FI01102A ASC,
FI01103A DESC,
FI01104A ASC,
FI01105A ASC,
FI01106A ASC,
FI01107A DESC)
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
FREEPAGE 9 PCTFREE 13
GBPCACHE CHANGED
CLUSTER
(PART 1 VALUES(16023.),
PART 2 VALUES(27203.),
PART 3 VALUES(47967.),
PART 4 VALUES(63446.),
PART 5 VALUES(78375.),
PART 6 VALUES(84484.),
PART 7 VALUES(91066.),
PART 8 VALUES(102261.),
PART 9 VALUES(118810.),
PART 10 VALUES(137650.),
PART 11 VALUES(154721.),
PART 12 VALUES(173678.),
PART 13 VALUES(188715.),
PART 14 VALUES(202895.),
PART 15 VALUES(217854.),
PART 16 VALUES(238698.),
PART 17 VALUES(256412.),
PART 18 VALUES(274041.),
PART 19 VALUES(274203.),
PART 20 VALUES(274207.),
PART 21 VALUES(274212.),
PART 22 VALUES(274214.),
PART 23 VALUES(274224.),
PART 24 VALUES(274233.),
PART 25 VALUES(274234.),
PART 26 VALUES(274551.),
PART 27 VALUES(274561.),
PART 28 VALUES(274604.),
PART 29 VALUES(274695.),
PART 30 VALUES(274808.),
PART 31 VALUES(274851.),
PART 32 VALUES(274869.),
PART 33 VALUES(274870.),
PART 34 VALUES(274880.),
PART 35 VALUES(274942.),
PART 36 VALUES(274950.),
PART 37 VALUES(275413.),
PART 38 VALUES(281080.),
PART 39 VALUES(293557.),
PART 40 VALUES(322646.),
PART 41 VALUES(325959.),
PART 42 VALUES(338140.),
PART 43 VALUES(348816.),
PART 44 VALUES(369506.),
PART 45 VALUES(382652.),
PART 46 VALUES(400159.),
PART 47 VALUES(410015.),
PART 48 VALUES(421178.),
PART 49 VALUES(431885.),
PART 50 VALUES(450413.),
PART 51 VALUES(468339.),
PART 52 VALUES(485792.),
PART 53 VALUES(487663.),
PART 54 VALUES(494484.),
PART 55 VALUES(503594.),
PART 56 VALUES(508670.),
PART 57 VALUES(515843.),
PART 58 VALUES(523287.),
PART 59 VALUES(531428.),
PART 60 VALUES(544999.),
PART 61 VALUES(560167.),
PART 62 VALUES(574527.),
PART 63 VALUES(581972.),
PART 64 VALUES(602030.),
PART 65 VALUES(610721.),
PART 66 VALUES(616689.),
PART 67 VALUES(636487.),
PART 68 VALUES(642397.),
PART 69 VALUES(651150.),
PART 70 VALUES(661885.),
PART 71 VALUES(674614.),
PART 72 VALUES(682423.),
PART 73 VALUES(696125.),
PART 74 VALUES(706188.),
PART 75 VALUES(717657.),
PART 76 VALUES(726062.),
PART 77 VALUES(757383.),
PART 78 VALUES(762182.),
PART 79 VALUES(763184.),
PART 80 VALUES(764030.),
PART 81 VALUES(791448.),
PART 82 VALUES(808969.),
PART 83 VALUES(821881.),
PART 84 VALUES(829257.),
PART 85 VALUES(840940.),
PART 86 VALUES(846448.),
PART 87 VALUES(846903.),
PART 88 VALUES(860260.),
PART 89 VALUES(874375.),
PART 90 VALUES(895320.),
PART 91 VALUES(905328.),
PART 92 VALUES(908542.),
PART 93 VALUES(910957.),
PART 94 VALUES(913323.),
PART 95 VALUES(917234.),
PART 96 VALUES(920993.),
PART 97 VALUES(926444.),
PART 98 VALUES(930601.),
PART 99 VALUES(933854.),
PART 100 VALUES(939360.),
PART 101 VALUES(942478.),
PART 102 VALUES(945739.),
PART 103 VALUES(947691.),
PART 104 VALUES(951177.),
PART 105 VALUES(954485.),
PART 106 VALUES(959048.),
PART 107 VALUES(963555.),
PART 108 VALUES(967628.),
PART 109 VALUES(969501.),
PART 110 VALUES(974283.),
PART 111 VALUES(978021.),
PART 112 VALUES(982352.),
PART 113 VALUES(985492.),
PART 114 VALUES(987195.),
PART 115 VALUES(987197.),
PART 116 VALUES(987203.),
PART 117 VALUES(989238.),
PART 118 VALUES(998033.),
PART 119 VALUES(998230.),
PART 120 VALUES(998377.),
PART 121 VALUES(998441.),
PART 122 VALUES(998819.),
PART 123 VALUES(998839.),
PART 124 VALUES(1006372.),
PART 125 VALUES(1014711.),
PART 126 VALUES(1026592.),
PART 127 VALUES(1039154.),
PART 128 VALUES(1051750.),
PART 129 VALUES(1060510.),
PART 130 VALUES(1072153.),
PART 131 VALUES(1078156.),
PART 132 VALUES(1085784.),
PART 133 VALUES(1089491.),
PART 134 VALUES(1096232.),
PART 135 VALUES(1102544.),
PART 136 VALUES(1110480.),
PART 137 VALUES(1114081.),
PART 138 VALUES(1129891.),
PART 139 VALUES(1142332.),
PART 140 VALUES(1153865.),
PART 141 VALUES(1165915.),
PART 142 VALUES(1179277.),
PART 143 VALUES(1191513.),
PART 144 VALUES(1201496.),
PART 145 VALUES(1212640.),
PART 146 VALUES(1221723.),
PART 147 VALUES(1231299.),
PART 148 VALUES(1240275.),
PART 149 VALUES(1250633.),
PART 150 VALUES(1259393.),
PART 151 VALUES(1272232.),
PART 152 VALUES(1282640.),
PART 153 VALUES(1295723.),
PART 154 VALUES(1303431.),
PART 155 VALUES(1313410.),
PART 156 VALUES(1324823.),
PART 157 VALUES(1336531.),
PART 158 VALUES(1349026.),
PART 159 VALUES(1363916.),
PART 160 VALUES(1375249.),
PART 161 VALUES(1386046.),
PART 162 VALUES(1399446.),
PART 163 VALUES(1414294.),
PART 164 VALUES(1426403.),
PART 165 VALUES(1439753.),
PART 166 VALUES(1445894.),
PART 167 VALUES(1457177.),
PART 168 VALUES(1469205.),
PART 169 VALUES(1484833.),
PART 170 VALUES(1493523.),
PART 171 VALUES(1505784.),
PART 172 VALUES(1519470.),
PART 173 VALUES(1533549.),
PART 174 VALUES(1547099.),
PART 175 VALUES(1559944.),
PART 176 VALUES(1566558.),
PART 177 VALUES(1579265.),
PART 178 VALUES(1592667.),
PART 179 VALUES(1594836.),
PART 180 VALUES(1602649.),
PART 181 VALUES(1615303.),
PART 182 VALUES(1629237.),
PART 183 VALUES(1642910.),
PART 184 VALUES(1654969.),
PART 185 VALUES(1670365.),
PART 186 VALUES(1680081.),
PART 187 VALUES(1684022.),
PART 188 VALUES(1688898.),
PART 189 VALUES(1699853.),
PART 190 VALUES(1708221.),
PART 191 VALUES(1716142.),
PART 192 VALUES(1732506.),
PART 193 VALUES(1744803.),
PART 194 VALUES(1755645.),
PART 195 VALUES(1770261.),
PART 196 VALUES(1784679.),
PART 197 VALUES(1801234.),
PART 198 VALUES(1812191.),
PART 199 VALUES(1825954.),
PART 200 VALUES(1840819.),
PART 201 VALUES(1854910.),
PART 202 VALUES(1869279.),
PART 203 VALUES(1881552.),
PART 204 VALUES(1896540.),
PART 205 VALUES(1906140.),
PART 206 VALUES(1915700.),
PART 207 VALUES(1930395.),
PART 208 VALUES(1945372.),
PART 209 VALUES(1956437.),
PART 210 VALUES(1968228.),
PART 211 VALUES(1982304.),
PART 212 VALUES(1993355.),
PART 213 VALUES(2007583.),
PART 214 VALUES(2020614.),
PART 215 VALUES(2032415.),
PART 216 VALUES(2044478.),
PART 217 VALUES(2058569.),
PART 218 VALUES(2072290.),
PART 219 VALUES(2086677.),
PART 220 VALUES(2099871.),
PART 221 VALUES(2112283.),
PART 222 VALUES(2126879.),
PART 223 VALUES(2142131.),
PART 224 VALUES(2161228.),
PART 225 VALUES(2174084.),
PART 226 VALUES(2187347.),
PART 227 VALUES(2200367.),
PART 228 VALUES(2212312.),
PART 229 VALUES(2225263.),
PART 230 VALUES(2238083.),
PART 231 VALUES(2252140.),
PART 232 VALUES(2268848.),
PART 233 VALUES(2285931.),
PART 234 VALUES(2301455.),
PART 235 VALUES(2302328.),
PART 236 VALUES(2315441.),
PART 237 VALUES(2338348.),
PART 238 VALUES(2349996.),
PART 239 VALUES(2362377.),
PART 240 VALUES(2372840.),
PART 241 VALUES(2397527.),
PART 242 VALUES(5074018.),
PART 243 VALUES(5324367.),
PART 244 VALUES(5413774.),
PART 245 VALUES(5511720.),
PART 246 VALUES(5533430.),
PART 247 VALUES(5552426.),
PART 248 VALUES(5597874.),
PART 249 VALUES(5615313.),
PART 250 VALUES(8996402.),
PART 251 VALUES(9409466.),
PART 252 VALUES(9532001.),
PART 253 VALUES(9899767.),
PART 254 VALUES(9999999999999.))
BUFFERPOOL BP1
CLOSE NO
COPY NO
DEFER NO
DEFINE YES;
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=FI04A1A
-- Index=OA1A.IFI011A2 On OA1A.TFI011A1
------------------------------------------------------------------------
--
CREATE INDEX OA1A.IFI011A2
ON OA1A.TFI011A1
(FI01108A ASC,
FI01103A DESC)
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 10 PCTFREE 5
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE NO
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=FI04A1A
-- Index=OA1A.IFI011A3 On OA1A.TFI011A1
------------------------------------------------------------------------
--
CREATE INDEX OA1A.IFI011A3
ON OA1A.TFI011A1
(FI01109A ASC)
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 10 PCTFREE 5
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE NO
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Table space=A021A In Database FI04A1A --
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Database=FI04A1A Stogroup=GSMS (for partition 1)
-- Table space=FI04A1A.A021A
------------------------------------------------------------------------
--
CREATE TABLESPACE A021A
IN FI04A1A
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
FREEPAGE 10 PCTFREE 5
GBPCACHE CHANGED
TRACKMOD YES
DSSIZE 4 G
NUMPARTS 2
BUFFERPOOL BP2
LOCKSIZE ANY
LOCKMAX SYSTEM
CLOSE YES
COMPRESS YES
CCSID EBCDIC
DEFINE YES
MAXROWS 100;
--
COMMIT;
--
------------------------------------------------------------------------
-- Table=OA1A.TFI021A1 In FI04A1A.A021A
------------------------------------------------------------------------
--
CREATE TABLE OA1A.TFI021A1
(FI02101A DECIMAL(13, 0) NOT NULL,
FI02102A CHAR(12) FOR SBCS DATA NOT NULL,
FI02103A CHAR(4) FOR SBCS DATA NOT NULL,
FI02104A DATE NOT NULL,
FI02105A SMALLINT NOT NULL,
FI02106A DATE NOT NULL WITH DEFAULT '0001-01-01',
FI02107A DATE NOT NULL WITH DEFAULT '0001-01-01',
FI02108A DATE NOT NULL WITH DEFAULT '0001-01-01',
FI02109A DATE NOT NULL WITH DEFAULT '0001-01-01',
FI02110A DATE NOT NULL WITH DEFAULT '0001-01-01',
FI02111A DECIMAL(13, 0) WITH DEFAULT NULL,
FI02112A DECIMAL(13, 0) WITH DEFAULT NULL,
FI02113A DECIMAL(13, 0) WITH DEFAULT NULL,
FI02114A DECIMAL(13, 0) WITH DEFAULT NULL,
FI02115A DECIMAL(13, 0) WITH DEFAULT NULL,
CONSTRAINT FI02101A
PRIMARY KEY (FI02101A,
FI02102A,
FI02103A,
FI02104A,
FI02105A))
IN FI04A1A.A021A
AUDIT NONE
DATA CAPTURE NONE
CCSID EBCDIC
NOT VOLATILE;
--
LABEL ON TABLE OA1A.TFI021A1 IS 'PRICELOOKUP TABLE';
--
COMMENT ON TABLE OA1A.TFI021A1 IS 'LAST 5 DELIVERY-PRICES';
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=FI04A1A
-- Index=OA1A.IFI021A1 On OA1A.TFI021A1
------------------------------------------------------------------------
--
CREATE UNIQUE INDEX OA1A.IFI021A1
ON OA1A.TFI021A1
(FI02101A ASC,
FI02102A ASC,
FI02103A ASC,
FI02104A DESC,
FI02105A ASC)
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
FREEPAGE 0 PCTFREE 10
GBPCACHE CHANGED
CLUSTER
(PART 1 VALUES(4999999.),
PART 2 VALUES(9999999999999.) FREEPAGE 10 PCTFREE 5)
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER NO
DEFINE YES;
--
COMMIT;
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Table space=A025A In Database FI04A1A --
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Database=FI04A1A Stogroup=GSMS
-- Table space=FI04A1A.A025A
------------------------------------------------------------------------
--
CREATE TABLESPACE A025A
IN FI04A1A
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 5 PCTFREE 12
GBPCACHE CHANGED
TRACKMOD YES
SEGSIZE 64
BUFFERPOOL BP2
LOCKSIZE ANY
LOCKMAX SYSTEM
CLOSE YES
COMPRESS YES
CCSID EBCDIC
DEFINE YES
MAXROWS 255;
--
COMMIT;
--
------------------------------------------------------------------------
-- Table=OA1A.TFI025A1 In FI04A1A.A025A
------------------------------------------------------------------------
--
CREATE TABLE OA1A.TFI025A1
(FI02501A DECIMAL(13, 0) NOT NULL,
FI02502A CHAR(12) FOR SBCS DATA NOT NULL,
FI02503A CHAR(4) FOR SBCS DATA NOT NULL,
FI02504A DATE NOT NULL,
FI02505A SMALLINT NOT NULL WITH DEFAULT 0,
FI02506A TIMESTAMP NOT NULL WITH DEFAULT,
FI02507A DATE WITH DEFAULT NULL,
FI02508A CHAR(2) FOR SBCS DATA WITH DEFAULT NULL,
FI02509A DECIMAL(31, 15) WITH DEFAULT NULL,
FI02510A CHAR(8) FOR SBCS DATA WITH DEFAULT NULL,
FI02511A DATE WITH DEFAULT NULL,
FI02512A CHAR(2) FOR SBCS DATA WITH DEFAULT NULL,
FI02513A DECIMAL(31, 15) WITH DEFAULT NULL,
FI02514A CHAR(8) FOR SBCS DATA WITH DEFAULT NULL,
FI02515A DATE WITH DEFAULT NULL,
FI02516A CHAR(2) FOR SBCS DATA WITH DEFAULT NULL,
FI02517A DECIMAL(31, 15) WITH DEFAULT NULL,
FI02518A CHAR(8) FOR SBCS DATA WITH DEFAULT NULL,
FI02519A DATE WITH DEFAULT NULL,
FI02520A CHAR(2) FOR SBCS DATA WITH DEFAULT NULL,
FI02521A DECIMAL(31, 15) WITH DEFAULT NULL,
FI02522A CHAR(8) FOR SBCS DATA WITH DEFAULT NULL,
FI02523A DATE WITH DEFAULT NULL,
FI02524A CHAR(2) FOR SBCS DATA WITH DEFAULT NULL,
FI02525A DECIMAL(31, 15) WITH DEFAULT NULL,
FI02526A CHAR(8) FOR SBCS DATA WITH DEFAULT NULL,
FI02527A DATE WITH DEFAULT NULL,
FI02528A CHAR(2) FOR SBCS DATA WITH DEFAULT NULL,
FI02529A DECIMAL(31, 15) WITH DEFAULT NULL,
FI02530A CHAR(8) FOR SBCS DATA WITH DEFAULT NULL,
FI02531A DATE WITH DEFAULT NULL,
FI02532A CHAR(2) FOR SBCS DATA WITH DEFAULT NULL,
FI02533A DECIMAL(31, 15) WITH DEFAULT NULL,
FI02534A CHAR(8) FOR SBCS DATA WITH DEFAULT NULL,
FI02535A DATE WITH DEFAULT NULL,
FI02536A CHAR(2) FOR SBCS DATA WITH DEFAULT NULL,
FI02537A DECIMAL(31, 15) WITH DEFAULT NULL,
FI02538A CHAR(8) FOR SBCS DATA WITH DEFAULT NULL,
FI02539A DATE WITH DEFAULT NULL,
FI02540A CHAR(2) FOR SBCS DATA WITH DEFAULT NULL,
FI02541A DECIMAL(31, 15) WITH DEFAULT NULL,
FI02542A CHAR(8) FOR SBCS DATA WITH DEFAULT NULL,
FI02543A DATE WITH DEFAULT NULL,
FI02544A CHAR(2) FOR SBCS DATA WITH DEFAULT NULL,
FI02545A DECIMAL(31, 15) WITH DEFAULT NULL,
FI02546A CHAR(8) FOR SBCS DATA WITH DEFAULT NULL,
FI02547A DATE WITH DEFAULT NULL,
FI02548A CHAR(2) FOR SBCS DATA WITH DEFAULT NULL,
FI02549A DECIMAL(31, 15) WITH DEFAULT NULL,
FI02550A CHAR(8) FOR SBCS DATA WITH DEFAULT NULL,
FI02551A DATE WITH DEFAULT NULL,
FI02552A CHAR(2) FOR SBCS DATA WITH DEFAULT NULL,
FI02553A DECIMAL(31, 15) WITH DEFAULT NULL,
FI02554A CHAR(8) FOR SBCS DATA WITH DEFAULT NULL,
FI02555A DATE WITH DEFAULT NULL,
FI02556A DECIMAL(31, 15) WITH DEFAULT NULL,
FI02557A SMALLINT WITH DEFAULT NULL,
CONSTRAINT FI02501A
PRIMARY KEY (FI02501A,
FI02502A,
FI02503A,
FI02504A,
FI02505A,
FI02506A))
IN FI04A1A.A025A
AUDIT NONE
DATA CAPTURE NONE
CCSID EBCDIC
NOT VOLATILE;
--
LABEL ON TABLE OA1A.TFI025A1 IS 'EXTREMWERTE';
--
COMMENT ON TABLE OA1A.TFI025A1
IS 'Extremwerte pro Instrument; Version 30may2006/wah';
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=FI04A1A
-- Index=OA1A.IFI025A1 On OA1A.TFI025A1
------------------------------------------------------------------------
--
CREATE UNIQUE INDEX OA1A.IFI025A1
ON OA1A.TFI025A1
(FI02501A ASC,
FI02502A ASC,
FI02503A ASC,
FI02504A DESC,
FI02505A ASC,
FI02506A DESC)
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 5 PCTFREE 10
GBPCACHE CHANGED
CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Table space=A040A In Database FI04A1A --
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Database=FI04A1A Stogroup=GSMS
-- Table space=FI04A1A.A040A
------------------------------------------------------------------------
--
CREATE TABLESPACE A040A
IN FI04A1A
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 63 PCTFREE 14
GBPCACHE CHANGED
TRACKMOD YES
SEGSIZE 64
BUFFERPOOL BP2
LOCKSIZE ROW
LOCKMAX SYSTEM
CLOSE YES
COMPRESS YES
CCSID EBCDIC
DEFINE YES
MAXROWS 255;
--
COMMIT;
--
------------------------------------------------------------------------
-- Table=OA1A.TFI040A1 In FI04A1A.A040A
------------------------------------------------------------------------
--
CREATE TABLE OA1A.TFI040A1
(FI04001A DECIMAL(13, 0) NOT NULL,
FI04002A CHAR(12) FOR SBCS DATA NOT NULL,
FI04003A CHAR(4) FOR SBCS DATA NOT NULL,
FI04004A SMALLINT NOT NULL WITH DEFAULT 0,
FI04005A TIMESTAMP NOT NULL WITH DEFAULT,
FI04006A CHAR(4) FOR SBCS DATA NOT NULL
WITH DEFAULT,
FI04007A DECIMAL(31, 15) NOT NULL WITH DEFAULT,
FI04008A CHAR(8) FOR SBCS DATA NOT NULL
WITH DEFAULT '00000000',
FI04009A CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT 'I',
FI04010A DATE NOT NULL WITH DEFAULT,
FI04011A CHAR(8) FOR SBCS DATA NOT NULL
WITH DEFAULT USER ,
FI04012A SMALLINT NOT NULL WITH DEFAULT,
CONSTRAINT FI04001A
PRIMARY KEY (FI04001A,
FI04002A,
FI04003A,
FI04004A,
FI04005A))
IN FI04A1A.A040A
AUDIT NONE
DATA CAPTURE NONE
CCSID EBCDIC
NOT VOLATILE;
--
LABEL ON TABLE OA1A.TFI040A1 IS 'TAX-QUOTE TABLE';
--
COMMENT ON TABLE OA1A.TFI040A1
IS '"Tax-Quote"-Tabelle: Version vom 30may2006/wah';
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=FI04A1A
-- Index=OA1A.IFI040A1 On OA1A.TFI040A1
------------------------------------------------------------------------
--
CREATE UNIQUE INDEX OA1A.IFI040A1
ON OA1A.TFI040A1
(FI04001A ASC,
FI04002A ASC,
FI04003A ASC,
FI04004A ASC,
FI04005A DESC)
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 255 PCTFREE 4
GBPCACHE CHANGED
CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=OA1A.VFI010A1
------------------------------------------------------------------------
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","OA1A" ;
--
CREATE VIEW OA1A.VFI010A1(TKKEY, BOERSE, WHRG, VERFALL, GENERATION,
MUT_TIMESTAMP, TIT_WHRG, UNDERLAYER, LAUFNR, FUTURE, BASISPREIS,
KONTRAKT, KONTR_UNIT, VERSION, OPTIONSTYP, TOFFTYP, CALL_PUT,
TICKER, TICKER_SCHEMA, RIC_TICKER, CS_TA, ISIN_NR, TR_PRICE_CA,
TR_PRICE_CF, TR_PRICE_NP, TR_PRICE_UT, TR_PRICE_NT, VOLUME_AMT,
VOLUME_UT, SIZE_CURR, SIZE_UNIT, SIZE_UAMT, NONVERSE_STK,
HANDLHEIT, RECHNART, KOTIERUNG_ST, HANDEL_ST, MARKET_IMP,
BESTAND, BPL_ST, BPL_HT, BPL_KS, ALT_KS, BPL_HA, AIS_SP, BPL_IN,
BPL_SP, BPL_SP_DATE, AIS_PRIO, BPL_ART, BPL_TYP, HBOE,
TK_SPERRE, VDPS_SOLL, VDPS_REL, VDPS_QUA, VALOR_SC, STATUS,
GUELTIG_VON, QUELLE, LOG_EINTRAG, KONTRAKT_O, KONTRAKT_G,
MUT_STAT, CS_BUART, TITEL_N) AS
SELECT FI01001A, FI01002A, FI01003A, FI01004A, FI01005A, FI01006A,
FI01007A, FI01008A, FI01009A, FI01010A, FI01011A, FI01012A,
FI01013A, FI01014A, FI01015A, FI01016A, FI01017A, FI01018A,
FI01019A, FI01020A, FI01021A, FI01022A, FI01023A, FI01024A,
FI01025A, FI01026A, FI01027A, FI01028A, FI01029A, FI01030A,
FI01031A, FI01032A, FI01033A, FI01034A, FI01035A, FI01036A,
FI01037A, FI01038A, FI01039A, FI01040A, FI01041A, FI01042A,
FI01043A, FI01044A, FI01045A, FI01046A, FI01047A, FI01048A,
FI01049A, FI01050A, FI01051A, FI01052A, FI01053A, FI01054A,
FI01055A, FI01056A, FI01057A, FI01058A, FI01059A, FI01060A,
FI01061A, FI01062A, FI01063A, FI01064A, FI01065A, FI01066A
FROM OA1A.TFI010A1 ;
--
COMMENT ON TABLE OA1A.VFI010A1
IS '"Listing"-Tabelle: Version vom 30may2006/wah';
GRANT SELECT ON TABLE OA1A.VFI010A1 TO OA1A;
--
SET CURRENT SQLID='OA1A';
CREATE SYNONYM TEST1 FOR OA1A.VFI010A1;
SET CURRENT SQLID='S100447';
--
COMMIT;
--
------------------------------------------------------------------------
-- View=OA1A.VFI010A2
------------------------------------------------------------------------
CREATE VIEW OA1A.VFI010A2(TKKEY, BOERSE, WHRG, VERFALL, GENERATION,
MUT_TIMESTAMP, TIT_WHRG, UNDERLAYER, LAUFNR, FUTURE, BASISPREIS,
KONTRAKT, KONTR_UNIT, VERSION, OPTIONSTYP, TOFFTYP, CALL_PUT,
TICKER, TICKER_SCHEMA, RIC_TICKER, CS_TA, ISIN_NR, TR_PRICE_CA,
TR_PRICE_CF, TR_PRICE_NP, TR_PRICE_UT, TR_PRICE_NT, VOLUME_AMT,
VOLUME_UT, SIZE_CURR, SIZE_UNIT, SIZE_UAMT, NONVERSE_STK,
HANDLHEIT, RECHNART, KOTIERUNG_ST, HANDEL_ST, MARKET_IMP,
BESTAND, BPL_ST, BPL_HT, BPL_KS, ALT_KS, BPL_HA, AIS_SP, BPL_IN,
BPL_SP, BPL_SP_DATE, AIS_PRIO, BPL_ART, BPL_TYP, HBOE,
TK_SPERRE, VDPS_SOLL, VDPS_REL, VDPS_QUA, VALOR_SC, STATUS,
GUELTIG_VON, QUELLE, LOG_EINTRAG, KONTRAKT_O, KONTRAKT_G,
MUT_STAT, CS_BUART, TITEL_N, DOMICILE) AS
SELECT FI01001A, FI01002A, FI01003A, FI01004A, FI01005A, FI01006A,
FI01007A, FI01008A, FI01009A, FI01010A, FI01011A, FI01012A,
FI01013A, FI01014A, FI01015A, FI01016A, FI01017A, FI01018A,
FI01019A, FI01020A, FI01021A, FI01022A, FI01023A, FI01024A,
FI01025A, FI01026A, FI01027A, FI01028A, FI01029A, FI01030A,
FI01031A, FI01032A, FI01033A, FI01034A, FI01035A, FI01036A,
FI01037A, FI01038A, FI01039A, FI01040A, FI01041A, FI01042A,
FI01043A, FI01044A, FI01045A, FI01046A, FI01047A, FI01048A,
FI01049A, FI01050A, FI01051A, FI01052A, FI01053A, FI01054A,
FI01055A, FI01056A, FI01057A, FI01058A, FI01059A, FI01060A,
FI01061A, FI01062A, FI01063A, FI01064A, FI01065A, FI01066A,
FI01067A
FROM OA1A.TFI010A1 ;
GRANT SELECT ON TABLE OA1A.VFI010A2 TO OA1A;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=OA1A.VFI011A1
------------------------------------------------------------------------
CREATE VIEW OA1A.VFI011A1(UNDERLAYER, LAUFNR, VERFALL, BASISPREIS,
KONTRAKT, VERSION, MUT_TIMESTAMP, TKKEY) AS
SELECT FI01101A, FI01102A, FI01103A, FI01104A, FI01105A, FI01106A,
FI01107A, FI01108A
FROM OA1A.TFI011A1 ;
--
COMMENT ON TABLE OA1A.VFI011A1
IS 'key conversion table for fasten up access to main data storage';
GRANT SELECT ON TABLE OA1A.VFI011A1 TO OA1A;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=OA1A.VFI011A2
------------------------------------------------------------------------
CREATE VIEW OA1A.VFI011A2(UNDERLAYER, LAUFNR, VERFALL, BASISPREIS,
KONTRAKT, VERSION, MUT_TIMESTAMP, TKKEY, CSFIID) AS
SELECT FI01101A, FI01102A, FI01103A, FI01104A, FI01105A, FI01106A,
FI01107A, FI01108A, FI01109A
FROM OA1A.TFI011A1 ;
GRANT SELECT ON TABLE OA1A.VFI011A2 TO OA1A;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=OA1A.VFI011B1
------------------------------------------------------------------------
--
CREATE VIEW OA1A.VFI011B1(UNDERLAYER, LAUFNR, VERFALL, BASISPREIS,
KONTRAKT, VERSION, MUT_TIMESTAMP, TKKEY) AS
SELECT FI01101A, FI01102A, FI01103A, CHAR(FI01104A) as BASISPREIS,
CHAR(FI01105A) as KONTRAKT, FI01106A, FI01107A, FI01108A
FROM OA1A.TFI011A1 ;
--
COMMENT ON TABLE OA1A.VFI011B1
IS 'key conversion table for fasten up access to main data storage';
GRANT SELECT ON TABLE OA1A.VFI011B1 TO OA1A;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=OA1A.VFI021A1
------------------------------------------------------------------------
--
CREATE VIEW OA1A.VFI021A1(TKKEY, BOERSE, WHRG, VERFALL, GENERATION,
KDATUM1, KDATUM2, KDATUM3, KDATUM4, KDATUM5, ROWID1, ROWID2,
ROWID3, ROWID4, ROWID5) AS
SELECT FI02101A, FI02102A, FI02103A, FI02104A, FI02105A, FI02106A,
FI02107A, FI02108A, FI02109A, FI02110A, FI02111A, FI02112A,
FI02113A, FI02114A, FI02115A
FROM OA1A.TFI021A1 ;
GRANT SELECT ON TABLE OA1A.VFI021A1 TO OA1A;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=OA1A.VFI025A1
------------------------------------------------------------------------
CREATE VIEW OA1A.VFI025A1(TKKEY, BOERSE, WHRG, VERFALL, GENERATION,
MUT_TIMESTAMP, JH_KDATUM, JH_KA, JH_KURS, JH_FLAGS, JT_KDATUM,
JT_KA, JT_KURS, JT_FLAGS, QH_KDATUM, QH_KA, QH_KURS, QH_FLAGS,
QT_KDATUM, QT_KA, QT_KURS, QT_FLAGS, MH_KDATUM, MH_KA, MH_KURS,
MH_FLAGS, MT_KDATUM, MT_KA, MT_KURS, MT_FLAGS, WH_KDATUM, WH_KA,
WH_KURS, WH_FLAGS, WT_KDATUM, WT_KA, WT_KURS, WT_FLAGS,
VH_KDATUM, VH_KA, VH_KURS, VH_FLAGS, VT_KDATUM, VT_KA, VT_KURS,
VT_FLAGS, VJS_DATUM, VJS_KA, VJS_KURS, VJS_FLAGS, TE_KDATUM,
TE_KA, TE_KURS, TE_FLAGS, MM_KDATUM, KUM_MKURS, MM_ZAEHLER) AS
SELECT FI02501A, FI02502A, FI02503A, FI02504A, FI02505A, FI02506A,
FI02507A, FI02508A, FI02509A, FI02510A, FI02511A, FI02512A,
FI02513A, FI02514A, FI02515A, FI02516A, FI02517A, FI02518A,
FI02519A, FI02520A, FI02521A, FI02522A, FI02523A, FI02524A,
FI02525A, FI02526A, FI02527A, FI02528A, FI02529A, FI02530A,
FI02531A, FI02532A, FI02533A, FI02534A, FI02535A, FI02536A,
FI02537A, FI02538A, FI02539A, FI02540A, FI02541A, FI02542A,
FI02543A, FI02544A, FI02545A, FI02546A, FI02547A, FI02548A,
FI02549A, FI02550A, FI02551A, FI02552A, FI02553A, FI02554A,
FI02555A, FI02556A, FI02557A
FROM OA1A.TFI025A1 ;
--
COMMENT ON TABLE OA1A.VFI025A1
IS 'Extremwerte pro Instrument; Version 30may2006/wah';
--
COMMENT ON OA1A.VFI025A1
(MM_ZAEHLER IS 'Zähler zur Berechnung des Monatsmittelkurses',
KUM_MKURS IS 'kumulierter Monatskurs',
MM_KDATUM IS 'Kursdatum des kumulierten Monatsmittelkurses',
TE_FLAGS IS 'Steuerflags des Tagesendkurses',
TE_KURS IS 'Tagesendkurs',
TE_KA IS 'Kursart des Tagesendkurses',
TE_KDATUM IS 'Kursdatum des Tagesendkurses',
VJS_FLAGS IS 'Steuerflags des Vorjahresschlusskurses',
VJS_KURS IS 'Vorjahresschlusskurs',
VJS_KA IS 'Kursart des Vorjahresschlusskurses',
VJS_DATUM IS 'Kursdatum des Vorjahresschlusskurses',
VT_FLAGS IS 'Steuerflags des Vorjahrestiefstkurses',
VT_KURS IS 'Vorjahrestiefstkurs',
VT_KA IS 'Kursart des Vorjahrestiefstkurses',
VT_KDATUM IS 'Kursdatum des Vorjahrestiefstkurses',
VH_FLAGS IS 'Steuerflags des Vorjahreshöchstkurses',
VH_KURS IS 'Vorjahreshöchstkurs',
VH_KA IS 'Kursart des Vorjahreshöchstkurses',
VH_KDATUM IS 'Kursdatum des Vorjahreshöchstkurses',
WT_FLAGS IS 'Steuerflags des Wochentiefstkurses',
WT_KURS IS 'Wochentiefstkurs',
WT_KA IS 'Kursart des Wochentiefstkurses',
WT_KDATUM IS 'Kursdatum des Wochentiefstkurses',
WH_FLAGS IS 'Steuerflags des Wochenhöchstkurses',
WH_KURS IS 'Wochenhöchstkurs',
WH_KA IS 'Kursart des Wochenhöchstkurses',
WH_KDATUM IS 'Kursdatum des Wochenhöchstkurses',
MT_FLAGS IS 'Steuerflags des Monatstiefstkurses',
MT_KURS IS 'Monatstiefstkurs',
MT_KA IS 'Kursart des Monatstiefstkurses',
MT_KDATUM IS 'Kursdatum des Monatstiefstkurses',
MH_FLAGS IS 'Steuerflags des Monatshöchstkurses',
MH_KURS IS 'Monatshöchstkurs',
MH_KA IS 'Kursart des Monatshöchstkurses',
MH_KDATUM IS 'Kursdatum des Monatshöchstkurses',
QT_FLAGS IS 'Steuerflags des Quartaltiefstkurses',
QT_KURS IS 'Quartaltiefstkurs',
QT_KA IS 'Kursart des Quartaltiefstkurses',
QT_KDATUM IS 'Kursdatum des Quartaltiefstkurses',
QH_FLAGS IS 'Steuerflags des Quartalhöchstkurses',
QH_KURS IS 'Quartalhöchstkurs',
QH_KA IS 'Kursart des Quartalhöchstkurses',
QH_KDATUM IS 'Kursdatum des Quartalhöchstkurses',
JT_FLAGS IS 'Steuerflags des Jahrestiefstkurses',
JT_KURS IS 'Jahrestiefstkurs',
JT_KA IS 'Kursart des Jahrestiefstkurses',
JT_KDATUM IS 'Kursdatum des Jahrestiefstkurses',
JH_FLAGS IS 'Steuerflags des Jahreshöchstkurses',
JH_KURS IS 'Jahreshöchstkurs',
JH_KA IS 'Kursart des Jahreshöchstkurses',
JH_KDATUM IS 'Kursdatum des Jahreshöchstkurses',
MUT_TIMESTAMP IS 'Timestamp jeder Mutation',
GENERATION IS 'Selektive Markierung historisierter Stammdaten (Valor
/Generation)',
VERFALL IS 'Verfalldatum bei TOFF; Format yyyymmdd (der Tag ist bei
beiden Feldern immer mit Null oder Blank - KA4205 - abgefüllt)',
WHRG IS 'Währungsschlüssel; TK-Währung (Handelswährung) (auch im PRL
-6804 vorhaen)',
BOERSE IS 'Gesellschaftsschlüssel; Eindeutige Identifikation der Ins
titution innealb des vorgegebenen Schemas.',
TKKEY IS 'Instrumenten-Symbol; TK-Schlüssel zu dem entsprechenden Ti
tel. Bei Tofist es nicht der Key zum Basistitel. Dieser muss aus dem OFI
-Segment glsen werden.');
GRANT SELECT ON TABLE OA1A.VFI025A1 TO OA1A;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=OA1A.VFI040A1
------------------------------------------------------------------------
CREATE VIEW OA1A.VFI040A1(TKKEY, BOERSE, WHRG, GENERATION,
MUT_TIMESTAMP, JAHR_PSV, KURSWERT, STEUERFLAGS, STATUS,
GUELTIG_VON, LOG_EINTRAG, MUT_STAT) AS
SELECT FI04001A, FI04002A, FI04003A, FI04004A, FI04005A, FI04006A,
FI04007A, FI04008A, FI04009A, FI04010A, FI04011A, FI04012A
FROM OA1A.TFI040A1 ;
--
COMMENT ON TABLE OA1A.VFI040A1
IS 'Entity "Tax-Quote": Version vom 30may2006/wah';
--
COMMENT ON OA1A.VFI040A1
(MUT_STAT IS 'Handmutation durch Benutzer? 0=nein,1=ja',
LOG_EINTRAG IS 'Logeintrag',
GUELTIG_VON IS 'Gültig-von',
STATUS IS 'aktiver bzw. inaktiver Eintrag (Aktiv = "A", Inaktiv = "I
")',
STEUERFLAGS IS 'Konkatenat der "bit-Batterie" bestehend aus 8 Inform
ationselementen',
KURSWERT IS 'Kurs-Wert',
JAHR_PSV IS 'Steuerjahr',
MUT_TIMESTAMP IS 'Timestamp jeder Mutation',
GENERATION IS 'Selektive Markierung historisierter Stammdaten (Valor
/Generation)',
WHRG IS 'Währungsschlüssel; ist auch im PRL-6804 vorhanden',
BOERSE IS 'Gesellschaftsschlüssel',
TKKEY IS 'Instrumenten-Symbol; TK-Schlüssel zu dem entsprechenden Ti
tel. Bei Toffs muss der entsprechende Underlayer aus dem OFI-Segment gel
esen werden.');
GRANT SELECT ON TABLE OA1A.VFI040A1 TO OA1A;
--
COMMIT;
--
------------------------------------------------------------------------
-- ADB2GEN - End of generated DDL --
------------------------------------------------------------------------
--