zOs/SQL/TAV401
set current sqlid = 'S100447';
drop TABLESPACE dgdb9998.A401A01
;
commit;
CREATE TABLESPACE A401A01
IN Dgdb9998
USING STOGROUP GSMS
PRIQTY 48 SECQTY 7200
ERASE NO
FREEPAGE 0 PCTFREE 0
GBPCACHE CHANGED
TRACKMOD YES
SEGSIZE 64
BUFFERPOOL BP2
LOCKSIZE ANY
LOCKMAX SYSTEM
CLOSE YES
COMPRESS YES
CCSID EBCDIC
DEFINE YES
MAXROWS 255;
--
------------------------------------------------------------------------
-- Table=gdb9998.TAV401A1 In Dgdb9998.A401A01
------------------------------------------------------------------------
--
CREATE TABLE gdb9998.TAV401A1
(AV401001 CHAR(16) FOR SBCS DATA NOT NULL,
AV401002 CHAR(3) FOR SBCS DATA NOT NULL,
AV401003 CHAR(12) FOR SBCS DATA NOT NULL,
AV401004 CHAR(5) FOR SBCS DATA NOT NULL,
AV401005 DECIMAL(15, 3) WITH DEFAULT NULL,
AV401006 DECIMAL(15, 3) WITH DEFAULT NULL,
AV401007 DECIMAL(15, 3) NOT NULL,
AV401008 CHAR(1) FOR SBCS DATA NOT NULL,
AV401009 CHAR(4) FOR SBCS DATA NOT NULL,
AV401010 CHAR(2) FOR SBCS DATA NOT NULL,
AV401011 DECIMAL(15, 6) WITH DEFAULT NULL,
AV401012 DATE WITH DEFAULT NULL,
AV401013 CHAR(4) FOR SBCS DATA NOT NULL,
AV401014 CHAR(4) FOR SBCS DATA NOT NULL,
AV401015 DECIMAL(15, 6) WITH DEFAULT NULL,
AV401016 DECIMAL(15, 6) NOT NULL,
AV401017 CHAR(3) FOR SBCS DATA NOT NULL,
AV401018 DECIMAL(15, 6) NOT NULL,
AV401019 DECIMAL(15, 3) NOT NULL,
AV401020 DECIMAL(15, 3) NOT NULL,
AV401021 DATE WITH DEFAULT NULL,
AV401022 DECIMAL(15, 6) NOT NULL,
AV401023 DECIMAL(15, 6) NOT NULL,
AV401024 DECIMAL(15, 3) NOT NULL,
AV401025 DECIMAL(15, 3) NOT NULL,
AV401026 DECIMAL(15, 3) NOT NULL,
AV401027 DATE WITH DEFAULT NULL,
AV401028 DECIMAL(15, 6) WITH DEFAULT NULL,
AV401029 DECIMAL(15, 6) NOT NULL,
AV401030 DECIMAL(15, 6) NOT NULL,
AV401031 DATE WITH DEFAULT NULL,
AV401032 DECIMAL(15, 6) NOT NULL,
AV401033 DECIMAL(15, 6) NOT NULL,
AV401034 DECIMAL(15, 6) NOT NULL,
AV401035 DATE WITH DEFAULT NULL,
AV401036 DECIMAL(15, 6) NOT NULL,
AV401037 DATE WITH DEFAULT NULL,
AV401038 DECIMAL(15, 3) NOT NULL,
AV401039 DECIMAL(15, 6) NOT NULL,
AV401040 DECIMAL(15, 3) NOT NULL,
AV401041 CHAR(7) FOR SBCS DATA NOT NULL,
AV401042 CHAR(1) FOR SBCS DATA NOT NULL,
AV401043 DATE WITH DEFAULT NULL,
AV401044 DECIMAL(15, 3) NOT NULL,
AV401045 CHAR(1) FOR SBCS DATA NOT NULL,
AV401046 CHAR(4) FOR SBCS DATA NOT NULL,
AV401047 CHAR(2) FOR SBCS DATA NOT NULL,
AV401048 DATE WITH DEFAULT NULL,
-- AV401048ZZ DATE WITH DEFAULT NULL,
AV401049 DECIMAL(15, 6) NOT NULL,
AV401050 DECIMAL(15, 3) NOT NULL,
AV401051 CHAR(3) FOR SBCS DATA NOT NULL,
AV401052 DECIMAL(15, 3) NOT NULL,
AV401053 CHAR(1) FOR SBCS DATA NOT NULL,
AV401054 DECIMAL(15, 3) NOT NULL,
AV401055 CHAR(1) FOR SBCS DATA NOT NULL,
AV401056 DECIMAL(15, 6) NOT NULL,
AV401057 CHAR(1) FOR SBCS DATA NOT NULL,
AV401058 DECIMAL(15, 6) NOT NULL,
AV401059 DECIMAL(15, 3) NOT NULL,
AV401060 DECIMAL(15, 3) NOT NULL,
CONSTRAINT AV401001
PRIMARY KEY (AV401001,
AV401002,
AV401003,
AV401004))
IN Dgdb9998.A401A01
AUDIT NONE
DATA CAPTURE NONE
CCSID EBCDIC
NOT VOLATILE;
--
LABEL ON TABLE gdb9998.TAV401A1 IS 'Safekeeping Security';
--
LABEL ON gdb9998.TAV401A1
(AV401060 IS 'CollateralValue2CHF ',
AV401059 IS 'CollateralValue2ValCurr ',
AV401058 IS 'CollateralRatio2Base ',
AV401057 IS 'CollateralRatio2Type ',
AV401056 IS 'Interest-Rate ',
AV401055 IS 'CollateralRatioTyp ',
AV401054 IS 'Agio for Redemption ',
AV401053 IS 'AvgPurchPriceType ',
AV401052 IS 'CollateralValueCHF ',
AV401051 IS 'AnalysisCountryCd ',
AV401050 IS 'NonRealPLValueTotal ',
AV401049 IS 'NonRealPLPercTotal ',
AV401047 IS 'InterestFreqCd ',
AV401046 IS 'Analysis CurrCd ',
AV401045 IS 'Booking Type Cd ',
AV401044 IS 'MarketValue Pos Curr ',
AV401043 IS 'Maturity Date ',
AV401042 IS 'Dynamic Text Flag ',
AV401041 IS 'CSLife Fund Policy No ',
AV401040 IS 'CollateralValueValCurr ',
AV401039 IS 'CollateralRatio ',
AV401038 IS 'ExpEarnValCurr ',
AV401037 IS 'PriceYrLowDate ',
AV401036 IS 'PriceYrLow ',
AV401035 IS 'PriceYrHighDate ',
AV401034 IS 'PriceYrHigh ',
AV401033 IS 'YieldPercCP ',
AV401032 IS 'YieldPercMP ',
AV401031 IS 'ExchangeRateDate ',
AV401030 IS 'ExchangeRateCHF ',
AV401029 IS 'ExchangeRateCurr ',
AV401028 IS 'ContractStrikePrice ',
AV401027 IS 'ContractExpiryDate ',
AV401026 IS 'ContractSize ',
AV401025 IS 'NonRealPLValPrice ',
AV401024 IS 'NonRealPLValCurr ',
AV401023 IS 'NonRealPLPercPrice ',
AV401022 IS 'NonRealPLPercCurr ',
AV401021 IS 'AccruedInterestDate ',
AV401020 IS 'AccruedInterestCHF ',
AV401019 IS 'AccruedInterestValCurr ',
AV401018 IS 'Duration ',
AV401017 IS 'StockExchangeCd ',
AV401016 IS 'AvgPurchPriceCurrExRate ',
AV401015 IS 'AvgPurchPrice ',
AV401014 IS 'AvgPurchPriceCurrCd ',
AV401013 IS 'SecurityPriceCurrCd ',
AV401012 IS 'SecurityPriceDate ',
AV401011 IS 'SecurityPrice ',
AV401010 IS 'SecurityPriceType ',
AV401009 IS 'AssetClass ',
AV401008 IS 'ValueType ',
AV401007 IS 'NominalNo ',
AV401006 IS 'MarketValueCHF ',
AV401005 IS 'MarketValueValCurr ',
AV401004 IS 'Security Sequence No ',
AV401003 IS 'Security No ',
AV401002 IS 'Sequence No ',
AV401001 IS 'Safekeeping Acc No ');
--
------------------------------------------------------------------------
-- Database=Dgdb9998
-- Index=gdb9998.IAV401A0 On gdb9998.TAV401A1
------------------------------------------------------------------------
--
CREATE UNIQUE INDEX gdb9998.IAV401A0
ON gdb9998.TAV401A1
(AV401001 ASC,
AV401002 ASC,
AV401003 ASC,
AV401004 ASC)
USING STOGROUP GSMS
PRIQTY 48 SECQTY 7200
ERASE NO
FREEPAGE 0 PCTFREE 0
GBPCACHE CHANGED
CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFINE YES
PIECESIZE 2 G;
--
------------------------------------------------------------------------
-- Database=Dgdb9998
-- Index=gdb9998.IAV401A1 On gdb9998.TAV401A1
------------------------------------------------------------------------
--
CREATE UNIQUE INDEX gdb9998.IAV401A1
ON gdb9998.TAV401A1
(AV401003 ASC,
AV401001 ASC,
AV401002 ASC,
AV401004 ASC,
AV401007 ASC,
AV401014 ASC)
USING STOGROUP GSMS
PRIQTY 48 SECQTY 7200
ERASE NO
FREEPAGE 0 PCTFREE 0
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- ADB2GEN - End of generated DDL --
------------------------------------------------------------------------
--