zOs/TX/WK922DDS
------------------------------------------------------------------------
-- --
-- Database 2 Administration Tool (DB2 Admin) , program 5697-L90 --
-- --
-- ADB2GEN - Extract object definitions from the DB2 Catalog tables --
-- --
-- Title : SRC VDPS441C 3 --
-- --
-- Input prepared on : DBAF (915) Extract time : 2009-09-07 14:01 --
-- --
-- Catalog values overridden : none
-- --
-- Generate : SG=N DB=Y TS=Y TB=Y VW=Y IX=Y SY=Y AL=Y LB=Y CM=Y FK=Y --
-- TG=Y UT=N UF=N SP=N SQ=N RO=N --
-- Grants : SG=N DB=N TS=N TB=N VW=N SC=N UT=N UF=N SP=N SQ=N --
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- View=VDPSX.IDS_SMDS1501
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPSX';
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","F578271" ;
--
CREATE VIEW VDPSX.IDS_SMDS1501 AS
SELECT T1.INSTRUMENTID, T2.SYMBOLCH, T2.SYMBOLCSFI, T2.SYMBOLISIN,
T2.CATEGORYVDPS, T2.STATUSTYPE, T2.ROWSTATUS,
T2.UPDATETIMESTAMP, T2.CREATETIMESTAMP,
T2.INSTRUMENTUPDATETIMESTAMP, T2.INSTRUMENTCREATETIMESTAMP,
T1.LISTINGSYMBOLTK, T1.CURRENCY_WS80, T1.CURRENCY_I2,
T1.CURRENCY_I1, T1.MARKTPRACTIDSYMBOL, T1.FIRSTTRADINGDATE,
T1.LASTTRADINGDATE, T1.ISMAINTRADINGPLACE,
T1.ISHOMETRADINGPLACE, T1.ISBESTSPREAD,
T1.ISBESTSPREADPERCURR, T1.ISBESTVOLUME,
T1.ISBESTVOLUMEBESTSPREAD, T1.ISBESTVOLUMEPERCURR,
T1.ISCSBESTVENUEOVERALL, T1.ISCSBESTVENUEPERCURR,
T1.ISFUNDASSESSMENTSOURCE, T1.ISHIGHESTTICKS,
T1.ISNAVINDEPENDENTSOURCE, T1.ISPLACEOFQUOTE,
T1.ISPLACEOFLISTING, T1.ISPLACEOFTRADING,
T1.ISPRIMARYMARKETUSA, T1.ISSINGLETRADINGPLACE,
T1.LISTINGCLASSTYPE, T1.LISTINGSTATUSTYPE,
T1.PRICINGUNITNO, T1.PRICINGUNITTYPE, T1.TRADINGPLACE_BBX,
T1.TRADINGPLACE_BCN, T1.TRADINGPLACE_WS80,
T1.TRADINGPLACE_MIC, T1.TRADINGPLACE_RTX,
T1.PARENTTRADINGPLACE_BBX, T1.PARENTTRADINGPLACE_BCN,
T1.PARENTTRADINGPLACE_WS80, T1.PARENTTRADINGPLACE_MIC,
T1.PARENTTRADINGPLACE_RTX, T1.TRADINGSTATUSTYPE,
T1.TRADINGUNITTYPE, T1.LISTINGSYMBOLRT, T1.LISTINGSYMBOLBB,
T1.MINTRADINGUNITNO, T1.REGULARTRADINGUNITNO,
T1.NOMINALTRADINGUNITNO, T1.NMSTRADINGUNITNO,
T1.EMSTRADINGUNITNO, T1.SMSTRADINGUNITNO,
T1.PTSTRADINGUNITNO, T1.LISTINGNO, T3.CSLISTINGCODETYPE,
T3.CSMAINTRADPLACE_BBX, T3.CSMAINTRADPLACE_BCN,
T3.CSMAINTRADPLACE_WS80, T3.CSMAINTRADPLACE_MIC,
T3.CSMAINTRADPLACE_RTX, T4.IDSYMBOL IDSYMBOL_TKM,
T4.SCHEMESYMBOL SCHEMESYMBOL_TKM, T5.IDSYMBOL IDSYMBOL_TKL,
T5.SCHEMESYMBOL SCHEMESYMBOL_TKL, T6.IDSYMBOL IDSYMBOL_TKE,
T6.SCHEMESYMBOL SCHEMESYMBOL_TKE
FROM VDPSX.VTLISTING T1
INNER JOIN
VDPSX.VTINSTRFLATSYMBOLS T2
ON T2.INSTRUMENTID = T1.INSTRUMENTID
INNER JOIN
VDPSX.VTINSTRFLATDATA T3
ON T3.INSTRUMENTID = T2.INSTRUMENTID
LEFT OUTER JOIN
VDPSX.VTLISTINGIDENT T4
ON T4.INSTRUMENTID = T1.INSTRUMENTID AND T4.LISTINGNO = T1.
LISTINGNO AND T4.SCHEMESYMBOL = 'TKM'
LEFT OUTER JOIN
VDPSX.VTLISTINGIDENT T5
ON T5.INSTRUMENTID = T1.INSTRUMENTID AND T5.LISTINGNO = T1.
LISTINGNO AND T5.SCHEMESYMBOL = 'TKL'
LEFT OUTER JOIN
VDPSX.VTLISTINGIDENT T6
ON T6.INSTRUMENTID = T1.INSTRUMENTID AND T6.LISTINGNO = T1.
LISTINGNO AND T6.SCHEMESYMBOL = 'TKE' ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.IDS_VINBS138_V03
------------------------------------------------------------------------
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","F578255" ;
--
CREATE VIEW VDPSX.IDS_VINBS138_V03 AS
SELECT A.INSTRUMENTID, A.BOOKDATE, A.HOLDINGSINHOUSE,
A.HOLDINGSMINUS, A.HOLDINGSMINUSINHO, A.HOLDINGSRESERVE1,
A.HOLDINGSRESERVE2, A.HOLDINGSRESERVE3, A.HOLDINGSRESERVE4,
A.HOLDINGSRESERVE5, A.HOLDINGSRESERVE6, A.HOLDINGSTOTAL,
A.NOOFACCOUNTS, A.RESERVENUMBER2, A.RESERVENUMBER3,
A.UPDATETIMESTAMP, A.CREATETIMESTAMP, A.MANDATOR
FROM VDPSX.CTINSTRB42STOCK A ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.IDS_VINOP140_V04
------------------------------------------------------------------------
--
--
CREATE VIEW VDPSX.IDS_VINOP140_V04 AS
SELECT T1.INSTRUMENTID, T1.ROWSTATUS ROWSTATUS_FLTSYMB,
T1.SYMBOLCSFI, T1.SYMBOLCH, T1.SYMBOLISIN, T1.SYMBOLUS,
T1.SYMBOLXS, T1.SYMBOLGB, T1.SYMBOLLU, T1.SYMBOLDE,
T1.SYMBOLAT, T1.SYMBOLFR, T1.SYMBOLBE, T1.SYMBOLIT,
T1.SYMBOLNL, T1.SYMBOLJP, T1.SYMBOLJ2, T1.SYMBOLDK,
T1.SYMBOLSE, T1.SYMBOLI2, T1.SYMBOLI1, T1.SYMBOLT1,
T1.SYMBOLT2, T1.SYMBOLCSCURR, T1.CATEGORYVDPS,
T1.CATEGORYTKT, T1.CATEGORYTKSK, T1.CATEGORYTKZUS,
T1.CATEGORYTKPRK, T1.CATEGORYTKTZ, T1.CATEGORYMAZU,
T1.CATEGORYECBTR, T1.CATEGORYCFI, T1.CATEGORYEUZS,
T1.CATEGORYCSGTA, T1.CATEGORYCSGMS, T1.CATEGUSTAXREPORT,
T1.CATEGUSIRSADDITION,
T1.CSSTATUSTYPE CSSTATUSTYPE_FLTSYMB,
T1.STATUSTYPE STATUSTYPE_FLTSYMB, T2.PAYFREQUENCY,
T2.ISCALLFORTXREONLY, T2.ISREDEEMABLE, T2.ISRETRACTABLE,
T2.ISCONVERTBYHOLDER, T2.ISCONVERTBYISSUER,
T2.HASVOTINGRIGHTNO, T2.HASREDMPINVARCURR,
T2.HASMULTIUNDERLYERS, T2.MAINDEPOSITARY, T2.NOMINALAMOUNT,
T2.MINDENOMINATION, T2.EFFINTERESTRATE,
T2.REPAYPRICEAMOUNT, T2.REPAYPRICERATE, T2.POOLFACTOR,
T2.VOTINGRIGHTNO, T2.OUTSTANDINGCAPITAL, T2.ISSUEDCAPITAL,
T2.OUTSTANDCAPITALNO, T2.ISSUEDCAPITALNO, T2.ISSUEAMOUNT,
T2.ISSUEPRICE, T2.EXERCISEAMOUNT, T2.MINEXERCISEAMOUNT,
T2.HELDAMOUNT, T2.PAYAMOUNT, T2.INCOMETAXRATE,
T2.PREMIUMRATE, T2.PARTICIPATIONRATE, T2.REBATE,
T2.CSRATING, T2.CSRISKINDIDSYMBOL, T2.CSRISKINDSCHEMESYM,
T2.CSRISKINSTGRPIDSYM, T2.CSRISKINSGRPSCHSYM, T2.MDYRATING,
T2.SPRATING, T2.FITCHRATING, T2.LISTINGSYMBOLTKH,
T2.LISTINGSYMBOLRIC, T2.LISTINGSYMBOLBBI,
T2.NOMINALCURR_I1, T2.NOMINALCURR_I2, T2.NOMINALCURR_WS80,
T2.CSRISKCURRENCY_I1, T2.CSRISKCURRENCY_I2,
T2.CSRISKCURRENCY_WS80, T2.CSRISINSTRUMENT_CH,
T2.CSRISINSTRUMENT_ISIN, T2.CSRISINSTRUMENT_CSFI,
T2.CSRISKCOUNTRY_A2, T2.CSRISKCOUNTRY_WS80,
T2.REPAYPRICECURR_I1, T2.REPAYPRICECURR_I2,
T2.REPAYPRICECURR_WS80, T2.ISSUEPRICECURR_I1,
T2.ISSUEPRICECURR_I2, T2.ISSUEPRICECURR_WS80,
T2.EXERCISECURR_I1, T2.EXERCISECURR_I2,
T2.EXERCISECURR_WS80, T2.CSMAINTRADPLACE_BCN,
T2.CSMAINTRADPLACE_WS80, T2.CSMAINTRADPLACE_RTX,
T2.CSMAINTRADPLACE_BBX, T2.UNDERINSTRUMENT_CH,
T2.UNDERINSTRUMENT_ISIN, T2.UNDERINSTRUMENT_CSFI,
T2.ORIGINALISSUER_GK, T2.ISSUER_GK, T2.MAINDEPOSITARY_GK,
T2.EXPIRATIONDATE, T2.MATURITYDATE, T2.FIRSTPAYDATE,
T2.FIRSTPYDATEPERYEAR, T2.INTRSTDVDENFRDATE,
T2.CSRATINGDATE, T2.MDYRATINGDATE, T2.SPRATINGDATE,
T2.FITCHRATINGDATE, T2.SUBSCRBEGINDATE, T2.PAYMENTDATE,
T2.EXERCISEBEGINDATE, T2.SUBSCRPLNDENDDATE,
T2.EXERCISEENDDATE, T2.BVGTYPE, T2.CREDITWORTHINESSTP,
T2.COMMISSIONCODETYPE, T2.UNITTYPE, T2.CSUNITTYPE,
T2.EXPIRATIONTYPE, T2.STATUSTYPE STATUSTYPE_FLTDATA,
T2.REGISTRATIONTYPE, T2.BORROWERCATTYPE,
T2.CSLISTINGCODETYPE, T2.CSSTATUSTYPE CSSTATUSTYPE_FLTDATA,
T2.STATUSDETAILTYPE, T2.INCOMEMODETYPE,
T2.INTERESTCALCTYPE, T2.INTERESTTYPE, T2.PYFREQUNITTYPE,
T2.SUBSCRMETHODTYPE, T2.PLACEMENTTYPE, T2.PAYDIRECTIONTYPE,
T2.OPTIONTYPE, T2.SETTLESTYLETYPE, T2.CSFUNDTYPE,
T2.TRADINGSTATUSTYPE, T2.LISTINGSTATUSTYPE,
T2.EXERCISEPLACE, T2.NAME35_G, T2.NAME35_E, T2.NAME35_F,
T2.NAME35_I, T2.NAME35_N, T2.NAME45_G, T2.NAME45_E,
T2.NAME45_F, T2.NAME45_I, T2.NAME45_N, T2.SHORTNAME_G,
T2.SHORTNAME_E, T2.SHORTNAME_F, T2.SHORTNAME_I,
T2.SHORTNAME_N, T2.ISINTERNAL, T2.ISOTC,
T2.HASWITHHOLDINGTAX, T2.HASFEDERALSTAMPDUTY,
T2.ISCSMIFIDCOMPLEX, T2.MOSTLIQUIDMARKETLOCATION_A2,
T2.MOSTLIQUIDMARKETLOCATION_A3,
T2.MOSTLIQUIDMARKETLOCATION_WS80,
T2.MDYWATCHLISTSTATUSTYPE, T2.SPWATCHLISTSTATUSTYPE,
T2.FITCHWATCHLISTSTATUSTYPE, T2.OPTIONSTYLETYPE,
T2.CSMAINTRADINGCURR_I1, T2.CSMAINTRADINGCURR_I2,
T2.CSMAINTRADINGCURR_WS80, T2.CSRISKCOUNTRY_A3,
T2.LIQUIDATIONRIGHTTYPE, T2.CSMAINPARENTTRADINGPLACE_BCN,
T2.CSMAINPARENTTRADINGPLACE_RTX,
T2.CSMAINPARENTTRADINGPLACE_MIC,
T2.CSMAINPARENTTRADINGPLACE_BBX,
T2.CSMAINPARENTTRADINGPLACE_WS80,
T3.INSTITUTIONID INSTITUTIONID_ORG_ISSUER,
T3.ROWSTATUS ROWSTATUS_ORG_ISSUER,
T3.SYMBOLGK SYMBOLGK_ORG_ISSUER,
T3.SYMBOLCSINSTIID SYMBOLCSINSTIID_ORG_ISSUER,
T3.SYMBOLFITCH SYMBOLFITCH_ORG_ISSUER,
T3.SYMBOLSP SYMBOLSP_ORG_ISSUER,
T3.SYMBOLMDY SYMBOLMDY_ORG_ISSUER,
T3.SYMBOLCSGHDST SYMBOLCSGHDST_ORG_ISSUER,
T3.SYMBOLCSAREG SYMBOLCSAREG_ORG_ISSUER,
T3.SYMBOLIBEI SYMBOLIBEI_ORG_ISSUER,
T3.SYMBOLBCN SYMBOLBCN_ORG_ISSUER,
T3.SYMBOLBCA SYMBOLBCA_ORG_ISSUER,
T3.SYMBOLRTX SYMBOLRTX_ORG_ISSUER,
T3.SYMBOLBBX SYMBOLBBX_ORG_ISSUER,
T3.SYMBOLBBCX SYMBOLBBCX_ORG_ISSUER,
T3.SYMBOLMIC SYMBOLMIC_ORG_ISSUER,
T3.SYMBOLCSWS80BPL SYMBOLCSWS80BPL_ORG_ISSUER,
T3.SYMBOLCSID01 SYMBOLCSID01_ORG_ISSUER,
T3.SYMBOLCSID03 SYMBOLCSID03_ORG_ISSUER,
T3.SYMBOLCSID05 SYMBOLCSID05_ORG_ISSUER,
T3.SYMBOLCSID06 SYMBOLCSID06_ORG_ISSUER,
T3.CATEGORYVDPS CATEGORYVDPS_ORG_ISSUER,
T3.CATEGORYCSGDIV CATEGORYCSGDIV_ORG_ISSUER,
T3.CATEGORYCSGME CATEGORYCSGME_ORG_ISSUER,
T3.CATEGORYCSDG CATEGORYCSDG_ORG_ISSUER,
T3.CATEGORYTKINSTITUTION CATEGORYTKINSTI_ORG_ISSUER,
T3.STATUSTYPE STATUSTYPE_ORG_ISSUER,
T4.INSTITUTIONTYPE INSTITUTIONTYPE_ORG_ISSUER,
T4.ISGLOBALREGACC ISGLOBALREGACC_ORG_ISSUER,
T4.HASPENDINGACTVTY HASPENDINGACTVTY_ORG_ISSUER,
T4.ISRELEVANT ISRELEVANTV_ORG_ISSUER,
T4.ISONDB ISONDB_ORG_ISSUER,
T4.ACCOUNTINGCURR ACCOUNTINGCURR_ORG_ISSUER,
T4.INITIALMARGINRATE INITIALMARGINRATE_ORG_ISSUER,
T4.DOMICILE_A2 DOMICILE_A2_ORG_ISSUER,
T4.DOMICILE_WS80 DOMICILE_WS80_ORG_ISSUER,
T4.TAXDOMICILE_A2 TAXDOMICILE_A2_ORG_ISSUER,
T4.TAXDOMICILE_WS80 TAXDOMICILE_WS80_ORG_ISSUER,
T4.INDUSTRYCS INDUSTRYCS_ORG_ISSUER,
T4.INDUSTRYTKBN INDUSTRYTKBN_ORG_ISSUER,
T4.INDUSTRYMSCI INDUSTRYMSCI_ORG_ISSUER,
T4.INDUSTRYDJ INDUSTRYDJ_ORG_ISSUER,
T4.INDUSTRYFTSE INDUSTRYFTSE_ORG_ISSUER,
T4.INDUSTRYMFIB INDUSTRYMFIB_ORG_ISSUER,
T4.INDUSTRYMFIS INDUSTRYMFIS_ORG_ISSUER,
T4.INDUSTRYICB INDUSTRYICB_ORG_ISSUER,
T4.INDUSTRYBDF INDUSTRYBDF_ORG_ISSUER,
T4.TAXNUMBER TAXNUMBER_ORG_ISSUER,
T4.NONTAXABLENUMBER NONTAXABLENUMBER_ORG_ISSUER,
T4.HOUSENUMBER HOUSENUMBER_ORG_ISSUER,
T4.ZIP ZIP_ORG_ISSUER,
T4.TELEFAXNUMBER TELEFAXNUMBER_ORG_ISSUER,
T4.NATIONALBANKCODE NATIONALBANKCODE_ORG_ISSUER,
T4.BANKACCOUNTNUMBER BANKACCOUNTNUMBER_ORG_ISSUER,
T4.FOUNDATIONDATE FOUNDATIONDATE_ORG_ISSUER,
T4.PREVFINYEARENDDATE PREVFINYEARENDDATE_ORG_ISSUER,
T4.ACTFINYEARENDDATE ACTFINYEARENDDATE_ORG_ISSUER,
T4.REGISTERENTRYDATE REGISTERENTRYDATE_ORG_ISSUER,
T4.REGENTRYDELETIONDT REGENTRYDELETIONDT_ORG_ISSUER,
T4.YEARENDDATE YEARENDDATE_ORG_ISSUER,
T4.NEXTSEMESTERREPORT NEXTSEMESTERREPORT_ORG_ISSUER,
T4.NONTAXABLEDATE NONTAXABLEDATE_ORG_ISSUER,
T4.PREVIOUSYEARENDDT PREVIOUSYEARENDDT_ORG_ISSUER,
T4.CREATETIMESTAMP CREATETIMESTAMP_ORG_ISSUER,
T4.UPDATETIMESTAMP UPDATETIMESTAMP_ORG_ISSUER,
T4.MAINLANGUAGETYPE MAINLANGUAGETYPE_ORG_ISSUER,
T4.KANTONSCODETYPE KANTONSCODETYPE_ORG_ISSUER,
T4.LEGALFORMTYPE LEGALFORMTYPE_ORG_ISSUER,
T4.TRUSTLEGALGUIDETP TRUSTLEGALGUIDETP_ORG_ISSUER,
T4.TRUSTSTATUSTYPE TRUSTSTATUSTYPE_ORG_ISSUER,
T4.FOTYPE FOTYPE_ORG_ISSUER,
T4.DATASTATUSTYPE DATASTATUSTYPE_ORG_ISSUER,
T4.BLOCKINGCODETYPE BLOCKINGCODETYPE_ORG_ISSUER,
T4.CITY CITY_ORG_ISSUER,
T4.INTERNETDOMAIN INTERNETDOMAIN_ORG_ISSUER,
T4.STREET STREET_ORG_ISSUER,
T4.EMAILNAME EMAILNAME_ORG_ISSUER,
T4.PHONENUMBER PHONENUMBER_ORG_ISSUER,
T4.IBAN IBAN_ORG_ISSUER,
T4.SHORTNAME_G SHORTNAME_G_ORG_ISSUER,
T4.SHORTNAME_E SHORTNAME_E_ORG_ISSUER,
T4.SHORTNAME_F SHORTNAME_F_ORG_ISSUER,
T4.SHORTNAME_I SHORTNAME_I_ORG_ISSUER,
T4.SHORTNAME_N SHORTNAME_N_ORG_ISSUER,
T4.NAME_G NAME_G_ORG_ISSUER, T4.NAME_E NAME_E_ORG_ISSUER,
T4.NAME_F NAME_F_ORG_ISSUER, T4.NAME_I NAME_I_ORG_ISSUER,
T4.NAME_N NAME_N_ORG_ISSUER,
T4.HASADDRESS HASADDRESS_ORG_ISSUER,
T4.ADDRESS ADDRESS_ORG_ISSUER,
T4.ADDRESSDESCR ADDRESSDESCR_ORG_ISSUER,
T4.HEADOFFICEDESCR HEADOFFICEDESCR_ORG_ISSUER,
T4.MDYISSUERRATING MDYISSUERRATING_ORG_ISSUER,
T4.MDYISSUERRATINGDATE MDYISSUERRATINGDT_ORG_ISSUER,
T4.MDYISSUERWATCHLISTSTATUSTYPE
MDYWLISTSTATUSTYPE_ORG_ISSUER,
T4.SPISSUERRATING SPISSUERRATING_ORG_ISSUER,
T4.SPISSUERRATINGDATE SPISSUERRATINGDATE_ORG_ISSUER,
T4.SPISSUERWATCHLISTSTATUSTYPE SPLISTSTATUSTYPE_ORG_ISSUER,
T4.FITCHISSUERRATING FITCHISSUERRT_ORG_ISSUER,
T4.FITCHISSUERRATINGDATE FITCHISSUERRTDT_ORG_ISSUER,
T4.FITCHISSUERWATCHLISTSTATUSTYPE FITCHWATCHSTTP_ORG_ISSUER,
T4.DOMICILE_A3 DOMICILE_A3_ORG_ISSUER,
T4.TAXDOMICILE_A3 TAXDOMICILE_A3_ORG_ISSUER,
T4.ADDRESSLOCATION_A2 ADDRESS_A2_ORG_ISSUER,
T4.ADDRESSLOCATION_A3 ADDRESS_A3_ORG_ISSUER,
T4.ADDRESSLOCATION_WS80 ADDRESS_WS80_ORG_ISSUER,
T5.INSTITUTIONID INSTITUTIONID_ISSUER,
T5.ROWSTATUS ROWSTATUS_ISSUER, T5.SYMBOLGK SYMBOLGK_ISSUER,
T5.SYMBOLCSINSTIID SYMBOLCSINSTIID_ISSUER,
T5.SYMBOLFITCH SYMBOLFITCH_ISSUER,
T5.SYMBOLSP SYMBOLSP_ISSUER, T5.SYMBOLMDY SYMBOLMDY_ISSUER,
T5.SYMBOLCSGHDST SYMBOLCSGHDST_ISSUER,
T5.SYMBOLCSAREG SYMBOLCSAREG_ISSUER,
T5.SYMBOLIBEI SYMBOLIBEI_ISSUER,
T5.SYMBOLBCN SYMBOLBCN_ISSUER,
T5.SYMBOLBCA SYMBOLBCA_ISSUER,
T5.SYMBOLRTX SYMBOLRTX_ISSUER,
T5.SYMBOLBBX SYMBOLBBX_ISSUER,
T5.SYMBOLBBCX SYMBOLBBCX_ISSUER,
T5.SYMBOLMIC SYMBOLMIC_ISSUER,
T5.SYMBOLCSWS80BPL SYMBOLCSWS80BPL_ISSUER,
T5.SYMBOLCSID01 SYMBOLCSID01_ISSUER,
T5.SYMBOLCSID03 SYMBOLCSID03_ISSUER,
T5.SYMBOLCSID05 SYMBOLCSID05_ISSUER,
T5.SYMBOLCSID06 SYMBOLCSID06_ISSUER,
T5.CATEGORYVDPS CATEGORYVDPS_ISSUER,
T5.CATEGORYCSGDIV CATEGORYCSGDIV_ISSUER,
T5.CATEGORYCSGME CATEGORYCSGME_ISSUER,
T5.CATEGORYCSDG CATEGORYCSDG_ISSUER,
T5.CATEGORYTKINSTITUTION CATEGORYTKINSTITUTION_ISSUER,
T5.STATUSTYPE STATUSTYPE_ISSUER,
T6.INSTITUTIONTYPE INSTITUTIONTYPE_ISSUER,
T6.ISGLOBALREGACC ISGLOBALREGACC_ISSUER,
T6.HASPENDINGACTVTY HASPENDINGACTVTY_ISSUER,
T6.ISRELEVANT ISRELEVANTV_ISSUER, T6.ISONDB ISONDB_ISSUER,
T6.INITIALMARGINRATE INITIALMARGINRATE_ISSUER,
T6.DOMICILE_A2 DOMICILE_A2_ISSUER,
T6.DOMICILE_WS80 DOMICILE_WS80_ISSUER,
T6.TAXDOMICILE_A2 TAXDOMICILE_A2_ISSUER,
T6.TAXDOMICILE_WS80 TAXDOMICILE_WS80_ISSUER,
T6.INDUSTRYCS INDUSTRYCS_ISSUER,
T6.INDUSTRYTKBN INDUSTRYTKBN_ISSUER,
T6.INDUSTRYMSCI INDUSTRYMSCI_ISSUER,
T6.INDUSTRYDJ INDUSTRYDJ_ISSUER,
T6.INDUSTRYFTSE INDUSTRYFTSE_ISSUER,
T6.INDUSTRYMFIB INDUSTRYMFIB_ISSUER,
T6.INDUSTRYMFIS INDUSTRYMFIS_ISSUER,
T6.INDUSTRYICB INDUSTRYICB_ISSUER,
T6.INDUSTRYBDF INDUSTRYBDF_ISSUER,
T6.TAXNUMBER TAXNUMBER_ISSUER,
T6.NONTAXABLENUMBER NONTAXABLENUMBER_ISSUER,
T6.HOUSENUMBER HOUSENUMBER_ISSUER, T6.ZIP ZIP_ISSUER,
T6.TELEFAXNUMBER TELEFAXNUMBER_ISSUER,
T6.NATIONALBANKCODE NATIONALBANKCODE_ISSUER,
T6.BANKACCOUNTNUMBER BANKACCOUNTNUMBER_ISSUER,
T6.FOUNDATIONDATE FOUNDATIONDATE_ISSUER,
T6.PREVFINYEARENDDATE PREVFINYEARENDDATE_ISSUER,
T6.ACTFINYEARENDDATE ACTFINYEARENDDATE_ISSUER,
T6.REGISTERENTRYDATE REGISTERENTRYDATE_ISSUER,
T6.REGENTRYDELETIONDT REGENTRYDELETIONDT_ISSUER,
T6.YEARENDDATE YEARENDDATE_ISSUER,
T6.NEXTSEMESTERREPORT NEXTSEMESTERREPORT_ISSUER,
T6.NONTAXABLEDATE NONTAXABLEDATE_ISSUER,
T6.PREVIOUSYEARENDDT PREVIOUSYEARENDDT_ISSUER,
T6.CREATETIMESTAMP CREATETIMESTAMP_ISSUER,
T6.UPDATETIMESTAMP UPDATETIMESTAMP_ISSUER,
T6.MAINLANGUAGETYPE MAINLANGUAGETYPE_ISSUER,
T6.KANTONSCODETYPE KANTONSCODETYPE_ISSUER,
T6.LEGALFORMTYPE LEGALFORMTYPE_ISSUER,
T6.TRUSTLEGALGUIDETP TRUSTLEGALGUIDETP_ISSUER,
T6.TRUSTSTATUSTYPE TRUSTSTATUSTYPE_ISSUER,
T6.FOTYPE FOTYPE_ISSUER,
T6.DATASTATUSTYPE DATASTATUSTYPE_ISSUER,
T6.BLOCKINGCODETYPE BLOCKINGCODETYPE_ISSUER,
T6.CITY CITY_ISSUER,
T6.INTERNETDOMAIN INTERNETDOMAIN_ISSUER,
T6.STREET STREET_ISSUER, T6.EMAILNAME EMAILNAME_ISSUER,
T6.PHONENUMBER PHONENUMBER_ISSUER, T6.IBAN IBAN_ISSUER,
T6.SHORTNAME_G SHORTNAME_G_ISSUER,
T6.SHORTNAME_E SHORTNAME_E_ISSUER,
T6.SHORTNAME_F SHORTNAME_F_ISSUER,
T6.SHORTNAME_I SHORTNAME_I_ISSUER,
T6.SHORTNAME_N SHORTNAME_N_ISSUER, T6.NAME_G NAME_G_ISSUER,
T6.NAME_E NAME_E_ISSUER, T6.NAME_F NAME_F_ISSUER,
T6.NAME_I NAME_I_ISSUER, T6.NAME_N NAME_N_ISSUER,
T6.HASADDRESS HASADDRESS_ISSUER, T6.ADDRESS ADDRESS_ISSUER,
T6.ADDRESSDESCR ADDRESSDESCR_ISSUER,
T6.HEADOFFICEDESCR HEADOFFICEDESCR_ISSUER,
T6.MODIFICATIONREASON MODIFICATIONREASON_ISSUER,
T6.MDYISSUERRATING MDYISSUERRATING_ISSUER,
T6.MDYISSUERRATINGDATE MDYISSUERRATINGDATE_ISSUER,
T6.MDYISSUERWATCHLISTSTATUSTYPE
MDYWATCHLISTSTATUSTYPE_ISSUER,
T6.SPISSUERRATING SPISSUERRATING_ISSUER,
T6.SPISSUERRATINGDATE SPISSUERRATINGDATE_ISSUER,
T6.SPISSUERWATCHLISTSTATUSTYPE SPWATCHLISTSTATUSTYPE_ISSUER,
T6.FITCHISSUERRATING FITCHISSUERRATING_ISSUER,
T6.FITCHISSUERRATINGDATE FITCHISSUERRATINGDATE_ISSUER,
T6.FITCHISSUERWATCHLISTSTATUSTYPE FITCHWATCHLISTSTTP_ISSUER,
T6.DOMICILE_A3 DOMICILE_A3_ISSUER,
T6.TAXDOMICILE_A3 TAXDOMICILE_A3_ISSUER,
T6.ADDRESSLOCATION_A2 ADDRESSLOCATION_A2_ISSUER,
T6.ADDRESSLOCATION_A3 ADDRESSLOCATION_A3_ISSUER,
T6.ADDRESSLOCATION_WS80 ADDRESSLOCATION_WS80_ISSUER,
T7.BESTVENUEUPDATETS, T7.EUROCLEARDEPO, T7.FISNPOOLNUMBER,
T7.FISNPROGRAM, T7.FISNTRANCHE, T7.FISNTRUST,
T7.FISNUNDERLYING, T7.HYBRIDACRONYMTYPE, T7.IDFORMATTYPE,
T7.ISAUTOMATEDDISTRIB, T7.ISBLUECHIP, T7.NTIPTYPE,
T7.OTEXMARKETMAKER, T7.OTEXORDERDESK, T7.OTEXRISKDOMICILE,
T7.BRANDNAME, T7.PRODUCTNAME, T7.CSPRODUCTCATEGORY,
T7.ISMANAGEDBYCS, T7.CSBTVRELEVANCETYPE,
T7.INVESTORINFOTYPE, T7.UNDERLYINGMGMTTYPE,
T7.INITIALBONDFLOORRATE, T7.FINALBONDFLOORRATE,
T7.SWAPRATE, T7.ISUNDERLYINGLINKED, T7.RIGHTISSUETYPE,
T7.ISRIGHTISSUETRADING, T7.RIGHTISSUETRADINGFROMDATE,
T7.RIGHTISSUETRADINGUNTILDATE, T7.RIGHTISSUETRADINGAT,
T7.RIGHTISSUEFRACTIONTYPE, T7.RIGHTISSUELASTSPLITDATE,
T7.HASUNDERLYINGUSSECURITIES, T7.ISISSUERESNATIONALS,
T7.ISISSUERESNONNATIONALS, T7.SHAREREGISTRYTYPE,
T7.ACCRUEDINTERESTTYPE, T8.DEFREPAYMENTPERIOD,
T8.POSITIONLIMIT, T8.BONDFLOOR, T8.DISCOUNT,
T8.GUARANTEREPAYPRICE, T8.RESERVENUMBER2,
T8.RESERVENUMBER3, T8.RESERVENUMBER4, T8.RESERVENUMBER5,
T8.MANDATOR, T8.RESERVETEXT1, T8.RESERVETEXT3,
T8.CSBOARDLOT, T8.CSINCOMETAXTYPE, T8.POSITIONCURRTYPE,
T8.KANTONSCODETYPE, T8.CSEVENTDTCODETYPE,
T8.CSFUNDTYPE CSFUNDTYPE_SP42, T8.CSRELEVANCEDATE,
T8.HASQUOTESBLOCK, T8.HASFUNDSUNBUNDLING,
T8.FUNDDEPOSITARY, T8.FUNDCATEGORY,
T9.CREATETIMESTAMP CREATETIMESTAMP_INSTR,
T9.UPDATETIMESTAMP UPDATETIMESTAMP_INSTR, T1.SYMBOLSPIRIT,
T2.UNDERINSTRUMENT, T2.PREPARTICLE_G, T2.PREPARTICLE_E,
T2.PREPARTICLE_F, T2.PREPARTICLE_I, T2.PREPARTICLE_N,
T2.POSTPARTICLE_G, T2.POSTPARTICLE_E, T2.POSTPARTICLE_F,
T2.POSTPARTICLE_I, T2.POSTPARTICLE_N, T9.NAME_G, T9.NAME_E,
T9.NAME_F, T9.NAME_I, T9.NAME_N,
T9.ISRELEVANT ISRELEVANT_INSTR, T2.MAINLANGUAGETYPE,
T9.NOMINALCURR, T9.COMPOUNDTYPE, T9.PORTFOLIONO,
T9.ISINSTANCE, T9.CAPMARKETLOCATION, T9.STATUSDATE,
T9.TOFFUNDERTYPE, T9.DESCRIPTION_G, T9.DESCRIPTION_E,
T9.DESCRIPTION_F, T9.DESCRIPTION_I, T9.DESCRIPTION_N,
T2.ISSUEPRICERATE, T2.TITELARTZUSATZTEXT,
T2.BORROWINGLIMITTYPE, T2.ISVSTQUALITYCHECKED
FROM VDPSX.VTINSTRFLATSYMBOLS T1
INNER JOIN
VDPSX.VTINSTRFLATDATA T2
ON T2.INSTRUMENTID = T1.INSTRUMENTID
INNER JOIN
VDPSX.VTINSTIFLATSYMBOLS T3
ON T3.INSTITUTIONID = T2.ORIGINALISSUER
INNER JOIN
VDPSX.VTINSTITUTION T4
ON T4.INSTITUTIONID = T2.ORIGINALISSUER
INNER JOIN
VDPSX.VTINSTRUMENT T9
ON T9.INSTRUMENTID = T1.INSTRUMENTID
INNER JOIN
VDPSX.VTINSTIFLATSYMBOLS T5
ON T5.INSTITUTIONID = T2.ISSUER
INNER JOIN
VDPSX.VTINSTITUTION T6
ON T6.INSTITUTIONID = T2.ISSUER
LEFT OUTER JOIN
VDPSX.CTINSTRDETAILS T7
ON T7.INSTRUMENTID = T1.INSTRUMENTID
LEFT OUTER JOIN
VDPSX.CTINSTRSP42DETAILS T8
ON T8.INSTRUMENTID = T1.INSTRUMENTID ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.IDS_VINOP141_V03
------------------------------------------------------------------------
--
--
CREATE VIEW VDPSX.IDS_VINOP141_V03 AS
SELECT T1.INSTRUMENTID, T1.ROWSTATUS, T1.SYMBOLCSFI, T1.SYMBOLCH,
T1.SYMBOLISIN, T1.SYMBOLUS, T1.SYMBOLXS, T1.SYMBOLGB,
T1.SYMBOLLU, T1.SYMBOLDE, T1.SYMBOLAT, T1.SYMBOLFR,
T1.SYMBOLBE, T1.SYMBOLIT, T1.SYMBOLNL, T1.SYMBOLJP,
T1.SYMBOLJ2, T1.SYMBOLDK, T1.SYMBOLSE, T1.SYMBOLI2,
T1.SYMBOLI1, T1.SYMBOLT1, T1.SYMBOLT2, T1.SYMBOLCSCURR,
T1.CATEGORYVDPS, T1.CATEGORYTKT, T1.CATEGORYTKSK,
T1.CATEGORYTKZUS, T1.CATEGORYTKPRK, T1.CATEGORYTKTZ,
T1.CATEGORYMAZU, T1.CATEGORYECBTR, T1.CATEGORYCFI,
T1.CATEGORYEUZS, T1.CATEGORYCSGTA, T1.CATEGORYCSGMS,
T1.CATEGUSTAXREPORT, T1.CATEGUSIRSADDITION,
T1.CSSTATUSTYPE CSSTATUSTYPE_FLTSYMB,
T1.STATUSTYPE STATUSTYPE_FLTSYMB, T2.PAYFREQUENCY,
T2.ISCALLFORTXREONLY, T2.ISREDEEMABLE, T2.ISRETRACTABLE,
T2.ISCONVERTBYHOLDER, T2.ISCONVERTBYISSUER,
T2.HASVOTINGRIGHTNO, T2.HASREDMPINVARCURR,
T2.HASMULTIUNDERLYERS, T2.CSMAINTRADPLACE,
T2.ORIGINALISSUER, T2.ISSUER, T2.UNDERINSTRUMENT,
T2.NOMINALCURR, T2.CSRISKCURRENCY, T2.CSRISKCOUNTRY,
T2.CSRISINSTRUMENT, T2.REPAYPRICECURR, T2.ISSUEPRICECURR,
T2.EXERCISECURR, T2.MAINDEPOSITARY, T2.NOMINALAMOUNT,
T2.MINDENOMINATION, T2.EFFINTERESTRATE,
T2.REPAYPRICEAMOUNT, T2.REPAYPRICERATE, T2.POOLFACTOR,
T2.VOTINGRIGHTNO, T2.OUTSTANDINGCAPITAL, T2.ISSUEDCAPITAL,
T2.OUTSTANDCAPITALNO, T2.ISSUEDCAPITALNO, T2.ISSUEAMOUNT,
T2.ISSUEPRICE, T2.EXERCISEAMOUNT, T2.MINEXERCISEAMOUNT,
T2.HELDAMOUNT, T2.PAYAMOUNT, T2.INCOMETAXRATE,
T2.PREMIUMRATE, T2.PARTICIPATIONRATE, T2.REBATE,
T2.CSRATING, T2.CSRISKINDIDSYMBOL, T2.CSRISKINDSCHEMESYM,
T2.CSRISKINSTGRPIDSYM, T2.CSRISKINSGRPSCHSYM, T2.MDYRATING,
T2.SPRATING, T2.FITCHRATING, T2.LISTINGSYMBOLTKH,
T2.LISTINGSYMBOLRIC, T2.LISTINGSYMBOLBBI,
T2.NOMINALCURR_I1, T2.NOMINALCURR_I2, T2.NOMINALCURR_WS80,
T2.CSRISKCURRENCY_I1, T2.CSRISKCURRENCY_I2,
T2.CSRISKCURRENCY_WS80, T2.CSRISINSTRUMENT_CH,
T2.CSRISINSTRUMENT_ISIN, T2.CSRISINSTRUMENT_CSFI,
T2.CSRISKCOUNTRY_A2, T2.CSRISKCOUNTRY_WS80,
T2.REPAYPRICECURR_I1, T2.REPAYPRICECURR_I2,
T2.REPAYPRICECURR_WS80, T2.ISSUEPRICECURR_I1,
T2.ISSUEPRICECURR_I2, T2.ISSUEPRICECURR_WS80,
T2.EXERCISECURR_I1, T2.EXERCISECURR_I2,
T2.EXERCISECURR_WS80, T2.CSMAINTRADPLACE_BCN,
T2.CSMAINTRADPLACE_WS80, T2.CSMAINTRADPLACE_RTX,
T2.CSMAINTRADPLACE_BBX, T2.UNDERINSTRUMENT_CH,
T2.UNDERINSTRUMENT_ISIN, T2.UNDERINSTRUMENT_CSFI,
T2.ORIGINALISSUER_GK, T2.ISSUER_GK, T2.MAINDEPOSITARY_GK,
T2.EXPIRATIONDATE, T2.MATURITYDATE, T2.FIRSTPAYDATE,
T2.FIRSTPYDATEPERYEAR, T2.INTRSTDVDENFRDATE,
T2.CSRATINGDATE, T2.MDYRATINGDATE, T2.SPRATINGDATE,
T2.FITCHRATINGDATE, T2.SUBSCRBEGINDATE, T2.PAYMENTDATE,
T2.EXERCISEBEGINDATE, T2.SUBSCRPLNDENDDATE,
T2.EXERCISEENDDATE, T2.BVGTYPE, T2.CREDITWORTHINESSTP,
T2.COMMISSIONCODETYPE, T2.UNITTYPE, T2.CSUNITTYPE,
T2.EXPIRATIONTYPE, T2.STATUSTYPE, T2.REGISTRATIONTYPE,
T2.BORROWERCATTYPE, T2.CSLISTINGCODETYPE, T2.CSSTATUSTYPE,
T2.STATUSDETAILTYPE, T2.INCOMEMODETYPE,
T2.INTERESTCALCTYPE, T2.INTERESTTYPE, T2.PYFREQUNITTYPE,
T2.SUBSCRMETHODTYPE, T2.PLACEMENTTYPE, T2.PAYDIRECTIONTYPE,
T2.OPTIONTYPE, T2.SETTLESTYLETYPE, T2.CSFUNDTYPE,
T2.TRADINGSTATUSTYPE, T2.LISTINGSTATUSTYPE,
T2.EXERCISEPLACE, T2.NAME35_G, T2.NAME35_E, T2.NAME35_F,
T2.NAME35_I, T2.NAME35_N, T2.NAME45_G, T2.NAME45_E,
T2.NAME45_F, T2.NAME45_I, T2.NAME45_N, T2.SHORTNAME_G,
T2.SHORTNAME_E, T2.SHORTNAME_F, T2.SHORTNAME_I,
T2.SHORTNAME_N, T2.PREPARTICLE_G, T2.PREPARTICLE_E,
T2.PREPARTICLE_F, T2.PREPARTICLE_I, T2.PREPARTICLE_N,
T2.POSTPARTICLE_G, T2.POSTPARTICLE_E, T2.POSTPARTICLE_F,
T2.POSTPARTICLE_I, T2.POSTPARTICLE_N, T2.ISINTERNAL,
T2.ISOTC, T2.HASWITHHOLDINGTAX, T2.HASFEDERALSTAMPDUTY,
T2.ISCSMIFIDCOMPLEX, T2.MOSTLIQUIDMARKETLOCATION,
T2.MOSTLIQUIDMARKETLOCATION_A2,
T2.MOSTLIQUIDMARKETLOCATION_A3,
T2.MOSTLIQUIDMARKETLOCATION_WS80,
T2.MDYWATCHLISTSTATUSTYPE, T2.SPWATCHLISTSTATUSTYPE,
T2.FITCHWATCHLISTSTATUSTYPE, T2.OPTIONSTYLETYPE,
T2.CSMAINTRADINGCURR, T2.CSMAINTRADINGCURR_I1,
T2.CSMAINTRADINGCURR_I2, T2.CSMAINTRADINGCURR_WS80,
T2.CSRISKCOUNTRY_A3, T2.LIQUIDATIONRIGHTTYPE,
T2.CSMAINPARENTTRADINGPLACE,
T2.CSMAINPARENTTRADINGPLACE_BCN,
T2.CSMAINPARENTTRADINGPLACE_RTX,
T2.CSMAINPARENTTRADINGPLACE_MIC,
T2.CSMAINPARENTTRADINGPLACE_BBX,
T2.CSMAINPARENTTRADINGPLACE_WS80,
T3.PAYFREQUENCY UND_PAYFREQUENCY,
T3.ISCALLFORTXREONLY UND_ISCALLFORTXREONLY,
T3.ISREDEEMABLE UND_ISREDEEMABLE,
T3.ISRETRACTABLE UND_ISRETRACTABLE,
T3.ISCONVERTBYHOLDER UND_ISCONVERTBYHOLDER,
T3.ISCONVERTBYISSUER UND_ISCONVERTBYISSUER,
T3.HASVOTINGRIGHTNO UND_HASVOTINGRIGHTNO,
T3.HASREDMPINVARCURR UND_HASREDMPINVARCURR,
T3.HASMULTIUNDERLYERS UND_HASMULTIUNDERLYERS,
T3.CSMAINTRADPLACE UND_CSMAINTRADPLACE,
T3.ORIGINALISSUER UND_ORIGINALISSUER, T3.ISSUER UND_ISSUER,
T3.UNDERINSTRUMENT UND_UNDERINSTRUMENT,
T3.NOMINALCURR UND_NOMINALCURR,
T3.CSRISKCURRENCY UND_CSRISKCURRENCY,
T3.CSRISKCOUNTRY UND_CSRISKCOUNTRY,
T3.CSRISINSTRUMENT UND_CSRISINSTRUMENT,
T3.REPAYPRICECURR UND_REPAYPRICECURR,
T3.ISSUEPRICECURR UND_ISSUEPRICECURR,
T3.EXERCISECURR UND_EXERCISECURR,
T3.MAINDEPOSITARY UND_MAINDEPOSITARY,
T3.NOMINALAMOUNT UND_NOMINALAMOUNT,
T3.MINDENOMINATION UND_MINDENOMINATION,
T3.EFFINTERESTRATE UND_EFFINTERESTRATE,
T3.REPAYPRICEAMOUNT UND_REPAYPRICEAMOUNT,
T3.REPAYPRICERATE UND_REPAYPRICERATE,
T3.POOLFACTOR UND_POOLFACTOR,
T3.VOTINGRIGHTNO UND_VOTINGRIGHTNO,
T3.OUTSTANDINGCAPITAL UND_OUTSTANDINGCAPITAL,
T3.ISSUEDCAPITAL UND_ISSUEDCAPITAL,
T3.OUTSTANDCAPITALNO UND_OUTSTANDCAPITALNO,
T3.ISSUEDCAPITALNO UND_ISSUEDCAPITALNO,
T3.ISSUEAMOUNT UND_ISSUEAMOUNT,
T3.ISSUEPRICE UND_ISSUEPRICE,
T3.EXERCISEAMOUNT UND_EXERCISEAMOUNT,
T3.MINEXERCISEAMOUNT UND_MINEXERCISEAMOUNT,
T3.HELDAMOUNT UND_HELDAMOUNT, T3.PAYAMOUNT UND_PAYAMOUNT,
T3.INCOMETAXRATE UND_INCOMETAXRATE,
T3.PREMIUMRATE UND_PREMIUMRATE,
T3.PARTICIPATIONRATE UND_PARTICIPATIONRATE,
T3.REBATE UND_REBATE, T3.CSRATING UND_CSRATING,
T3.CSRISKINDIDSYMBOL UND_CSRISKINDIDSYMBOL,
T3.CSRISKINDSCHEMESYM UND_CSRISKINDSCHEMESYM,
T3.CSRISKINSTGRPIDSYM UND_CSRISKINSTGRPIDSYM,
T3.CSRISKINSGRPSCHSYM UND_CSRISKINSGRPSCHSYM,
T3.MDYRATING UND_MDYRATING, T3.SPRATING UND_SPRATING,
T3.FITCHRATING UND_FITCHRATING,
T3.LISTINGSYMBOLTKH UND_LISTINGSYMBOLTKH,
T3.LISTINGSYMBOLRIC UND_LISTINGSYMBOLRIC,
T3.LISTINGSYMBOLBBI UND_LISTINGSYMBOLBBI,
T3.NOMINALCURR_I1 UND_NOMINALCURR_I1,
T3.NOMINALCURR_I2 UND_NOMINALCURR_I2,
T3.NOMINALCURR_WS80 UND_NOMINALCURR_WS80,
T3.CSRISKCURRENCY_I1 UND_CSRISKCURRENCY_I1,
T3.CSRISKCURRENCY_I2 UND_CSRISKCURRENCY_I2,
T3.CSRISKCURRENCY_WS80 UND_CSRISKCURRENCY_WS80,
T3.CSRISINSTRUMENT_CH UND_CSRISINSTRUMENT_CH,
T3.CSRISINSTRUMENT_ISIN UND_CSRISINSTRUMENT_ISIN,
T3.CSRISINSTRUMENT_CSFI UND_CSRISINSTRUMENT_CSFI,
T3.CSRISKCOUNTRY_A2 UND_CSRISKCOUNTRY_A2,
T3.CSRISKCOUNTRY_WS80 UND_CSRISKCOUNTRY_WS80,
T3.REPAYPRICECURR_I1 UND_REPAYPRICECURR_I1,
T3.REPAYPRICECURR_I2 UND_REPAYPRICECURR_I2,
T3.REPAYPRICECURR_WS80 UND_REPAYPRICECURR_WS80,
T3.ISSUEPRICECURR_I1 UND_ISSUEPRICECURR_I1,
T3.ISSUEPRICECURR_I2 UND_ISSUEPRICECURR_I2,
T3.ISSUEPRICECURR_WS80 UND_ISSUEPRICECURR_WS80,
T3.EXERCISECURR_I1 UND_EXERCISECURR_I1,
T3.EXERCISECURR_I2 UND_EXERCISECURR_I2,
T3.EXERCISECURR_WS80 UND_EXERCISECURR_WS80,
T3.CSMAINTRADPLACE_BCN UND_CSMAINTRADPLACE_BCN,
T3.CSMAINTRADPLACE_WS80 UND_CSMAINTRADPLACE_WS80,
T3.CSMAINTRADPLACE_RTX UND_CSMAINTRADPLACE_RTX,
T3.CSMAINTRADPLACE_BBX UND_CSMAINTRADPLACE_BBX,
T3.UNDERINSTRUMENT_CH UND_UNDERINSTRUMENT_CH,
T3.UNDERINSTRUMENT_ISIN UND_UNDERINSTRUMENT_ISIN,
T3.UNDERINSTRUMENT_CSFI UND_UNDERINSTRUMENT_CSFI,
T3.ORIGINALISSUER_GK UND_ORIGINALISSUER_GK,
T3.ISSUER_GK UND_ISSUER_GK,
T3.MAINDEPOSITARY_GK UND_MAINDEPOSITARY_GK,
T3.EXPIRATIONDATE UND_EXPIRATIONDATE,
T3.MATURITYDATE UND_MATURITYDATE,
T3.FIRSTPAYDATE UND_FIRSTPAYDATE,
T3.FIRSTPYDATEPERYEAR UND_FIRSTPYDATEPERYEAR,
T3.INTRSTDVDENFRDATE UND_INTRSTDVDENFRDATE,
T3.CSRATINGDATE UND_CSRATINGDATE,
T3.MDYRATINGDATE UND_MDYRATINGDATE,
T3.SPRATINGDATE UND_SPRATINGDATE,
T3.FITCHRATINGDATE UND_FITCHRATINGDATE,
T3.SUBSCRBEGINDATE UND_SUBSCRBEGINDATE,
T3.PAYMENTDATE UND_PAYMENTDATE,
T3.EXERCISEBEGINDATE UND_EXERCISEBEGINDATE,
T3.SUBSCRPLNDENDDATE UND_SUBSCRPLNDENDDATE,
T3.EXERCISEENDDATE UND_EXERCISEENDDATE,
T3.BVGTYPE UND_BVGTYPE,
T3.CREDITWORTHINESSTP UND_CREDITWORTHINESSTP,
T3.COMMISSIONCODETYPE UND_COMMISSIONCODETYPE,
T3.UNITTYPE UND_UNITTYPE, T3.CSUNITTYPE UND_CSUNITTYPE,
T3.EXPIRATIONTYPE UND_EXPIRATIONTYPE,
T3.STATUSTYPE UND_STATUSTYPE,
T3.REGISTRATIONTYPE UND_REGISTRATIONTYPE,
T3.BORROWERCATTYPE UND_BORROWERCATTYPE,
T3.CSLISTINGCODETYPE UND_CSLISTINGCODETYPE,
T3.CSSTATUSTYPE UND_CSSTATUSTYPE,
T3.STATUSDETAILTYPE UND_STATUSDETAILTYPE,
T3.INCOMEMODETYPE UND_INCOMEMODETYPE,
T3.INTERESTCALCTYPE UND_INTERESTCALCTYPE,
T3.INTERESTTYPE UND_INTERESTTYPE,
T3.PYFREQUNITTYPE UND_PYFREQUNITTYPE,
T3.SUBSCRMETHODTYPE UND_SUBSCRMETHODTYPE,
T3.PLACEMENTTYPE UND_PLACEMENTTYPE,
T3.PAYDIRECTIONTYPE UND_PAYDIRECTIONTYPE,
T3.OPTIONTYPE UND_OPTIONTYPE,
T3.SETTLESTYLETYPE UND_SETTLESTYLETYPE,
T3.CSFUNDTYPE UND_CSFUNDTYPE,
T3.TRADINGSTATUSTYPE UND_TRADINGSTATUSTYPE,
T3.LISTINGSTATUSTYPE UND_LISTINGSTATUSTYPE,
T3.EXERCISEPLACE UND_EXERCISEPLACE,
T3.NAME35_G UND_NAME35_G, T3.NAME35_E UND_NAME35_E,
T3.NAME35_F UND_NAME35_F, T3.NAME35_I UND_NAME35_I,
T3.NAME35_N UND_NAME35_N, T3.NAME45_G UND_NAME45_G,
T3.NAME45_E UND_NAME45_E, T3.NAME45_F UND_NAME45_F,
T3.NAME45_I UND_NAME45_I, T3.NAME45_N UND_NAME45_N,
T3.SHORTNAME_G UND_SHORTNAME_G,
T3.SHORTNAME_E UND_SHORTNAME_E,
T3.SHORTNAME_F UND_SHORTNAME_F,
T3.SHORTNAME_I UND_SHORTNAME_I,
T3.SHORTNAME_N UND_SHORTNAME_N,
T3.PREPARTICLE_G UND_PREPARTICLE_G,
T3.PREPARTICLE_E UND_PREPARTICLE_E,
T3.PREPARTICLE_F UND_PREPARTICLE_F,
T3.PREPARTICLE_I UND_PREPARTICLE_I,
T3.PREPARTICLE_N UND_PREPARTICLE_N,
T3.POSTPARTICLE_G UND_POSTPARTICLE_G,
T3.POSTPARTICLE_E UND_POSTPARTICLE_E,
T3.POSTPARTICLE_F UND_POSTPARTICLE_F,
T3.POSTPARTICLE_I UND_POSTPARTICLE_I,
T3.POSTPARTICLE_N UND_POSTPARTICLE_N,
T3.ISINTERNAL UND_ISINTERNAL, T3.ISOTC UND_ISOTC,
T3.HASWITHHOLDINGTAX UND_UND_HASWITHHOLDINGTAX,
T3.HASFEDERALSTAMPDUTY UND_HASFEDERALSTAMPDUTY,
T3.ISCSMIFIDCOMPLEX UND_ISCSMIFIDCOMPLEX,
T3.MOSTLIQUIDMARKETLOCATION UND_MOSTLQDMARKETLOCATION,
T3.MOSTLIQUIDMARKETLOCATION_A2 UND_MOSTLQDMARKETLOCATION_A2,
T3.MOSTLIQUIDMARKETLOCATION_A3 UND_MOSTLQDMARKETLOCATION_A3,
T3.MOSTLIQUIDMARKETLOCATION_WS80
UND_MOSTLQDMARKETLOCATION_WS80,
T3.MDYWATCHLISTSTATUSTYPE UND_MDYWATCHLISTSTATUSTYPE,
T3.SPWATCHLISTSTATUSTYPE UND_SPWATCHLISTSTATUSTYPE,
T3.FITCHWATCHLISTSTATUSTYPE UND_FITCHWATCHLISTSTATUSTYPE,
T3.OPTIONSTYLETYPE UND_OPTIONSTYLETYPE,
T3.CSMAINTRADINGCURR UND_CSMAINTRADINGCURR,
T3.CSMAINTRADINGCURR_I1 UND_CSMAINTRADINGCURR_I1,
T3.CSMAINTRADINGCURR_I2 UND_CSMAINTRADINGCURR_I2,
T3.CSMAINTRADINGCURR_WS80 UND_CSMAINTRADINGCURR_WS80,
T3.CSRISKCOUNTRY_A3 UND_CSRISKCOUNTRY_A3,
T3.LIQUIDATIONRIGHTTYPE UND_LIQUIDATIONRIGHTTYPE,
T3.CSMAINPARENTTRADINGPLACE UND_CSMAINPTRADINGPLACE,
T3.CSMAINPARENTTRADINGPLACE_BCN UND_CSMAINPTRADINGPLACE_BCN,
T3.CSMAINPARENTTRADINGPLACE_RTX UND_CSMAINPTRADINGPLACE_RTX,
T3.CSMAINPARENTTRADINGPLACE_MIC UND_CSMAINPTRADINGPLACE_MIC,
T3.CSMAINPARENTTRADINGPLACE_BBX UND_CSMAINPTRADINGPLACE_BBX,
T3.CSMAINPARENTTRADINGPLACE_WS80
UND_CSMAINPTRADINGPLACE_WS80, T4.DEFREPAYMENTPERIOD,
T4.POSITIONLIMIT, T4.MARGININPERCENT,
T4.MARGININITIALAMOUN, T4.MARGINSPREADAMOUNT,
T4.TICKAMOUNT, T4.TICKSIZE, T4.CONTRACTSIZE,
T4.CONTSIZEUNDERLYING, T4.BONDFLOOR, T4.DISCOUNT,
T4.GUARANTEREPAYPRICE, T4.RESERVENUMBER2,
T4.RESERVENUMBER3, T4.RESERVENUMBER4, T4.RESERVENUMBER5,
T4.MANDATOR, T4.RESERVETEXT1, T4.RESERVETEXT3,
T4.CSBOARDLOT, T4.CSINCOMETAXTYPE, T4.POSITIONCURRTYPE,
T4.KANTONSCODETYPE, T4.CSEVENTDTCODETYPE,
T4.CSFUNDTYPE CSFUNDTYPE_SP42, T4.CSRELEVANCEDATE,
T4.HASQUOTESBLOCK, T4.HASFUNDSUNBUNDLING,
T4.FUNDDEPOSITARY, T4.FUNDCATEGORY
FROM VDPSX.VTINSTRFLATSYMBOLS T1
INNER JOIN
VDPSX.VTINSTRFLATDATA T2
ON T2.INSTRUMENTID = T1.INSTRUMENTID
LEFT OUTER JOIN
VDPSX.VTINSTRFLATDATA T3
ON T3.INSTRUMENTID = T2.UNDERINSTRUMENT
LEFT OUTER JOIN
VDPSX.CTINSTRSP42DETAILS T4
ON T4.INSTRUMENTID = T1.INSTRUMENTID ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.IDS_VINSP135_V02
------------------------------------------------------------------------
--
--
CREATE VIEW VDPSX.IDS_VINSP135_V02 AS
SELECT T1.INSTRUMENTID, T2.DEFREPAYMENTPERIOD, T2.POSITIONLIMIT,
T2.BONDFLOOR, T2.DISCOUNT, T2.GUARANTEREPAYPRICE,
T2.RESERVENUMBER2, T2.RESERVENUMBER3, T2.RESERVENUMBER4,
T2.RESERVENUMBER5, T2.MANDATOR, T2.RESERVETEXT1,
T2.RESERVETEXT3, T2.CSBOARDLOT, T2.CSINCOMETAXTYPE,
T2.POSITIONCURRTYPE, T2.KANTONSCODETYPE,
T2.CSEVENTDTCODETYPE, T2.CSFUNDTYPE, T2.CSRELEVANCEDATE,
T2.HASQUOTESBLOCK, T2.HASFUNDSUNBUNDLING,
T2.FUNDDEPOSITARY, T2.FUNDCATEGORY
FROM VDPSX.VTINSTRFLATSYMBOLS T1
INNER JOIN
VDPSX.CTINSTRSP42DETAILS T2
ON T2.INSTRUMENTID = T1.INSTRUMENTID ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.IDS_VLSTG111_V03
------------------------------------------------------------------------
--
--
CREATE VIEW VDPSX.IDS_VLSTG111_V03 AS
SELECT T1.INSTRUMENTID, T1.LISTINGNO, T3.SYMBOLCH, T3.SYMBOLISIN,
T3.SYMBOLCSFI, T1.CURRENCY, T1.CURRENCY_I2, T1.CURRENCY_I1,
T1.CURRENCY_WS80, T1.TRADINGPLACE, T1.TRADINGPLACE_BCN,
T1.TRADINGPLACE_MIC, T1.TRADINGPLACE_RTX,
T1.TRADINGPLACE_BBX, T1.TRADINGPLACE_WS80,
T4.SHORTNAME_G SHORTNAME_G_INSTI,
T4.SHORTNAME_E SHORTNAME_E_INSTI,
T4.SHORTNAME_F SHORTNAME_F_INSTI,
T4.SHORTNAME_I SHORTNAME_I_INSTI,
T4.SHORTNAME_N SHORTNAME_N_INSTI, T1.LISTINGSYMBOLTK,
T1.LISTINGSYMBOLRT, T1.LISTINGSYMBOLBB,
T1.SHORTNAME_G SHORTNAME_G_LISG,
T1.SHORTNAME_E SHORTNAME_E_LISG,
T1.SHORTNAME_F SHORTNAME_F_LISG,
T1.SHORTNAME_I SHORTNAME_I_LISG,
T1.SHORTNAME_N SHORTNAME_N_LISG, T1.LISTINGSTATUSTYPE,
T1.TRADINGSTATUSTYPE, T1.FIRSTTRADINGDATE,
T1.LASTTRADINGDATE, T1.ISMAINTRADINGPLACE,
T1.ISHOMETRADINGPLACE, T1.LISTINGCLASSTYPE,
T1.PRICINGUNITNO, T1.PRICINGUNITTYPE,
T1.TRADINGUNITTYPE TRADINGUNITTYPE_LISTING,
T1.ISCSBESTVENUEOVERALL, T1.ISCSBESTVENUEPERCURR,
T1.ISBESTVOLUMEBESTSPREAD, T1.ISBESTVOLUME,
T1.ISBESTSPREAD, T1.ISHIGHESTTICKS, T1.ISBESTVOLUMEPERCURR,
T1.ISBESTSPREADPERCURR, T1.ISPRIMARYMARKETUSA,
T1.ISSINGLETRADINGPLACE, T1.ISISSUERPRICEPROVIDER,
T1.ISNAVINDEPENDENTSOURCE, T1.ISFUNDASSESSMENTSOURCE,
T1.ISPLACEOFLISTING, T1.ISPLACEOFTRADING,
T1.ISPLACEOFQUOTE, T1.PARENTTRADINGPLACE,
T1.PARENTTRADINGPLACE_BCN, T1.PARENTTRADINGPLACE_RTX,
T1.PARENTTRADINGPLACE_MIC, T1.PARENTTRADINGPLACE_BBX,
T1.PARENTTRADINGPLACE_WS80, T2.CONVERSIONFACTOR,
T2.ISSTEERINGFLAG1, T2.ISSTEERINGFLAG2, T2.ISSTEERINGFLAG3,
T2.ISSTEERINGFLAG4, T2.ISSTEERINGFLAG5, T2.ISSTEERINGFLAG6,
T2.ISSTEERINGFLAG7, T2.ISSTEERINGFLAG8, T2.PRIORITYCODE,
T2.RESERVESYMBOL,
T2.TRADINGUNITTYPE TRADINGUNITTYPE_CSLISTING, T2.MANDATOR
FROM VDPSX.VTLISTING T1
INNER JOIN
VDPSX.CTLISTING T2
ON T2.INSTRUMENTID = T1.INSTRUMENTID AND T2.LISTINGNO = T1.
LISTINGNO
INNER JOIN
VDPSX.VTINSTRFLATSYMBOLS T3
ON T3.INSTRUMENTID = T1.INSTRUMENTID
INNER JOIN
VDPSX.VTINSTITUTION T4
ON T4.INSTITUTIONID = T1.TRADINGPLACE ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.IDS_VRSTR114
------------------------------------------------------------------------
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","F473828" ;
--
CREATE VIEW VDPSX.IDS_VRSTR114 AS
SELECT T1.INSTRUMENTID, T1.SYMBOLCH, T1.SYMBOLISIN, T1.SYMBOLUS,
T1.SYMBOLXS, T1.SYMBOLGB, T1.SYMBOLLU, T1.SYMBOLDE,
T1.SYMBOLI2, T1.SYMBOLI1, T1.SYMBOLT1, T1.SYMBOLT2,
T1.SYMBOLCSFI, T1.SYMBOLCSCURR, T1.CATEGORYVDPS,
T1.CATEGORYTKT, T1.CATEGORYEUZS,
T1.INSTRUMENTUPDATETIMESTAMP, T1.INSTRUMENTCREATETIMESTAMP,
T3.INSTRRESTRICTIONNO, T3.RESTRICTIONPERIOD,
T3.PROVIDER1ID, T3.PROVIDER2ID, T3.PROVIDER3ID,
T3.ISRESIDENTLOCATION, T3.ISCITIZENLOCATION,
T3.ISRESTRICTCOUNTRY, T3.ISINSTIRESTRICTION,
T3.ISRESTRICTBYISSUER, T3.RESTRICTLOCATION,
T3.PERIODBEGINDATE, T3.PERIODENDDATE, T3.RESTRMARKETTYPE,
T3.RESTRICTIONTYPE, T3.INSTIRESTRICTTYPE,
T3.RESTRICTPERIUNTP, T3.DESCRIPTION_G, T3.DESCRIPTION_E,
T3.DESCRIPTION_F, T3.DESCRIPTION_I, T3.DESCRIPTION_N,
T3.ISOVERRIDEALLOWED, T3.P42RESTRICTIONTYPE,
T3.REGISTRATIONLIMIT, T3.CREATETIMESTAMP,
T3.UPDATETIMESTAMP, T4.RESTRSUSPENSIONNO,
T4.INSTRRESTRICTIONNO RESTRICTIONNO_SUSP,
T4.PROVIDER1ID PROVIDER1ID_SUSP,
T4.PROVIDER2ID PROVIDER2ID_SUSP,
T4.PROVIDER3ID PROVIDER3ID_SUSP, T4.LOCATION,
T4.PERIODBEGINDATE PERIODBEGINDATE_SUSP,
T4.PERIODENDDATE PERIODENDDATE_SUSP, T4.RESTRICTSUSPENTP,
T4.DESCRIPTION_G DESCRIPTION_G_SUSP,
T4.DESCRIPTION_E DESCRIPTION_E_SUSP,
T4.DESCRIPTION_F DESCRIPTION_F_SUSP,
T4.DESCRIPTION_I DESCRIPTION_I_SUSP,
T4.DESCRIPTION_N DESCRIPTION_N_SUSP, T4.LOCATION_A2,
T4.LOCATION_A3, T4.LOCATION_WS80,
T5.IDSYMBOL RESTRICTLOCATIONISOA2,
T5.VALIDFROMDATE VALIDFROMDATE_ISOA2,
T5.VALIDUNTILDATE VALIDUNTILDATE_ISOA2,
T6.IDSYMBOL RESTRICTLOCATIONISOA3,
T6.VALIDFROMDATE VALIDFROMDATE_ISOA3,
T6.VALIDUNTILDATE VALIDUNTILDATE_ISOA3,
T7.IDSYMBOL RESTRICTLOCATIONISON,
T7.VALIDFROMDATE VALIDFROMDATE_ISON,
T7.VALIDUNTILDATE VALIDUNTILDATE_ISON,
T8.IDSYMBOL RESTRICTLOCATIONTKN,
T8.VALIDFROMDATE VALIDFROMDATE_TKN,
T8.VALIDUNTILDATE VALIDUNTILDATE_TKN,
T9.IDSYMBOL RESTRICTLOCATIONCS,
T9.VALIDFROMDATE VALIDFROMDATE_CS,
T9.VALIDUNTILDATE VALIDUNTILDATE_CS
FROM VDPSX.VTINSTRFLATSYMBOLS T1
INNER JOIN
VDPSX.VTINSTRFLATDATA T2
ON T2.INSTRUMENTID = T1.INSTRUMENTID
INNER JOIN
VDPSX.VTINSTRRESTRICTION T3
ON T3.INSTRUMENTID = T2.INSTRUMENTID
LEFT OUTER JOIN
VDPSX.VTRESTRICTIONSUSP T4
ON T4.INSTRUMENTID = T3.INSTRUMENTID AND T4.
INSTRRESTRICTIONNO = T3.INSTRRESTRICTIONNO
LEFT OUTER JOIN
VDPSX.VTGEOUNITIDENT T5
ON T5.GEOUNITID = T3.RESTRICTLOCATION AND T5.SCHEMESYMBOL
= 'ISOA2' AND T5.ROWSTATUS = 1
LEFT OUTER JOIN
VDPSX.VTGEOUNITIDENT T6
ON T6.GEOUNITID = T3.RESTRICTLOCATION AND T6.SCHEMESYMBOL
= 'ISOA3' AND T6.ROWSTATUS = 1
LEFT OUTER JOIN
VDPSX.VTGEOUNITIDENT T7
ON T7.GEOUNITID = T3.RESTRICTLOCATION AND T7.SCHEMESYMBOL
= 'ISON' AND T7.ROWSTATUS = 1
LEFT OUTER JOIN
VDPSX.VTGEOUNITIDENT T8
ON T8.GEOUNITID = T3.RESTRICTLOCATION AND T8.SCHEMESYMBOL
= 'TKN' AND T8.ROWSTATUS = 1
LEFT OUTER JOIN
VDPSX.VTGEOUNITIDENT T9
ON T9.GEOUNITID = T3.RESTRICTLOCATION AND T9.SCHEMESYMBOL
= 'CS-WS80-DOM' AND T9.ROWSTATUS = 1 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.VVV_IDS_VCFTU106
------------------------------------------------------------------------
--
--
CREATE VIEW VDPSX.VVV_IDS_VCFTU106 AS
SELECT T1.INSTRUMENTID, T1.SYMBOLCH, T1.SYMBOLISIN, T1.SYMBOLUS,
T1.SYMBOLXS, T1.SYMBOLGB, T1.SYMBOLLU, T1.SYMBOLDE,
T1.SYMBOLI2, T1.SYMBOLI1, T1.SYMBOLT1, T1.SYMBOLT2,
T1.SYMBOLCSFI, T1.SYMBOLCSCURR, T1.CATEGORYVDPS,
T1.CATEGORYTKT, T1.CATEGORYEUZS,
T1.INSTRUMENTUPDATETIMESTAMP, T1.INSTRUMENTCREATETIMESTAMP,
T2.INSTRUMENTEVENTNO, T3.EXDATE, T4.CFAMOUNTTYPE,
T4.PAYAMOUNT, T5.RELEVANTDATE, T6.SYMBOLI2 PAYINSTRUMENT
FROM VDPSX.VTINSTRFLATSYMBOLS T1
INNER JOIN
VDPSX.VTINSTRUMENTEVENT T2
ON T2.INSTRUMENTID = T1.INSTRUMENTID AND T2.PROVIDERTYPE =
2
INNER JOIN
VDPSX.VTINSTREVENTEXDATE T3
ON T2.INSTRUMENTID = T3.INSTRUMENTID AND T2.
INSTRUMENTEVENTNO = T3.INSTRUMENTEVENTNO
INNER JOIN
VDPSX.VTCASHFLOWAMOUNT T4
ON T4.INSTRUMENTID = T3.INSTRUMENTID AND T4.
INSTRUMENTEVENTNO = T3.INSTRUMENTEVENTNO AND T4.
CFAMOUNTTYPE IN(10064, 10072)
INNER JOIN
VDPSX.VTCASHFLOWTAXAMT T5
ON T2.INSTRUMENTID = T5.INSTRUMENTID AND T2.
INSTRUMENTEVENTNO = T5.INSTRUMENTEVENTNO AND T5.
RELEVANTDATE >= '20090101'
LEFT OUTER JOIN
VDPSX.VTINSTRFLATSYMBOLS T6
ON T6.INSTRUMENTID = T4.PAYINSTRUMENT
WHERE T2.INSTRUMENTEVENTNO IN(SELECT T7.INSTRUMENTEVENTNO
FROM VDPSX.VTCASHFLOWTAXAMT T7
WHERE
T7.RELEVANTDATE >= '20090101'
AND T7.INSTRUMENTID = T2.
INSTRUMENTID) ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.VVV_IDS_VINGP108
------------------------------------------------------------------------
--
--
CREATE VIEW VDPSX.VVV_IDS_VINGP108 AS
SELECT T1.INSTRUMENTID, T1.ROWSTATUS ROWSTATUS_FLTSYMB,
T1.CSSTATUSTYPE, T1.STATUSTYPE, T1.SYMBOLCH, T1.SYMBOLISIN,
T1.SYMBOLUS, T1.SYMBOLXS, T1.SYMBOLGB, T1.SYMBOLLU,
T1.SYMBOLDE, T1.SYMBOLI2, T1.SYMBOLI1, T1.SYMBOLT1,
T1.SYMBOLT2, T1.SYMBOLCSFI, T1.SYMBOLCSCURR,
T1.CATEGORYVDPS, T1.CATEGORYTKT, T1.CATEGORYEUZS,
T1.INSTRUMENTUPDATETIMESTAMP, T1.INSTRUMENTCREATETIMESTAMP,
T2.PAYFREQUENCY, T2.EXERCISEAMOUNT, T2.PAYAMOUNT,
T2.ISCONVERTBYISSUER, T2.HASVOTINGRIGHTNO,
T2.HASMULTIUNDERLYERS, T2.CSMAINTRADPLACE,
T2.ORIGINALISSUER, T2.ISSUER, T2.UNDERINSTRUMENT,
T2.NOMINALCURR, T2.NOMINALCURR_I1, T2.NOMINALCURR_I2,
T2.NOMINALCURR_WS80, T2.CSRISKCURRENCY, T2.EXERCISECURR,
T2.POOLFACTOR, T2.VOTINGRIGHTNO, T2.OUTSTANDINGCAPITAL,
T2.CSRISKINDIDSYMBOL, T2.CSRISKINDSCHEMESYM, T2.MDYRATING,
T2.SPRATING, T2.PAYMENTDATE, T2.UNITTYPE, T2.CSUNITTYPE,
T2.CSFUNDTYPE, T2.HASWITHHOLDINGTAX, T2.OPTIONSTYLETYPE,
T2.NAME35_G, T2.NAME45_G, T2.SHORTNAME_G, T2.PREPARTICLE_G,
T2.POSTPARTICLE_G, T2.EFFECTIVEDATE, T2.BORROWINGLIMITTYPE,
T3.INSTRINGROUPNO, T3.IDSYMBOL IDSYMBOL_IGK,
T3.SCHEMESYMBOL SCHEMESYMBOL_IGK, T3.QUALITYTYPE,
T3.PROVIDER1ID, T3.PROVIDER2ID, T3.PROVIDER3ID,
T4.INSTRGROUPID, T4.HISTORYID, T4.INSTRGROUPTYPE,
T4.ROWSTATUS, T4.VSTQUALITY, T4.REVISIONNO,
T4.VSTREQUIREDQUALITY, T4.VSTMAXIMUMQUALITY,
T4.HASPENDINGACTVTY, T4.ISRELEVANT, T4.HASFUTUREMESSAGES,
T4.FOTWIZISDISABLED, T4.ISONDB, T4.IDSYMBOL IDSYMBOL_IG,
T4.SCHEMESYMBOL SCHEMESYMBOL_IG, T4.NAME_G, T4.NAME_E,
T4.NAME_F, T4.NAME_I, T4.NAME_N, T4.VSTNAME, T4.VSTVERSION,
T4.CREATEUSERID, T4.UPDATEUSERID, T4.PROVIDER1SYMBOL,
T4.PROVIDER2SYMBOL, T4.PROVIDER3SYMBOL, T4.VALIDUNTILDATE,
T4.VALIDFROMDATE, T4.FOTYPE FOTYPE_IG, T4.DATASTATUSTYPE,
T4.BLOCKINGCODETYPE, T4.LOGICDELETIONTYPE,
T4.MODIFICATIONREASON, T4.REMARKS, T4.DESCRIPTION_G,
T4.DESCRIPTION_E, T4.DESCRIPTION_F, T4.DESCRIPTION_I,
T4.DESCRIPTION_N, T4.DOWRITETOSHADOWTABLES
FROM VDPSX.VTINSTRFLATSYMBOLS T1
INNER JOIN
VDPSX.VTINSTRFLATDATA T2
ON T2.INSTRUMENTID = T1.INSTRUMENTID
INNER JOIN
VDPSX.VTINSTRINGROUP T3
ON T3.INSTRUMENTID = T2.INSTRUMENTID
INNER JOIN
VDPSX.VTINSTRGROUP T4
ON T4.IDSYMBOL = T3.IDSYMBOL AND T4.SCHEMESYMBOL = T3.
SCHEMESYMBOL ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.VVV_XPS_IL#VLIID_V01
------------------------------------------------------------------------
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","F273764" ;
--
CREATE VIEW VDPSX.VVV_XPS_IL#VLIID_V01 AS
SELECT CHAR(T1.IDSYMBOL, 9) AS VALORNR,
CHAR(T8.IDSYMBOL, 4) AS CURRENCY_CS, T3.LISTINGSTATUSTYPE,
T3.TRADINGSTATUSTYPE, T3.ISHOMETRADINGPLACE,
CHAR(T4.IDSYMBOL, 4) AS IDSYMBOL_BCN,
CHAR(T5.DOMICILE_WS80, 3) AS DOMICILE_CS,
T7.ISSTEERINGFLAG4 AS CS_HAUPTBOEPLATZ,
T3.ISMAINTRADINGPLACE AS TK_HAUPTBOEPLATZ,
T3.ISCSBESTVENUEOVERALL, T3.ISCSBESTVENUEPERCURR,
CHAR(T6.SCHEMESYMBOL, 3) AS SCHEME_TICKER,
SUBSTR(T6.IDSYMBOL, 1, 30) AS IDSYMBOL_TICKER,
T3.DESCRIPTION_E AS EXTERNTRADINGCURR
FROM VDPSX.VTINSTRIDENT T1
INNER JOIN
VDPSX.VTINSTRUMENT T2
ON T2.INSTRUMENTID = T1.INSTRUMENTID AND (T2.ROWSTATUS IS
NULL OR T2.ROWSTATUS <> 2) AND T2.CSSTATUSTYPE BETWEEN 4
AND 9
INNER JOIN
VDPSX.VTLISTING T3
ON T3.INSTRUMENTID = T1.INSTRUMENTID
LEFT OUTER JOIN
VDPSX.VTINSTIIDENT T4
ON T4.INSTITUTIONID = T3.TRADINGPLACE AND T4.SCHEMESYMBOL
= 'BCN' AND T4.ROWSTATUS = 1
INNER JOIN
VDPSX.VTINSTITUTION T5
ON T5.INSTITUTIONID = T3.TRADINGPLACE AND (T5.ROWSTATUS IS
NULL OR T5.ROWSTATUS <> 2)
LEFT OUTER JOIN
VDPSX.VTLISTINGIDENT T6
ON T6.INSTRUMENTID = T3.INSTRUMENTID AND T6.LISTINGNO = T3.
LISTINGNO AND T6.SCHEMESYMBOL IN('TKH', 'RIC', 'BBI', 'TKE')
LEFT OUTER JOIN
VDPSX.CTLISTING T7
ON T7.INSTRUMENTID = T3.INSTRUMENTID AND T7.LISTINGNO = T3.
LISTINGNO AND T7.MANDATOR = 1
LEFT OUTER JOIN
VDPSX.VTINSTRIDENT T8
ON T8.INSTRUMENTID = T3.CURRENCY AND T8.SCHEMESYMBOL =
'CS-WS80-WHRG' AND T8.ROWSTATUS = 1
WHERE T1.SCHEMESYMBOL = 'CH'
AND T1.ROWSTATUS = 1
AND (T3.LISTINGSTATUSTYPE IN(1, 4, 13, 17, 21)
OR T7.ISSTEERINGFLAG4 = 1) ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.VVV_XPS_VINDE007_V01
------------------------------------------------------------------------
--
--
CREATE VIEW VDPSX.VVV_XPS_VINDE007_V01 AS
SELECT T1.IDSYMBOL, T1.SCHEMESYMBOL, T1.INSTRUMENTID,
T3.CREATETIMESTAMP, T3.UPDATETIMESTAMP,
T3.ISCSMIFIDCOMPLEX, T3.CSPRODUCTCATEGORY
FROM VDPSX.VTINSTRIDENT T1
INNER JOIN
VDPSX.VTINSTRUMENT T2
ON T2.INSTRUMENTID = T1.INSTRUMENTID AND (T2.ROWSTATUS IS
NULL OR T2.ROWSTATUS <> 2)
INNER JOIN
VDPSX.CTINSTRDETAILS T3
ON T3.INSTRUMENTID = T1.INSTRUMENTID
WHERE T1.ROWSTATUS = 1 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.VVV_XPS_VLIID002_V07
------------------------------------------------------------------------
--
--
CREATE VIEW VDPSX.VVV_XPS_VLIID002_V07 AS
SELECT T1.IDSYMBOL, T1.SCHEMESYMBOL, T1.INSTRUMENTID,
T3.CREATETIMESTAMP, T3.UPDATETIMESTAMP, T3.LISTINGNO,
T6.LISTINGIDENTNO, T3.LISTINGSTATUSTYPE,
T3.TRADINGSTATUSTYPE, T3.FIRSTTRADINGDATE,
T3.LASTTRADINGDATE, T3.ISHOMETRADINGPLACE,
T3.ISMAINTRADINGPLACE TK_HAUPTBOEPLATZ,
T7.ISSTEERINGFLAG4 CS_HAUPTBOEPLATZ,
T3.ISCSBESTVENUEOVERALL, T3.ISCSBESTVENUEPERCURR,
T3.TRADINGPLACE, T3.CURRENCY, T8.IDSYMBOL CURRENCY_CS,
T4.IDSYMBOL IDSYMBOL_BCN, T5.DOMICILE,
T5.DOMICILE_WS80 DOMICILE_CS,
T6.SCHEMESYMBOL SCHEME_TICKER, T6.IDSYMBOL IDSYMBOL_TICKER,
T6.VALIDFROMDATE, T6.VALIDUNTILDATE,
T3.DESCRIPTION_E EXTERNTRADINGCURR
FROM VDPSX.VTINSTRIDENT T1
INNER JOIN
VDPSX.VTINSTRUMENT T2
ON T2.INSTRUMENTID = T1.INSTRUMENTID AND (T2.ROWSTATUS IS
NULL OR T2.ROWSTATUS <> 2)
INNER JOIN
VDPSX.VTLISTING T3
ON T3.INSTRUMENTID = T1.INSTRUMENTID
LEFT OUTER JOIN
VDPSX.VTINSTIIDENT T4
ON T4.INSTITUTIONID = T3.TRADINGPLACE AND T4.SCHEMESYMBOL
= 'BCN' AND T4.ROWSTATUS = 1
INNER JOIN
VDPSX.VTINSTITUTION T5
ON T5.INSTITUTIONID = T3.TRADINGPLACE AND (T5.ROWSTATUS IS
NULL OR T5.ROWSTATUS <> 2)
LEFT OUTER JOIN
VDPSX.VTLISTINGIDENT T6
ON T6.INSTRUMENTID = T3.INSTRUMENTID AND T6.LISTINGNO = T3.
LISTINGNO AND T6.SCHEMESYMBOL IN('TKH', 'RIC', 'BBI', 'TKE')
LEFT OUTER JOIN
VDPSX.CTLISTING T7
ON T7.INSTRUMENTID = T3.INSTRUMENTID AND T7.LISTINGNO = T3.
LISTINGNO AND T7.MANDATOR = 1
LEFT OUTER JOIN
VDPSX.VTINSTRIDENT T8
ON T8.INSTRUMENTID = T3.CURRENCY AND T8.SCHEMESYMBOL =
'CS-WS80-WHRG' AND T8.ROWSTATUS = 1
WHERE T1.ROWSTATUS = 1
AND T3.LISTINGSTATUSTYPE <> 9
AND T3.LISTINGSTATUSTYPE <> 18 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.XPS_VINCF502_V02
------------------------------------------------------------------------
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","F578255" ;
--
CREATE VIEW VDPSX.XPS_VINCF502_V02 AS
SELECT VDPSX.VTINSTRWITHCF.INSTRUMENTID,
VDPSX.VTINSTRWITHCF.PAYFREQUENCY,
VDPSX.VTINSTRWITHCF.ISAMORTIZABLE,
VDPSX.VTINSTRWITHCF.ISCONVERTBYHOLDER,
VDPSX.VTINSTRWITHCF.ISCONVERTBYISSUER,
VDPSX.VTINSTRWITHCF.ISEXTENDBYHOLDER,
VDPSX.VTINSTRWITHCF.ISEXTENDBYISSUER,
VDPSX.VTINSTRWITHCF.HASKNOWNCFONLY,
VDPSX.VTINSTRWITHCF.ISREDEEMABLE,
VDPSX.VTINSTRWITHCF.HASREOPENINGCLAUSE,
VDPSX.VTINSTRWITHCF.ISRETRACTABLE,
VDPSX.VTINSTRWITHCF.ISPARTLYPAID,
VDPSX.VTINSTRWITHCF.HASDISTRINVARCURR,
VDPSX.VTINSTRWITHCF.HASSTRUCTCASHFLOWS,
VDPSX.VTINSTRWITHCF.ISCOVEREDWARRANT,
VDPSX.VTINSTRWITHCF.HASREDMPINVARCURR,
VDPSX.VTINSTRWITHCF.HASVOTINGRIGHT,
VDPSX.VTINSTRWITHCF.HASISMAREGULATION,
VDPSX.VTINSTRWITHCF.REPAYPRICECURR,
VDPSX.VTINSTRWITHCF.EFFINTERESTRATE,
VDPSX.VTINSTRWITHCF.REPAYPRICE,
VDPSX.VTINSTRWITHCF.REPAYPRICEUNITNO,
VDPSX.VTINSTRWITHCF.NONVERSEAMOUNT,
VDPSX.VTINSTRWITHCF.POOLFACTOR,
VDPSX.VTINSTRWITHCF.PARTNOTPAID,
VDPSX.VTINSTRWITHCF.FIRSTPAYDATE,
VDPSX.VTINSTRWITHCF.MATURITYDATE,
VDPSX.VTINSTRWITHCF.POOLFACTORVLDFRDT,
VDPSX.VTINSTRWITHCF.INTRSTDVDENFRDATE,
VDPSX.VTINSTRWITHCF.CONVEXERFROMDATE,
VDPSX.VTINSTRWITHCF.CONVEXERUNTILDATE,
VDPSX.VTINSTRWITHCF.LASTSPLITDATE,
VDPSX.VTINSTRWITHCF.INTERESTCALCTYPE,
VDPSX.VTINSTRWITHCF.INTERESTTYPE,
VDPSX.VTINSTRWITHCF.LQDATIONRIGHTTYPE,
VDPSX.VTINSTRWITHCF.OPTIONSTYLETYPE,
VDPSX.VTINSTRWITHCF.PYFREQUNITTYPE,
VDPSX.VTINSTRWITHCF.REPAYPRICEQTETYPE,
VDPSX.VTINSTRWITHCF.REPAYPRICEUNTTYPE,
VDPSX.VTINSTRWITHCF.TRANSFERTYPE,
VDPSX.VTINSTRWITHCF.CERTIFICATETYPE,
VDPSX.VTINSTRWITHCF.INTRSTVALIDTYPE,
VDPSX.VTINSTRWITHCF.INCOMEMODETYPE,
VDPSX.VTINSTRWITHCF.INTRSTPYMTHDTYPE,
VDPSX.VTINSTRWITHCF.OPTIONTYPE,
VDPSX.VTINSTRWITHCF.INTERESTCALCTYPEV,
VDPSX.VTINSTRWITHCF.INTERESTTYPEV,
VDPSX.VTINSTRWITHCF.LQDATIONRIGHTTYPEV,
VDPSX.VTINSTRWITHCF.OPTIONSTYLETYPEV,
VDPSX.VTINSTRWITHCF.PYFREQUNITTYPEV,
VDPSX.VTINSTRWITHCF.REPAYPRICEQTETYPEV,
VDPSX.VTINSTRWITHCF.REPAYPRICEUNTTYPEV,
VDPSX.VTINSTRWITHCF.TRANSFERTYPEV,
VDPSX.VTINSTRWITHCF.CERTIFICATETYPEV,
VDPSX.VTINSTRWITHCF.INTRSTVALIDTYPEV,
VDPSX.VTINSTRWITHCF.INCOMEMODETYPEV,
VDPSX.VTINSTRWITHCF.INTRSTPYMTHDTYPEV,
VDPSX.VTINSTRWITHCF.OPTIONTYPEV,
VDPSX.VTINSTRWITHCF.CERTDESCR_G,
VDPSX.VTINSTRWITHCF.CERTDESCR_E,
VDPSX.VTINSTRWITHCF.CERTDESCR_F,
VDPSX.VTINSTRWITHCF.CERTDESCR_I,
VDPSX.VTINSTRWITHCF.CERTDESCR_N,
VDPSX.VTINSTRWITHCF.FIRSTPYDATEPERYEAR,
VDPSX.VTINSTRWITHCF.ISCALLFORTXREONLY,
VDPSX.VTINSTRWITHCF.IRREGLARLACOUPTP,
VDPSX.VTINSTRWITHCF.IUPVALUETYPE,
VDPSX.VTINSTRWITHCF.IRREGLARLACOUPTPV,
VDPSX.VTINSTRWITHCF.IUPVALUETYPEV,
VDPSX.VTINSTRWITHCF.BUSINESSDAYCONVTP,
VDPSX.VTINSTRWITHCF.BUSINESSDAYCONVTPV,
VDPSX.VTINSTRWITHCF.INTERESTPERIADJTP,
VDPSX.VTINSTRWITHCF.INTERESTPERIADJTPV,
VDPSX.VTINSTRWITHCF.HASHALBEINVERFHREN,
VDPSX.VTINSTRWITHCF.CLASSSYMBOL,
VDPSX.VTINSTRWITHCF.SERIES,
VDPSX.VTINSTRWITHCF.HASDIVIDREINVPLAN,
VDPSX.VTINSTRWITHCF.HALBEINKUENFTEVALIDFROM
FROM VDPSX.VTINSTRWITHCF ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.XPS_VINTX505_V02
------------------------------------------------------------------------
--
--
CREATE VIEW VDPSX.XPS_VINTX505_V02 AS
SELECT T1.INSTRUMENTID, T1.TAXRATEKEYNO, T1.PROVIDER1ID,
T1.PROVIDER2ID, T1.PROVIDER3ID, T1.TAXRATEIDSYMBOL,
T1.TXRTKEYCATIDSYMBOL, T1.BEGINDATE, T1.ENDDATE,
T1.CONCERNTYPE, T1.CONCERNTYPEV, T1.FUNDNAVCALCFREQ,
T1.REOPTRANCHINSTR, T1.ISGROSSUP, T1.HASACCRUEDINTEREST,
T1.ISREOPTRANCHINSTR, T1.ISGOVERNISSUEDDEBT,
T1.HASFUNDINTERESTDET, T1.HASEUTAXDIRECTIVE, T1.REOPENDATE,
T1.PROSPECTDATE, T1.FUNDPUBLICDATE, T1.FUNDASSETCALCDATE,
T1.FUNDASSETFROMDATE, T1.FUNDASSETUNTILDATE,
T1.FUNDPROSPECTFROMDT, T1.FUNDDECLSTATTYPE,
T1.GRANDFATHEREDTYPE, T1.FUNDNAVCALCFQUNTP,
T1.INOUTSCOPETYPE, T1.TAXFUNCTIONTYPE,
T1.FUNDDECLSTATTYPEV, T1.GRANDFATHEREDTYPEV,
T1.FUNDNAVCALCFQUNTPV, T1.INOUTSCOPETYPEV,
T1.TAXFUNCTIONTYPEV, T1.EUTAXDESCRIPTION_G,
T1.EUTAXDESCRIPTION_E, T1.EUTAXDESCRIPTION_F,
T1.EUTAXDESCRIPTION_I, T1.EUTAXDESCRIPTION_N,
T1.INSTRGRPSCHSYMBOL, T1.INSTRGROUPIDSYMBOL,
T1.VALIDFROMDATE, T1.DISCOUNTTYPE, T1.DISCOUNTTYPEV,
T1.FUNDPROSPECTUNTIDT, T1.PROVIDERTYPE PROVIDERTYPE_TXRATE,
T2.TAXAMTTYPE,
T2.ISFRGNTXRTFRUSRES ISFRGNTXRTFRUSRES_TXAMT,
T2.ISTAXSTANDARD, T2.TAXLOCATION, T2.REFUNDLOCATION,
T2.CURRENCY CURRENCY_TXAMT, T2.TAXAMOUNT, T2.TAXRATE,
T2.TAXTYPEIDSYMBOL TAXTYPEIDSYMBOL_TXAMT,
T2.REFUNDRATEIDSYMBOL, T2.BASERATEIDSYMBOL,
T2.ACCRUALINCOMEDATE, T2.EXDATE, T2.EXRIGHTDATE,
T2.RECORDDATE, T2.TAXBEGINDATE, T2.TAXENTITLEBEGINDT,
T2.TAXENTITLEENDDATE, T2.TAXISSUEDATE, T2.RELEVANTDATE,
T2.TAXFINALDATE,
T2.INCMTXDOMICILETP INCMTXDOMICILETP_TXAMT,
T2.TAXAMOUNTTYPE, T2.TAXCATEGORYTYPE TAXCATEGORYTYPE_TXAMT,
T2.TAXYIELDTYPE TAXYIELDTYPE_TXAMT, T2.AMOUNTTYPE,
T2.INCMTXDOMICILETPV INCMTXDOMICILETPV_TXAMT,
T2.TAXAMOUNTTYPEV,
T2.TAXCATEGORYTYPEV TAXCATEGORYTYPEV_TXAMT,
T2.TAXYIELDTYPEV TAXYIELDTYPEV_TXAMT, T2.AMOUNTTYPEV,
T2.DESCRIPTION_G DESCRIPTION_G_TXAMT,
T2.DESCRIPTION_E DESCRIPTION_E_TXAMT,
T2.DESCRIPTION_F DESCRIPTION_F_TXAMT,
T2.DESCRIPTION_I DESCRIPTION_I_TXAMT,
T2.DESCRIPTION_N DESCRIPTION_N_TXAMT,
T2.PROVIDERTYPE PROVIDERTYPE_TXAMT, T2.PAYDIRECTIONTYPE,
T2.TAXREGULATIONTYPE, T2.TAXREGULATIONTYPEV,
T2.CREATETIMESTAMP CREATETIMESTAMP_TXRTKEY,
T2.UPDATETIMESTAMP UPDATETIMESTAMP_TXRTKEY,
T2.CREATETIMESTAMP CREATETIMESTAMP_TXRTTXAMT,
T2.UPDATETIMESTAMP UPDATETIMESTAMP_TXRTTXAMT
FROM VDPSX.VTTAXRATEKEY T1
INNER JOIN
VDPSX.VTTAXRATETAXAMOUNT T2
ON T2.INSTRUMENTID = T1.INSTRUMENTID AND T2.TAXRATEKEYNO =
T1.TAXRATEKEYNO ;
--
COMMIT;
--
------------------------------------------------------------------------
-- ADB2GEN - End of generated DDL --
------------------------------------------------------------------------
--