zOs/TX/WK920DDS
------------------------------------------------------------------------
-- --
-- Database 2 Administration Tool (DB2 Admin) , program 5697-L90 --
-- --
-- ADB2GEN - Extract object definitions from the DB2 Catalog tables --
-- --
-- Title : SRC VDPS442C 0 --
-- --
-- Input prepared on : DBAF (915) Extract time : 2009-09-04 10:02 --
-- --
-- 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 --
-- --
------------------------------------------------------------------------
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Table=VDPSX.VTLISTING
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Table=VDPSX.VTLISTING In VV24A1X.VDPS185
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPSX';
--
CREATE TABLE VDPSX.VTLISTING
(INSTRUMENTID INTEGER NOT NULL,
LISTINGNO INTEGER NOT NULL,
PROVIDER1ID CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
PROVIDER2ID CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
PROVIDER3ID CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
CREATETIMESTAMP VARCHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
UPDATETIMESTAMP VARCHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
ISMAINTRADINGPLACE SMALLINT WITH DEFAULT NULL,
ISHOMETRADINGPLACE SMALLINT WITH DEFAULT NULL,
ISONLIMITEDHALT SMALLINT WITH DEFAULT NULL,
HASNOMCURRSETTLE SMALLINT WITH DEFAULT NULL,
TRADINGPLACE INTEGER WITH DEFAULT NULL,
CURRENCY INTEGER WITH DEFAULT NULL,
MARKTPRACTIDSYMBOL CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
FIRSTTRADINGDATE VARCHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
LASTTRADINGDATE VARCHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
HALTFROMDATE VARCHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
HALTUNTILDATE VARCHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
FIRSTTRDDTAFHALT VARCHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
TRADINGSTATUSTYPE SMALLINT WITH DEFAULT NULL,
LISTINGSTATUSTYPE SMALLINT WITH DEFAULT NULL,
EXCHANGERATETYPE SMALLINT WITH DEFAULT NULL,
LISTPURPOSETYPE SMALLINT WITH DEFAULT NULL,
TRADINGSTATUSTYPEV VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
LISTINGSTATUSTYPEV VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
EXCHANGERATETYPEV VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
LISTPURPOSETYPEV VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
SHORTNAME_G VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
SHORTNAME_E VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
SHORTNAME_F VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
SHORTNAME_I VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
SHORTNAME_N VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
DESCRIPTION_G VARCHAR(1000) FOR SBCS DATA
WITH DEFAULT NULL,
DESCRIPTION_E VARCHAR(1000) FOR SBCS DATA
WITH DEFAULT NULL,
DESCRIPTION_F VARCHAR(1000) FOR SBCS DATA
WITH DEFAULT NULL,
DESCRIPTION_I VARCHAR(1000) FOR SBCS DATA
WITH DEFAULT NULL,
DESCRIPTION_N VARCHAR(1000) FOR SBCS DATA
WITH DEFAULT NULL,
CSLISTINGCODETYPE SMALLINT WITH DEFAULT NULL,
CSLISTINGCODETYPEV VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
HASINDMARPRACTICE SMALLINT WITH DEFAULT NULL,
PRICINGUNITNO FLOAT WITH DEFAULT NULL,
PRICINGCORRFACTOR FLOAT WITH DEFAULT NULL,
NONVERSEAMOUNT FLOAT WITH DEFAULT NULL,
VOLUMEAMOUNT FLOAT WITH DEFAULT NULL,
TRADINGUNITNO FLOAT WITH DEFAULT NULL,
PRICINGUNITTYPE SMALLINT WITH DEFAULT NULL,
QUOTATIONTYPE SMALLINT WITH DEFAULT NULL,
VOLUMEUNITTYPE SMALLINT WITH DEFAULT NULL,
ACCRUEDINTCALCTP SMALLINT WITH DEFAULT NULL,
FLATREASONTYPE SMALLINT WITH DEFAULT NULL,
TRADINGUNITTYPE SMALLINT WITH DEFAULT NULL,
TRADINGRULETYPE SMALLINT WITH DEFAULT NULL,
PRICINGUNITTYPEV VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
QUOTATIONTYPEV VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
VOLUMEUNITTYPEV VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
ACCRUEDINTCALCTPV VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
FLATREASONTYPEV VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
TRADINGUNITTYPEV VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
TRADINGRULETYPEV VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
VALUEPRICETYPE SMALLINT WITH DEFAULT NULL,
VALUEPRICETYPEV VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
HASLISTINGDETAIL SMALLINT WITH DEFAULT NULL,
EXCHANGETYPE SMALLINT WITH DEFAULT NULL,
EXCHANGETYPEV VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
LISTINGCLASSTYPE SMALLINT WITH DEFAULT NULL,
HASREDUNDANTINFO SMALLINT WITH DEFAULT NULL,
HASBESTTRADINGVENUE SMALLINT WITH DEFAULT NULL,
ISBESTVOLUMEBESTSPREAD SMALLINT WITH DEFAULT NULL,
ISBESTVOLUME SMALLINT WITH DEFAULT NULL,
ISBESTSPREAD SMALLINT WITH DEFAULT NULL,
ISHIGHESTTICKS SMALLINT WITH DEFAULT NULL,
ISBESTVOLUMEPERCURR SMALLINT WITH DEFAULT NULL,
ISBESTSPREADPERCURR SMALLINT WITH DEFAULT NULL,
ISPRIMARYMARKETUSA SMALLINT WITH DEFAULT NULL,
ISSINGLETRADINGPLACE SMALLINT WITH DEFAULT NULL,
ISISSUERPRICEPROVIDER SMALLINT WITH DEFAULT NULL,
ISNAVINDEPENDENTSOURCE SMALLINT WITH DEFAULT NULL,
ISFUNDASSESSMENTSOURCE SMALLINT WITH DEFAULT NULL,
ISCSBESTVENUEOVERALL SMALLINT WITH DEFAULT NULL,
ISCSBESTVENUEPERCURR SMALLINT WITH DEFAULT NULL,
CSBVOVERALLUPDATEUSER CHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
CSBVPERCURRUPDATEUSER CHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
CSBVOVERALLUPDATETS VARCHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
CSBVPERCURRUPDATETS VARCHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
ISPLACEOFQUOTE SMALLINT WITH DEFAULT NULL,
ISPLACEOFLISTING SMALLINT WITH DEFAULT NULL,
ISPLACEOFTRADING SMALLINT WITH DEFAULT NULL,
TRADINGGROUPSYMBOL1 CHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
TRADINGGROUPSYMBOL2 CHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
TRADINGGROUPSYMBOL3 CHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
TRADINGGROUPSYMBOL4 CHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
TRADINGGROUPSYMBOL5 CHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
LISTINGSYMBOLTK CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
LISTINGSYMBOLRT CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
LISTINGSYMBOLBB CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
TRADINGPLACE_BCN CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
TRADINGPLACE_RTX CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
TRADINGPLACE_MIC CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
TRADINGPLACE_BBX CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
CURRENCY_I1 CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
CURRENCY_I2 CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
CURRENCY_WS80 CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
TRADINGPLACE_WS80 CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
PARENTTRADINGPLACE INTEGER WITH DEFAULT NULL,
PARENTTRADINGPLACE_BCN CHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
PARENTTRADINGPLACE_RTX CHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
PARENTTRADINGPLACE_MIC CHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
PARENTTRADINGPLACE_BBX CHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
PARENTTRADINGPLACE_WS80 CHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
TRADINGPLACESYMBOLRIC CHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
TRADINGPLACESYMBOLBBI CHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
MINTRADINGUNITNO FLOAT WITH DEFAULT NULL,
REGULARTRADINGUNITNO FLOAT WITH DEFAULT NULL,
NOMINALTRADINGUNITNO FLOAT WITH DEFAULT NULL,
NMSTRADINGUNITNO FLOAT WITH DEFAULT NULL,
EMSTRADINGUNITNO FLOAT WITH DEFAULT NULL,
SMSTRADINGUNITNO FLOAT WITH DEFAULT NULL,
PTSTRADINGUNITNO FLOAT WITH DEFAULT NULL,
BBMARKETSECTORTYPE SMALLINT WITH DEFAULT NULL,
CONSTRAINT INSTRUMENTID
PRIMARY KEY (INSTRUMENTID,
LISTINGNO))
IN VV24A1X.VDPS185
AUDIT NONE
DATA CAPTURE NONE
CCSID EBCDIC
NOT VOLATILE;
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=VV24A1X
-- Index=VDPSX.VTXLISTING1 On VDPSX.VTLISTING
------------------------------------------------------------------------
--
CREATE UNIQUE INDEX VDPSX.VTXLISTING1
ON VDPSX.VTLISTING
(INSTRUMENTID ASC,
LISTINGNO ASC)
USING STOGROUP GSMS
PRIQTY 428400 SECQTY -1
ERASE NO
FREEPAGE 0 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=VV24A1X
-- Index=VDPSX.VTXLISTING5 On VDPSX.VTLISTING
------------------------------------------------------------------------
--
CREATE INDEX VDPSX.VTXLISTING5
ON VDPSX.VTLISTING
(EXCHANGETYPE ASC)
USING STOGROUP GSMS
PRIQTY 151200 SECQTY -1
ERASE NO
FREEPAGE 0 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Table=VDPSX.VTINSTITUTION
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Table=VDPSX.VTINSTITUTION In VV23A1X.VDPS121
------------------------------------------------------------------------
--
CREATE TABLE VDPSX.VTINSTITUTION
(INSTITUTIONID INTEGER NOT NULL,
HISTORYID INTEGER WITH DEFAULT NULL,
INSTITUTIONTYPE SMALLINT WITH DEFAULT NULL,
ROWSTATUS SMALLINT WITH DEFAULT NULL,
VSTQUALITY SMALLINT WITH DEFAULT NULL,
REVISIONNO SMALLINT WITH DEFAULT NULL,
VSTREQUIREDQUALITY SMALLINT WITH DEFAULT NULL,
VSTMAXIMUMQUALITY SMALLINT WITH DEFAULT NULL,
ISGLOBALREGACC SMALLINT WITH DEFAULT NULL,
HASPENDINGACTVTY SMALLINT WITH DEFAULT NULL,
ISRELEVANT SMALLINT WITH DEFAULT NULL,
HASFUTUREMESSAGES SMALLINT WITH DEFAULT NULL,
FOTWIZISDISABLED SMALLINT WITH DEFAULT NULL,
ISONDB SMALLINT WITH DEFAULT NULL,
LOCATION INTEGER WITH DEFAULT NULL,
VSTNAME CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
VSTVERSION CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
CREATEUSERID CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
UPDATEUSERID CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
PROVIDER1SYMBOL CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
PROVIDER2SYMBOL CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
PROVIDER3SYMBOL CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
DELETIONDATE VARCHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
CREATETIMESTAMP VARCHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
UPDATETIMESTAMP VARCHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
STATUSTYPE SMALLINT WITH DEFAULT NULL,
DELETEREASONTYPE SMALLINT WITH DEFAULT NULL,
MAINLANGUAGETYPE SMALLINT WITH DEFAULT NULL,
FOTYPE SMALLINT WITH DEFAULT NULL,
DATASTATUSTYPE SMALLINT WITH DEFAULT NULL,
BLOCKINGCODETYPE SMALLINT WITH DEFAULT NULL,
LOGICDELETIONTYPE SMALLINT WITH DEFAULT NULL,
STATUSTYPEV VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
DELETEREASONTYPEV VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
MAINLANGUAGETYPEV VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
FOTYPEV VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
DATASTATUSTYPEV VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
BLOCKINGCODETYPEV VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
LOGICDELETIONTYPEV VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
SHORTNAME_G VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
SHORTNAME_E VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
SHORTNAME_F VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
SHORTNAME_I VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
SHORTNAME_N VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
NAME_G VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
NAME_E VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
NAME_F VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
NAME_I VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
NAME_N VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
MODIFICATIONREASON VARCHAR(2000) FOR SBCS DATA
WITH DEFAULT NULL,
REMARKS VARCHAR(2000) FOR SBCS DATA
WITH DEFAULT NULL,
DESCRIPTION_G VARCHAR(1000) FOR SBCS DATA
WITH DEFAULT NULL,
DESCRIPTION_E VARCHAR(1000) FOR SBCS DATA
WITH DEFAULT NULL,
DESCRIPTION_F VARCHAR(1000) FOR SBCS DATA
WITH DEFAULT NULL,
DESCRIPTION_I VARCHAR(1000) FOR SBCS DATA
WITH DEFAULT NULL,
DESCRIPTION_N VARCHAR(1000) FOR SBCS DATA
WITH DEFAULT NULL,
KANTONSCODETYPE SMALLINT WITH DEFAULT NULL,
KANTONSCODETYPEV VARCHAR(1000) FOR SBCS DATA
WITH DEFAULT NULL,
PORTFOLIONO INTEGER WITH DEFAULT NULL,
HASADDRESS SMALLINT WITH DEFAULT NULL,
DOMICILE INTEGER WITH DEFAULT NULL,
TAXDOMICILE INTEGER WITH DEFAULT NULL,
ADDRESSLOCATION INTEGER WITH DEFAULT NULL,
ACCOUNTINGCURR INTEGER WITH DEFAULT NULL,
INITIALMARGINRATE FLOAT WITH DEFAULT NULL,
DOMICILE_A2 CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
DOMICILE_WS80 CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
TAXDOMICILE_A2 CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
TAXDOMICILE_WS80 CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
INDUSTRYCS CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
INDUSTRYTKBN CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
INDUSTRYMSCI CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
INDUSTRYDJ CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
INDUSTRYFTSE CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
INDUSTRYMFIB CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
INDUSTRYMFIS CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
INDUSTRYICB CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
INDUSTRYBDF CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
TAXNUMBER CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
NONTAXABLENUMBER CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
HOUSENUMBER CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
ZIP CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
TELEFAXNUMBER CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
BANKACCOUNTNUMBER CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
NATIONALBANKCODE CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
FOUNDATIONDATE VARCHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
PREVFINYEARENDDATE VARCHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
ACTFINYEARENDDATE VARCHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
REGISTERENTRYDATE VARCHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
REGENTRYDELETIONDT VARCHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
YEARENDDATE VARCHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
NEXTSEMESTERREPORT VARCHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
NONTAXABLEDATE VARCHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
PREVIOUSYEARENDDT VARCHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
LEGALFORMTYPE SMALLINT WITH DEFAULT NULL,
TRUSTLEGALGUIDETP SMALLINT WITH DEFAULT NULL,
TRUSTSTATUSTYPE SMALLINT WITH DEFAULT NULL,
LEGALFORMTYPEV VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
TRUSTLEGALGUIDETPV VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
TRUSTSTATUSTYPEV VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
CITY VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
INTERNETDOMAIN VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
STREET VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
EMAILNAME VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
PHONENUMBER VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
IBAN VARCHAR(254) FOR SBCS DATA
WITH DEFAULT NULL,
ADDRESS VARCHAR(1000) FOR SBCS DATA
WITH DEFAULT NULL,
ADDRESSDESCR VARCHAR(1000) FOR SBCS DATA
WITH DEFAULT NULL,
HEADOFFICEDESCR VARCHAR(1000) FOR SBCS DATA
WITH DEFAULT NULL,
ADDRESSLOCATION_A2 CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
ADDRESSLOCATION_WS80 CHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
HASREDUNDANTINFO SMALLINT WITH DEFAULT NULL,
MDYISSUERRATING CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
MDYISSUERRATINGDATE VARCHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
MDYISSUERWATCHLISTSTATUSTYPE SMALLINT WITH DEFAULT NULL,
SPISSUERRATING CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
SPISSUERRATINGDATE VARCHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
SPISSUERWATCHLISTSTATUSTYPE SMALLINT WITH DEFAULT NULL,
FITCHISSUERRATING CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
FITCHISSUERRATINGDATE VARCHAR(30) FOR SBCS DATA
WITH DEFAULT NULL,
FITCHISSUERWATCHLISTSTATUSTYPE SMALLINT WITH DEFAULT NULL,
DOMICILE_A3 CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
TAXDOMICILE_A3 CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
ADDRESSLOCATION_A3 CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
DOWRITETOSHADOWTABLES SMALLINT WITH DEFAULT NULL,
CSASSEMBLYNOTIFICATIONTYPE SMALLINT WITH DEFAULT NULL,
INDUSTRYSIC CHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
CONSTRAINT INSTITUTIONID
PRIMARY KEY (INSTITUTIONID))
IN VV23A1X.VDPS121
AUDIT NONE
DATA CAPTURE NONE
CCSID EBCDIC
NOT VOLATILE;
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=VV23A1X
-- Index=VDPSX.VTXINSTITUTION1 On VDPSX.VTINSTITUTION
------------------------------------------------------------------------
--
CREATE UNIQUE INDEX VDPSX.VTXINSTITUTION1
ON VDPSX.VTINSTITUTION
(INSTITUTIONID ASC)
USING STOGROUP GSMS
PRIQTY 10800 SECQTY -1
ERASE NO
FREEPAGE 0 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=VV23A1X
-- Index=VDPSX.VTXINSTITUTION20 On VDPSX.VTINSTITUTION
------------------------------------------------------------------------
--
CREATE INDEX VDPSX.VTXINSTITUTION20
ON VDPSX.VTINSTITUTION
(INSTITUTIONTYPE ASC)
USING STOGROUP GSMS
PRIQTY 4320 SECQTY -1
ERASE NO
FREEPAGE 0 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=VV23A1X
-- Index=VDPSX.VTXINSTITUTION5 On VDPSX.VTINSTITUTION
------------------------------------------------------------------------
--
CREATE INDEX VDPSX.VTXINSTITUTION5
ON VDPSX.VTINSTITUTION
(CREATETIMESTAMP ASC)
PADDED
USING STOGROUP GSMS
PRIQTY 15120 SECQTY -1
ERASE NO
FREEPAGE 0 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=VV23A1X
-- Index=VDPSX.VTXINSTITUTION50 On VDPSX.VTINSTITUTION
------------------------------------------------------------------------
--
CREATE INDEX VDPSX.VTXINSTITUTION50
ON VDPSX.VTINSTITUTION
(STATUSTYPE ASC)
USING STOGROUP GSMS
PRIQTY 4320 SECQTY -1
ERASE NO
FREEPAGE 0 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=VV23A1X
-- Index=VDPSX.VTXINSTITUTION6 On VDPSX.VTINSTITUTION
------------------------------------------------------------------------
--
CREATE INDEX VDPSX.VTXINSTITUTION6
ON VDPSX.VTINSTITUTION
(UPDATETIMESTAMP ASC)
PADDED
USING STOGROUP GSMS
PRIQTY 7200 SECQTY -1
ERASE NO
FREEPAGE 0 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=VV23A1X
-- Index=VDPSX.VTXINSTITUTION7 On VDPSX.VTINSTITUTION
------------------------------------------------------------------------
--
CREATE INDEX VDPSX.VTXINSTITUTION7
ON VDPSX.VTINSTITUTION
(FOTYPE ASC)
USING STOGROUP GSMS
PRIQTY 4320 SECQTY -1
ERASE NO
FREEPAGE 0 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.IDS_SMDSA101
------------------------------------------------------------------------
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","F326930" ;
--
CREATE VIEW VDPSX.IDS_SMDSA101 AS
SELECT T1.INSTRUMENTID, T1.SYMBOLCH, T1.SYMBOLCSFI, T1.SYMBOLISIN,
T1.CSSTATUSTYPE, T1.CATEGORYVDPS, T1.CATEGORYCSGTA,
T1.CATEGORYEUZS, T2.STATUSTYPE, 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.ISSUER_GK, T2.EFFINTERESTRATE,
T2.BORROWERCATTYPE, T2.CSMAINTRADPLACE_WS80,
T2.CSMAINTRADPLACE_BCN, T2.CSMAINTRADPLACE_RTX,
T2.CSMAINTRADPLACE_BBX, T2.MATURITYDATE, T2.NOMINALAMOUNT,
T2.NOMINALCURR_WS80, T2.NOMINALCURR_I1, T2.NOMINALCURR_I2,
T2.BORROWINGLIMITTYPE, T2.CSFUNDTYPE, T2.CSLISTINGCODETYPE,
T2.ISCSMIFIDCOMPLEX, T2.EXPIRATIONDATE,
T2.HASMULTIUNDERLYERS, T2.HASWITHHOLDINGTAX,
T2.INTERESTTYPE, T2.ISREDEEMABLE, T2.LIQUIDATIONRIGHTTYPE,
T2.REGISTRATIONTYPE, T2.CSUNITTYPE,
T2.MOSTLIQUIDMARKETLOCATION_WS80,
T2.MOSTLIQUIDMARKETLOCATION_A3,
T2.MOSTLIQUIDMARKETLOCATION_A2, T2.EXPIRATIONTYPE,
T3.TRADINGPLACE, T4.ISSET02, T5.IDSYMBOL SYMBOLCSGIV,
T1.INSTRUMENTCREATETIMESTAMP, T1.INSTRUMENTUPDATETIMESTAMP
FROM VDPSX.VTINSTRFLATSYMBOLS T1
INNER JOIN
VDPSX.VTINSTRFLATDATA T2
ON T2.INSTRUMENTID = T1.INSTRUMENTID
LEFT OUTER JOIN
VDPSX.VTLISTING T3
ON T3.INSTRUMENTID = T1.INSTRUMENTID AND T3.
ISMAINTRADINGPLACE = 1
LEFT OUTER JOIN
VDPSX.CTCODESET T4
ON T4.INSTRUMENTID = T1.INSTRUMENTID AND T4.CODETYPE = 7
LEFT OUTER JOIN
VDPSX.VTINSTRINGROUP T5
ON T5.INSTRUMENTID = T1.INSTRUMENTID AND T5.SCHEMESYMBOL =
'CSGIV' ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.IDS_SMDSA104
------------------------------------------------------------------------
--
--
CREATE VIEW VDPSX.IDS_SMDSA104 AS
SELECT T1.INSTITUTIONID, T2.IDSYMBOL SYMBOLGK, T1.INDUSTRYCS,
T1.INDUSTRYTKBN, T1.INDUSTRYMSCI, T1.INDUSTRYBDF,
T1.INDUSTRYICB, T1.INDUSTRYMFIB, T1.INDUSTRYMFIS,
T3.IDSYMBOL SYMBOLUIC, T4.IDSYMBOL SYMBOLUKCN,
T5.IDSYMBOL SYMBOLOENB, T6.IDSYMBOL SYMBOLCVR,
T7.IDSYMBOL SYMBOLTVABE, T8.IDSYMBOL SYMBOLRCS,
T9.IDSYMBOL SYMBOLDUNS, T1.DOMICILE_A2, T1.DOMICILE_WS80,
T1.DOMICILE_A3, T10.IDSYMBOL DOMICILE_ISON,
T11.IDSYMBOL DOMICILE_TKN, T12.IDSYMBOL DOMICILE_TKR,
T1.CREATETIMESTAMP, T1.UPDATETIMESTAMP
FROM VDPSX.VTINSTITUTION T1
INNER JOIN
VDPSX.VTINSTIIDENT T2
ON T2.INSTITUTIONID = T1.INSTITUTIONID AND T2.SCHEMESYMBOL
= 'GK'
LEFT OUTER JOIN
VDPSX.VTINSTIIDENT T3
ON T3.INSTITUTIONID = T1.INSTITUTIONID AND T3.SCHEMESYMBOL
= 'UIC'
LEFT OUTER JOIN
VDPSX.VTINSTIIDENT T4
ON T4.INSTITUTIONID = T1.INSTITUTIONID AND T4.SCHEMESYMBOL
= 'UKCN'
LEFT OUTER JOIN
VDPSX.VTINSTIIDENT T5
ON T5.INSTITUTIONID = T1.INSTITUTIONID AND T5.SCHEMESYMBOL
= 'OENB'
LEFT OUTER JOIN
VDPSX.VTINSTIIDENT T6
ON T6.INSTITUTIONID = T1.INSTITUTIONID AND T6.SCHEMESYMBOL
= 'CVR'
LEFT OUTER JOIN
VDPSX.VTINSTIIDENT T7
ON T7.INSTITUTIONID = T1.INSTITUTIONID AND T7.SCHEMESYMBOL
= 'TVABE'
LEFT OUTER JOIN
VDPSX.VTINSTIIDENT T8
ON T8.INSTITUTIONID = T1.INSTITUTIONID AND T8.SCHEMESYMBOL
= 'RCS'
LEFT OUTER JOIN
VDPSX.VTINSTIIDENT T9
ON T9.INSTITUTIONID = T1.INSTITUTIONID AND T9.SCHEMESYMBOL
= 'DUNS'
LEFT OUTER JOIN
VDPSX.VTGEOUNITIDENT T10
ON T10.GEOUNITID = T1.DOMICILE AND T10.SCHEMESYMBOL =
'ISON'
LEFT OUTER JOIN
VDPSX.VTGEOUNITIDENT T11
ON T11.GEOUNITID = T1.DOMICILE AND T11.SCHEMESYMBOL = 'TKN'
LEFT OUTER JOIN
VDPSX.VTGEOUNITIDENT T12
ON T12.GEOUNITID = T1.DOMICILE AND T12.SCHEMESYMBOL = 'TKR' ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.IDS_SMDSA106
------------------------------------------------------------------------
--
--
CREATE VIEW VDPSX.IDS_SMDSA106 AS
SELECT T1.INSTITUTIONID, T1.SYMBOLGK, T1.SYMBOLSP, T1.SYMBOLMDY,
T1.SYMBOLIBEI, T1.CATEGORYVDPS, T1.STATUSTYPE,
T1.ROWSTATUS, T2.NAME_G, T2.NAME_E, T2.NAME_F, T2.NAME_I,
T2.NAME_N, T2.SHORTNAME_G, T2.SHORTNAME_E, T2.SHORTNAME_F,
T2.SHORTNAME_I, T2.SHORTNAME_N, T2.INDUSTRYCS,
T2.DOMICILE_A3 DOMICILE_A3, T2.DOMICILE_WS80 DOMICILE_CS,
T2.DOMICILE_A2 DOMICILE_ISO, T2.LEGALFORMTYPE,
T2.PREVFINYEARENDDATE, T2.REGISTERENTRYDATE,
T2.REGENTRYDELETIONDT, T2.MAINLANGUAGETYPE,
T2.INTERNETDOMAIN, T2.CREATETIMESTAMP, T2.UPDATETIMESTAMP
FROM VDPSX.VTINSTIFLATSYMBOLS T1
INNER JOIN
VDPSX.VTINSTITUTION T2
ON T2.INSTITUTIONID = T1.INSTITUTIONID ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.IDS_SMDSA107
------------------------------------------------------------------------
--
--
CREATE VIEW VDPSX.IDS_SMDSA107 AS
SELECT T1.INSTITUTIONID, T1.SYMBOLGK, T2.NAME_G, T2.NAME_E,
T2.NAME_F, T2.NAME_I, T2.NAME_N, T2.CREATETIMESTAMP,
T2.UPDATETIMESTAMP
FROM VDPSX.VTINSTIFLATSYMBOLS T1
INNER JOIN
VDPSX.VTINSTITUTION T2
ON T2.INSTITUTIONID = T1.INSTITUTIONID ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.IDS_SMDSA112
------------------------------------------------------------------------
--
--
CREATE VIEW VDPSX.IDS_SMDSA112 AS
SELECT T1.INSTITUTIONID, T1.SYMBOLGK, T2.IDSYMBOL IDSYMBOL_RATING,
T2.SCHEMESYMBOL SCHEME_RATING, T2.RATINGDATE,
T2.WATCHLISTSTATTYPE, T2.RATINGSTATUSTYPE, T2.REVIEWDATE,
T2.SOURCETYPE, T2.UNIQUENUMBER, T3.CREATETIMESTAMP,
T3.UPDATETIMESTAMP
FROM VDPSX.VTINSTIFLATSYMBOLS T1
INNER JOIN
(SELECT TA.INSTITUTIONID, TA.IDSYMBOL, TA.SCHEMESYMBOL,
TA.RATINGDATE, TA.WATCHLISTSTATTYPE,
TA.RATINGSTATUSTYPE, TA.REVIEWDATE, TA.SOURCETYPE,
TA.UNIQUENUMBER
FROM VDPSX.VTINSTIRATING TA
WHERE TA.SCHEMESYMBOL = 'CSIB'
AND TA.RATINGDATE = (
SELECT MAX(TC.RATINGDATE)
FROM VDPSX.VTINSTIRATING TC
WHERE TC.INSTITUTIONID = TA.INSTITUTIONID
AND TC.SCHEMESYMBOL = 'CSIB')) T2
ON T2.INSTITUTIONID = T1.INSTITUTIONID
INNER JOIN
VDPSX.VTINSTITUTION T3
ON T3.INSTITUTIONID = T1.INSTITUTIONID ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.IDS_SMDSA114
------------------------------------------------------------------------
--
--
CREATE VIEW VDPSX.IDS_SMDSA114 AS
SELECT T1.INSTITUTIONID, T1.SYMBOLGK, T2.IDSYMBOL IDSYMBOL_RATING,
T2.SCHEMESYMBOL SCHEME_RATING, T2.RATINGDATE,
T2.WATCHLISTSTATTYPE, T2.RATINGSTATUSTYPE, T2.REVIEWDATE,
T2.SOURCETYPE, T2.UNIQUENUMBER, T4.CREATETIMESTAMP,
T4.UPDATETIMESTAMP
FROM VDPSX.VTINSTIFLATSYMBOLS T1
INNER JOIN
(SELECT TA.INSTITUTIONID, TA.IDSYMBOL, TA.SCHEMESYMBOL,
TA.RATINGDATE, TA.WATCHLISTSTATTYPE,
TA.RATINGSTATUSTYPE, TA.REVIEWDATE, TA.SOURCETYPE,
TA.UNIQUENUMBER
FROM VDPSX.VTINSTIRATING TA
WHERE TA.SCHEMESYMBOL IN(
SELECT DISTINCT TB.SCHEMESYMBOL
FROM VDPSX.VTINSTIRATING TB
WHERE TA.INSTITUTIONID = TB.INSTITUTIONID)
AND TA.RATINGDATE = (
SELECT MAX(TC.RATINGDATE)
FROM VDPSX.VTINSTIRATING TC
WHERE TC.INSTITUTIONID = TA.INSTITUTIONID
AND TC.SCHEMESYMBOL = TA.SCHEMESYMBOL
GROUP BY TC.SCHEMESYMBOL)) T2
ON T2.INSTITUTIONID = T1.INSTITUTIONID
INNER JOIN
VDPSX.VTRATINGSCHEME T3
ON T3.SCHEMESYMBOL = T2.SCHEMESYMBOL AND T3.INSTITUTIONID
= 10052339
INNER JOIN
VDPSX.VTINSTITUTION T4
ON T4.INSTITUTIONID = T1.INSTITUTIONID ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.IDS_SMDSA116
------------------------------------------------------------------------
--
--
CREATE VIEW VDPSX.IDS_SMDSA116 AS
SELECT T1.INSTITUTIONID, T1.SYMBOLGK, T2.IDSYMBOL IDSYMBOL_RATING,
T2.SCHEMESYMBOL SCHEME_RATING, T2.RATINGDATE,
T2.WATCHLISTSTATTYPE, T2.RATINGSTATUSTYPE, T2.REVIEWDATE,
T2.SOURCETYPE, T2.UNIQUENUMBER, T4.CREATETIMESTAMP,
T4.UPDATETIMESTAMP
FROM VDPSX.VTINSTIFLATSYMBOLS T1
INNER JOIN
(SELECT TA.INSTITUTIONID, TA.IDSYMBOL, TA.SCHEMESYMBOL,
TA.RATINGDATE, TA.WATCHLISTSTATTYPE,
TA.RATINGSTATUSTYPE, TA.REVIEWDATE, TA.SOURCETYPE,
TA.UNIQUENUMBER
FROM VDPSX.VTINSTIRATING TA
WHERE TA.SCHEMESYMBOL IN(
SELECT DISTINCT TB.SCHEMESYMBOL
FROM VDPSX.VTINSTIRATING TB
WHERE TA.INSTITUTIONID = TB.INSTITUTIONID)
AND TA.RATINGDATE = (
SELECT MAX(TC.RATINGDATE)
FROM VDPSX.VTINSTIRATING TC
WHERE TC.INSTITUTIONID = TA.INSTITUTIONID
AND TC.SCHEMESYMBOL = TA.SCHEMESYMBOL
GROUP BY TC.SCHEMESYMBOL)) T2
ON T2.INSTITUTIONID = T1.INSTITUTIONID
INNER JOIN
VDPSX.VTRATINGSCHEME T3
ON T3.SCHEMESYMBOL = T2.SCHEMESYMBOL AND T3.INSTITUTIONID
= 10052338
INNER JOIN
VDPSX.VTINSTITUTION T4
ON T4.INSTITUTIONID = T1.INSTITUTIONID ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.IDS_SMDS1501
------------------------------------------------------------------------
--
--
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_VCLDP148_V02
------------------------------------------------------------------------
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","F473828" ;
--
CREATE VIEW VDPSX.IDS_VCLDP148_V02 AS
SELECT A.INSTRUMENTID, B.INSTITUTIONID_GK, C.CLEARINGSYSTEMTYPE,
C.DELIVERYMODETYPE, D.SHORTNAME_G, D.SHORTNAME_E,
D.SHORTNAME_F, D.SHORTNAME_I, D.SHORTNAME_N
FROM VDPSX.VTINSTRFLATSYMBOLS A
INNER JOIN
VDPSX.VTINSTIROLE B
ON B.INSTRUMENTID = A.INSTRUMENTID AND B.ROLETYPE = 6
INNER JOIN
VDPSX.VTCLEARINGCUSTODY C
ON C.INSTRUMENTID = B.INSTRUMENTID
INNER JOIN
VDPSX.VTINSTITUTION D
ON D.INSTITUTIONID = B.INSTITUTIONID ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.IDS_VGNTY113
------------------------------------------------------------------------
--
--
CREATE VIEW VDPSX.IDS_VGNTY113 AS
SELECT A.INSTRUMENTID, A.SYMBOLCH,
B.PROVIDER1ID AS PROVIDER1ID_INSTIROLE,
B.PROVIDER2ID AS PROVIDER2ID_INSTIROLE,
B.PROVIDER3ID AS PROVIDER3ID_INSTIROLE, B.INSTITUTIONID,
B.DESCRIPTION_G, B.DESCRIPTION_E, B.DESCRIPTION_F,
B.DESCRIPTION_I, B.DESCRIPTION_N, B.ROLETYPE,
B.GUARANTORROLETYPE, B.INSTITUTIONID_GK, C.GUARANTYNO,
C.PROVIDER1ID AS PROVIDER1ID_GNTY,
C.PROVIDER2ID AS PROVIDER2ID_GNTY,
C.PROVIDER3ID AS PROVIDER3ID_GNTY, C.GUARANTYVALUE,
C.GUARANTYCLAUSETYPE, D.SHORTNAME_G, D.SHORTNAME_E,
D.SHORTNAME_F, D.SHORTNAME_I, D.SHORTNAME_N, D.NAME_G,
D.NAME_E, D.NAME_F, D.NAME_I, D.NAME_N,
D.DESCRIPTION_G DESCRIPTION_G_INSTI,
D.DESCRIPTION_E DESCRIPTION_E_INSTI,
D.DESCRIPTION_F DESCRIPTION_F_INSTI,
D.DESCRIPTION_I DESCRIPTION_I_INSTI,
D.DESCRIPTION_N DESCRIPTION_N_INSTI, D.PORTFOLIONO,
D.DOMICILE, D.TAXDOMICILE, D.ADDRESSLOCATION,
D.ACCOUNTINGCURR, D.INITIALMARGINRATE, D.DOMICILE_A2,
D.DOMICILE_WS80, D.TAXDOMICILE_A2, D.TAXDOMICILE_WS80,
D.INDUSTRYCS, D.INDUSTRYTKBN, D.INDUSTRYMSCI, D.INDUSTRYDJ,
D.INDUSTRYFTSE, D.INDUSTRYMFIB, D.INDUSTRYMFIS,
D.INDUSTRYICB, D.INDUSTRYBDF, D.TAXNUMBER,
D.BANKACCOUNTNUMBER, D.NATIONALBANKCODE, D.DOMICILE_A3,
D.TAXDOMICILE_A3
FROM VDPSX.VTINSTRFLATSYMBOLS A
INNER JOIN
VDPSX.VTINSTIROLE B
ON B.INSTRUMENTID = A.INSTRUMENTID AND B.ROLETYPE = 2
INNER JOIN
VDPSX.VTGUARANTY C
ON C.INSTRUMENTID = B.INSTRUMENTID AND C.INSTIROLENO = B.
INSTIROLENO
INNER JOIN
VDPSX.VTINSTITUTION D
ON D.INSTITUTIONID = B.INSTITUTIONID ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.IDS_VINIR133_V02
------------------------------------------------------------------------
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","F326930" ;
--
CREATE VIEW VDPSX.IDS_VINIR133_V02 AS
SELECT T1.INSTRUMENTID, T1.INSTITUTIONID, T1.ROLETYPE,
T1.GUARANTORROLETYPE, T2.ROWSTATUS, T2.SYMBOLGK,
T2.SYMBOLCSINSTIID, T2.SYMBOLFITCH, T2.SYMBOLSP,
T2.SYMBOLMDY, T2.SYMBOLIBEI, T2.SYMBOLBCN, T2.SYMBOLBCA,
T2.SYMBOLRTX, T2.SYMBOLBBX, T2.SYMBOLBBCX, T2.SYMBOLMIC,
T2.SYMBOLCSGHDST, T2.SYMBOLCSAREG, T2.SYMBOLCSWS80BPL,
T2.SYMBOLCSID01, T2.SYMBOLCSID03, T2.SYMBOLCSID05,
T2.SYMBOLCSID06, T2.CATEGORYVDPS, T2.CATEGORYCSGDIV,
T2.CATEGORYCSGME, T2.CATEGORYCSDG,
T2.CATEGORYTKINSTITUTION, T2.STATUSTYPE, T3.ISGLOBALREGACC,
T3.HASFUTUREMESSAGES, T3.MAINLANGUAGETYPE, T3.FOTYPE,
T3.SHORTNAME_G, T3.SHORTNAME_E, T3.SHORTNAME_F,
T3.SHORTNAME_I, T3.SHORTNAME_N, T3.NAME_G, T3.NAME_E,
T3.NAME_F, T3.NAME_I, T3.NAME_N, T3.KANTONSCODETYPE,
T3.DOMICILE, T3.TAXDOMICILE, T3.ACCOUNTINGCURR,
T3.INITIALMARGINRATE, T3.DOMICILE_A2, T3.DOMICILE_WS80,
T3.TAXDOMICILE_A2, T3.TAXDOMICILE_WS80, T3.INDUSTRYCS,
T3.INDUSTRYTKBN, T3.INDUSTRYMSCI, T3.INDUSTRYDJ,
T3.INDUSTRYFTSE, T3.INDUSTRYMFIB, T3.INDUSTRYMFIS,
T3.INDUSTRYICB, T3.INDUSTRYBDF, T3.TAXNUMBER,
T3.NONTAXABLENUMBER, T3.HOUSENUMBER, T3.ZIP,
T3.TELEFAXNUMBER, T3.BANKACCOUNTNUMBER,
T3.NATIONALBANKCODE, T3.FOUNDATIONDATE,
T3.PREVFINYEARENDDATE, T3.ACTFINYEARENDDATE,
T3.REGISTERENTRYDATE, T3.REGENTRYDELETIONDT,
T3.YEARENDDATE, T3.NEXTSEMESTERREPORT, T3.NONTAXABLEDATE,
T3.PREVIOUSYEARENDDT, T3.LEGALFORMTYPE,
T3.TRUSTLEGALGUIDETP, T3.TRUSTSTATUSTYPE, T3.CITY,
T3.INTERNETDOMAIN, T3.STREET, T3.EMAILNAME, T3.PHONENUMBER,
T3.IBAN, T3.ADDRESS, T3.ADDRESSDESCR, T3.HEADOFFICEDESCR,
T3.ADDRESSLOCATION_A2, T3.ADDRESSLOCATION_WS80,
T3.HASREDUNDANTINFO, T3.MDYISSUERRATING,
T3.MDYISSUERRATINGDATE, T3.MDYISSUERWATCHLISTSTATUSTYPE,
T3.SPISSUERRATING, T3.SPISSUERRATINGDATE,
T3.SPISSUERWATCHLISTSTATUSTYPE, T3.FITCHISSUERRATING,
T3.FITCHISSUERRATINGDATE,
T3.FITCHISSUERWATCHLISTSTATUSTYPE, T3.DOMICILE_A3,
T3.TAXDOMICILE_A3, T3.ADDRESSLOCATION_A3
FROM VDPSX.VTINSTIROLE T1
INNER JOIN
VDPSX.VTINSTIFLATSYMBOLS T2
ON T2.INSTITUTIONID = T1.INSTITUTIONID
INNER JOIN
VDPSX.VTINSTITUTION T3
ON T3.INSTITUTIONID = T2.INSTITUTIONID ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.IDS_VINOP131
------------------------------------------------------------------------
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","F273764" ;
--
CREATE VIEW VDPSX.IDS_VINOP131 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,
T2.INCOMEMODETYPE, T2.MATURITYDATE, T2.EFFINTERESTRATE,
T2.FIRSTPAYDATE, T2.FIRSTPYDATEPERYEAR,
T2.ISCALLFORTXREONLY, T2.ISREDEEMABLE, T2.ISRETRACTABLE,
T2.ISCONVERTBYHOLDER, T2.ISCONVERTBYISSUER,
T2.INTRSTDVDENFRDATE, T2.INTERESTTYPE, T2.INTERESTCALCTYPE,
T2.PAYFREQUENCY, T2.PYFREQUNITTYPE, T2.REPAYPRICEAMOUNT,
T2.REPAYPRICERATE, T2.REPAYPRICECURR, T2.REPAYPRICECURR_I2,
T2.REPAYPRICECURR_I1, T2.REPAYPRICECURR_WS80,
T2.POOLFACTOR, T2.VOTINGRIGHTNO, T2.HASVOTINGRIGHTNO,
T2.HASREDMPINVARCURR, T2.HASWITHHOLDINGTAX,
T2.HASFEDERALSTAMPDUTY, T2.OUTSTANDINGCAPITAL,
T2.ISSUEDCAPITAL, T2.ISCSMIFIDCOMPLEX,
T2.MOSTLIQUIDMARKETLOCATION,
T2.MOSTLIQUIDMARKETLOCATION_A2,
T2.MOSTLIQUIDMARKETLOCATION_A3,
T2.MOSTLIQUIDMARKETLOCATION_WS80, T2.OUTSTANDCAPITALNO,
T2.ISSUEDCAPITALNO, T2.ISSUEAMOUNT, T2.ISSUEPRICE,
T2.ISSUEPRICECURR, T2.ISSUEPRICECURR_I2,
T2.ISSUEPRICECURR_I1, T2.ISSUEPRICECURR_WS80,
T2.SUBSCRBEGINDATE, T2.SUBSCRPLNDENDDATE,
T2.SUBSCRMETHODTYPE, T2.PAYMENTDATE, T2.PLACEMENTTYPE,
T2.ORIGINALISSUER, T2.ORIGINALISSUER_GK, T2.ISSUER,
T2.ISSUER_GK, 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 SHORTNAME_G_FLTDATA,
T2.SHORTNAME_E SHORTNAME_E_FLTDATA,
T2.SHORTNAME_F SHORTNAME_F_FLTDATA,
T2.SHORTNAME_I SHORTNAME_I_FLTDATA,
T2.SHORTNAME_N SHORTNAME_N_FLTDATA,
T3.SHORTNAME_G SHORTNAME_G_ORG_ISSUER,
T3.SHORTNAME_E SHORTNAME_E_ORG_ISSUER,
T3.SHORTNAME_F SHORTNAME_F_ORG_ISSUER,
T3.SHORTNAME_I SHORTNAME_I_ORG_ISSUER,
T3.SHORTNAME_N SHORTNAME_N_ORG_ISSUER,
T3.DOMICILE DOMICILE_ORG_ISSUER,
T3.DOMICILE_A2 DOMICILE_A2_ORG_ISSUER,
T3.DOMICILE_A3 DOMICILE_A3_ORG_ISSUER,
T3.DOMICILE_WS80 DOMICILE_WS80_ORG_ISSUER,
T3.NAME_G NAME_G_ORG_ISSUER, T3.NAME_E NAME_E_ORG_ISSUER,
T3.NAME_F NAME_F_ORG_ISSUER, T3.NAME_I NAME_I_ORG_ISSUER,
T3.NAME_N NAME_N_ORG_ISSUER,
T3.INDUSTRYCS INDUSTRYCS_ORG_ISSUER,
T3.INDUSTRYTKBN INDUSTRYTKBN_ORG_ISSUER,
T3.INDUSTRYMSCI INDUSTRYMSCI_ORG_ISSUER,
T4.SHORTNAME_G SHORTNAME_G_ISSUER,
T4.SHORTNAME_E SHORTNAME_E_ISSUER,
T4.SHORTNAME_F SHORTNAME_F_ISSUER,
T4.SHORTNAME_I SHORTNAME_I_ISSUER,
T4.SHORTNAME_N SHORTNAME_N_ISSUER,
T4.DOMICILE DOMICILE_ISSUER,
T4.DOMICILE_A2 DOMICILE_A2_ISSUER,
T4.DOMICILE_A3 DOMICILE_A3_ISSUER,
T4.DOMICILE_WS80 DOMICILE_WS80_ISSUER,
T4.NAME_G NAME_G_ISSUER, T4.NAME_E NAME_E_ISSUER,
T4.NAME_F NAME_F_ISSUER, T4.NAME_I NAME_I_ISSUER,
T4.NAME_N NAME_N_ISSUER, T4.INDUSTRYCS INDUSTRYCS_ISSUER,
T4.INDUSTRYTKBN INDUSTRYTKBN_ISSUER,
T4.INDUSTRYMSCI INDUSTRYMSCI_ISSUER, T2.NOMINALCURR_I1,
T2.NOMINALCURR_I2, T2.NOMINALCURR_WS80
FROM VDPSX.VTINSTRFLATSYMBOLS T1
INNER JOIN
VDPSX.VTINSTRFLATDATA T2
ON T2.INSTRUMENTID = T1.INSTRUMENTID
INNER JOIN
VDPSX.VTINSTITUTION T3
ON T3.INSTITUTIONID = T2.ORIGINALISSUER
INNER JOIN
VDPSX.VTINSTITUTION T4
ON T4.INSTITUTIONID = T2.ISSUER ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.IDS_VINOP140
------------------------------------------------------------------------
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","OA1A" ;
--
CREATE VIEW VDPSX.IDS_VINOP140 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, 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, 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,
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,
T8.DEFREPAYMENTPERIOD, T8.POSITIONLIMIT,
T8.MARGININPERCENT, T8.MARGININITIALAMOUN,
T8.MARGINSPREADAMOUNT, T8.TICKAMOUNT, T8.TICKSIZE,
T8.CONTRACTSIZE, T8.CONTSIZEUNDERLYING, T8.BONDFLOOR,
T8.DISCOUNT, T8.GUARANTEREPAYPRICE, T8.RESERVENUMBER1,
T8.RESERVENUMBER2, T8.RESERVENUMBER3, T8.RESERVENUMBER4,
T8.RESERVENUMBER5, T8.RESERVENUMBER6, T8.MANDATOR,
T8.RESERVETEXT1, T8.RESERVETEXT2, 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
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_VINOP140_V02
------------------------------------------------------------------------
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","F273764" ;
--
CREATE VIEW VDPSX.IDS_VINOP140_V02 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,
T8.DEFREPAYMENTPERIOD, T8.POSITIONLIMIT,
T8.MARGININPERCENT, T8.MARGININITIALAMOUN,
T8.MARGINSPREADAMOUNT, T8.TICKAMOUNT, T8.TICKSIZE,
T8.CONTRACTSIZE, T8.CONTSIZEUNDERLYING, T8.BONDFLOOR,
T8.DISCOUNT, T8.GUARANTEREPAYPRICE, T8.RESERVENUMBER1,
T8.RESERVENUMBER2, T8.RESERVENUMBER3, T8.RESERVENUMBER4,
T8.RESERVENUMBER5, T8.RESERVENUMBER6, T8.MANDATOR,
T8.RESERVETEXT1, T8.RESERVETEXT2, 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,
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_VINOP140_V03
------------------------------------------------------------------------
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","F578255" ;
--
CREATE VIEW VDPSX.IDS_VINOP140_V03 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_VINSS105
------------------------------------------------------------------------
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","OA1A" ;
--
CREATE VIEW VDPSX.IDS_VINSS105 AS
SELECT T1.INSTRUMENTID, T1.EXERCISEAMOUNT, T1.MINEXERCISEAMOUNT,
T1.EXERCISECURR, T1.EXERCISECURR_I2, T1.EXERCISECURR_I1,
T1.EXERCISECURR_WS80, T1.UNDERINSTRUMENT,
T1.UNDERINSTRUMENT_CH, T1.UNDERINSTRUMENT_ISIN,
T1.UNDERINSTRUMENT_CSFI, T1.HASMULTIUNDERLYERS,
T2.NOMINALCURR, T2.NOMINALCURR_I2, T2.NOMINALCURR_I1,
T2.NOMINALCURR_WS80, T3.DOMICILE, T3.DOMICILE_A2,
T3.DOMICILE_A3, T3.DOMICILE_WS80, T1.HELDAMOUNT,
T1.PAYAMOUNT, T1.PAYDIRECTIONTYPE, T1.OPTIONTYPE,
T1.SETTLESTYLETYPE, T1.OPTIONSTYLETYPE,
T1.EXERCISEBEGINDATE, T1.EXERCISEENDDATE, T1.EXERCISEPLACE,
T1.INCOMETAXRATE, T1.PREMIUMRATE, T1.PARTICIPATIONRATE,
T1.REBATE
FROM VDPSX.VTINSTRFLATDATA T1
LEFT OUTER JOIN
VDPSX.VTINSTRFLATDATA T2
ON T2.INSTRUMENTID = T1.UNDERINSTRUMENT
INNER JOIN
VDPSX.VTINSTITUTION T3
ON T3.INSTITUTIONID = T2.ISSUER ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.IDS_VISCD103
------------------------------------------------------------------------
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","S100447" ;
--
CREATE VIEW VDPSX.IDS_VISCD103 AS
SELECT T1.INSTRUMENTID, T1.ISSUEAMOUNT, T1.ISSUEPRICE,
T1.ISSUEPRICECURR, T1.ISSUEPRICECURR_I2,
T1.ISSUEPRICECURR_I1, T1.ISSUEPRICECURR_WS80,
T1.SUBSCRBEGINDATE, T1.SUBSCRPLNDENDDATE,
T1.SUBSCRMETHODTYPE, T1.PAYMENTDATE, T1.PLACEMENTTYPE,
T1.ORIGINALISSUER, T1.ORIGINALISSUER_GK, T1.ISSUER,
T1.ISSUER_GK, T2.SHORTNAME_G SHORTNAME_G_ORG_ISSUER,
T2.SHORTNAME_E SHORTNAME_E_ORG_ISSUER,
T2.SHORTNAME_F SHORTNAME_F_ORG_ISSUER,
T2.SHORTNAME_I SHORTNAME_I_ORG_ISSUER,
T2.SHORTNAME_N SHORTNAME_N_ORG_ISSUER,
T2.DOMICILE DOMICILE_ORG_ISSUER,
T2.DOMICILE_A2 DOMICILE_A2_ORG_ISSUER,
T2.DOMICILE_A3 DOMICILE_A3_ORG_ISSUER,
T2.DOMICILE_WS80 DOMICILE_WS80_ORG_ISSUER, T2.NAME_G,
T2.NAME_E, T2.NAME_F, T2.NAME_I, T2.NAME_N,
T2.STATUSTYPE STATUSTYPE_ORG_ISSUER, T2.INDUSTRYCS,
T2.INDUSTRYTKBN, T2.INDUSTRYMSCI,
T3.SHORTNAME_G SHORTNAME_G_ISSUER,
T3.SHORTNAME_E SHORTNAME_E_ISSUER,
T3.SHORTNAME_F SHORTNAME_F_ISSUER,
T3.SHORTNAME_I SHORTNAME_I_ISSUER,
T3.SHORTNAME_N SHORTNAME_N_ISSUER,
T3.DOMICILE DOMICILE_ISSUER,
T3.DOMICILE_A2 DOMICILE_A2_ISSUER,
T3.DOMICILE_A3 DOMICILE_A3_ISSUER,
T3.DOMICILE_WS80 DOMICILE_WS80_ISSUER,
T3.STATUSTYPE STATUSTYPE_ISSUER,
T1.CREATETIMESTAMP CREATETIMESTAMP_FLTDATA,
T1.UPDATETIMESTAMP UPDATETIMESTAMP_FLTDATA,
T2.CREATETIMESTAMP CREATETIMESTAMP_INSTI,
T2.UPDATETIMESTAMP UPDATETIMESTAMP_INSTI
FROM VDPSX.VTINSTRFLATDATA T1
INNER JOIN
VDPSX.VTINSTITUTION T2
ON T2.INSTITUTIONID = T1.ORIGINALISSUER
INNER JOIN
VDPSX.VTINSTITUTION T3
ON T3.INSTITUTIONID = T1.ISSUER ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.IDS_VITBD112
------------------------------------------------------------------------
--
--
CREATE VIEW VDPSX.IDS_VITBD112 AS
SELECT T1.INSTITUTIONID, T2.SYMBOLGK, T1.SHORTNAME_G,
T1.SHORTNAME_E, T1.SHORTNAME_F, T1.SHORTNAME_I,
T1.SHORTNAME_N, T1.NAME_G, T1.NAME_E, T1.NAME_F, T1.NAME_I,
T1.NAME_N, T1.FOTYPE, T1.STATUSTYPE, T1.MAINLANGUAGETYPE,
T1.DOMICILE, T1.DOMICILE_A2, T1.DOMICILE_A3,
T1.DOMICILE_WS80, T1.INTERNETDOMAIN, T1.INDUSTRYCS,
T1.INDUSTRYTKBN, T1.INDUSTRYMSCI, T1.INDUSTRYMFIB,
T1.INDUSTRYMFIS, T1.INDUSTRYICB, T1.INDUSTRYBDF,
T1.LEGALFORMTYPE, T1.PREVFINYEARENDDATE,
T1.REGISTERENTRYDATE, T1.REGENTRYDELETIONDT,
T1.MDYISSUERRATING, T1.MDYISSUERRATINGDATE,
T1.MDYISSUERWATCHLISTSTATUSTYPE, T1.SPISSUERRATING,
T1.SPISSUERRATINGDATE, T1.SPISSUERWATCHLISTSTATUSTYPE,
T1.FITCHISSUERRATING, T1.FITCHISSUERRATINGDATE,
T1.FITCHISSUERWATCHLISTSTATUSTYPE,
T1.CREATETIMESTAMP CREATETIMESTAMP_INSTI,
T1.UPDATETIMESTAMP UPDATETIMESTAMP_INSTI,
T2.CREATETIMESTAMP CREATETIMESTAMP_FLTSYMB,
T2.UPDATETIMESTAMP UPDATETIMESTAMP_FLTSYMB
FROM VDPSX.VTINSTITUTION T1
INNER JOIN
VDPSX.VTINSTIFLATSYMBOLS T2
ON T1.INSTITUTIONID = T2.INSTITUTIONID ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.IDS_VITCR118_V02
------------------------------------------------------------------------
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","F326930" ;
--
CREATE VIEW VDPSX.IDS_VITCR118_V02 AS
SELECT T1.SYMBOLCH, T1.INSTRUMENTID, T2.ROLETYPE,
T3.IDSYMBOL IDSYMBOL_RATING, T3.SCHEMESYMBOL SCHEME_RATING,
T3.RATINGDATE, T3.WATCHLISTSTATTYPE, T3.RATINGSTATUSTYPE,
T4.RATINGSCALEVALUE, T6.IDSYMBOL IDSYMBOL_INSTI_RATING,
T6.SCHEMESYMBOL SCHEME_INSTI_RATING,
T7.IDSYMBOL IDSYMBOL_INSTI, T7.SCHEMESYMBOL SCHEME_INSTI,
T8.STATUSTYPE
FROM VDPSX.VTINSTRFLATSYMBOLS T1
INNER JOIN
VDPSX.VTINSTIROLE T2
ON T2.INSTRUMENTID = T1.INSTRUMENTID
INNER JOIN
VDPSX.VTINSTIRATING T3
ON T3.INSTITUTIONID = T2.INSTITUTIONID
INNER JOIN
VDPSX.VTRATINGSYMBOL T4
ON T4.RATINGSYMBOLID = T3.INSTIRATINGNO
INNER JOIN
VDPSX.VTRATINGSCHEME T5
ON T5.SCHEMESYMBOL = T3.SCHEMESYMBOL
INNER JOIN
VDPSX.VTINSTIIDENT T6
ON T6.INSTITUTIONID = T5.INSTITUTIONID
INNER JOIN
VDPSX.VTINSTIIDENT T7
ON T7.INSTITUTIONID = T2.INSTITUTIONID
INNER JOIN
VDPSX.VTINSTITUTION T8
ON T8.INSTITUTIONID = T2.INSTITUTIONID ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.IDS_VLSTG111
------------------------------------------------------------------------
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","OA1A" ;
--
CREATE VIEW VDPSX.IDS_VLSTG111 AS
SELECT T1.INSTRUMENTID, T1.LISTINGNO, T2.SYMBOLCH, T2.SYMBOLISIN,
T2.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,
T3.SHORTNAME_G SHORTNAME_G_INSTI,
T3.SHORTNAME_E SHORTNAME_E_INSTI,
T3.SHORTNAME_F SHORTNAME_F_INSTI,
T3.SHORTNAME_I SHORTNAME_I_INSTI,
T3.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.TRADINGUNITNO,
T1.TRADINGUNITTYPE, T1.TRADINGRULETYPE,
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
FROM VDPSX.VTLISTING T1
INNER JOIN
VDPSX.VTINSTRFLATSYMBOLS T2
ON T1.INSTRUMENTID = T2.INSTRUMENTID
INNER JOIN
VDPSX.VTINSTITUTION T3
ON T3.INSTITUTIONID = T1.TRADINGPLACE ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.IDS_VLSTG111_V02
------------------------------------------------------------------------
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","F578255" ;
--
CREATE VIEW VDPSX.IDS_VLSTG111_V02 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_VTOFF110
------------------------------------------------------------------------
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","OA1A" ;
--
CREATE VIEW VDPSX.IDS_VTOFF110 AS
SELECT T1.INSTRUMENTID, T1.TOFFCHIDSYMBOL, T1.TOFFISINIDSYMBOL,
T1.TOFFCSFIIDSYMBOL, T1.FOTYPE, T1.CONTRACTSIZE,
T1.CONTRACTUNITTYPE, T1.EXERCISECURR, T1.EXERCISECURR_I2,
T1.EXERCISECURR_I1, T1.EXERCISECURR_WS80,
T1.EXERCISEAMOUNT, T1.EXPIRATIONMONTH,
T1.FINALSETTLEMENTTP, T1.FINALUNDERINSTR,
T1.FINALUNDERINSTR_CH, T1.FINALUNDERINSTR_ISIN,
T1.FINALUNDERINSTR_CSFI, T1.MULTIPLIER, T1.OPTIONP42TYPE,
T1.OPTIONSTYLETYPE, T1.OPTIONTYPE, T1.UNDERAMOUNT,
T1.UNDERINSTRUMENT, T1.UNDERINSTRUMENT_CH,
T1.UNDERINSTRUMENT_ISIN, T1.UNDERINSTRUMENT_CSFI,
T1.UNDERUNITTYPE, T1.VERSIONSYMBOL, T1.UNDERLYINGNAME_G,
T1.UNDERLYINGNAME_E, T1.UNDERLYINGNAME_F,
T1.UNDERLYINGNAME_I, T1.UNDERLYINGNAME_N,
T1.UNDERFIXINIDSYMBOL, T1.CSSTATUSTYPE, T1.EXPIRATIONDATE,
T1.NAME_G, T1.NAME_E, T1.NAME_F, T1.NAME_I, T1.NAME_N,
T1.TOFFUNDERTYPE, T1.CSEXPIRATIONDATE, T1.TICK,
T1.TICKSIZE, T2.NOMINALCURR, T2.NOMINALCURR_I2,
T2.NOMINALCURR_I1, T2.NOMINALCURR_WS80, T3.DOMICILE,
T3.DOMICILE_A2, T3.DOMICILE_A3, T3.DOMICILE_WS80,
T3.SHORTNAME_G SHORTNAME_G_ISSUER,
T3.SHORTNAME_E SHORTNAME_E_ISSUER,
T3.SHORTNAME_F SHORTNAME_F_ISSUER,
T3.SHORTNAME_I SHORTNAME_I_ISSUER,
T3.SHORTNAME_N SHORTNAME_N_ISSUER, T3.NAME_G NAME_G_ISSUER,
T3.NAME_E NAME_E_ISSUER, T3.NAME_F NAME_F_ISSUER,
T3.NAME_I NAME_I_ISSUER, T3.NAME_N NAME_N_ISSUER,
T3.INDUSTRYTKBN INDUSTRYTKBN_ISSUER,
T3.INDUSTRYMSCI INDUSTRYMSCI_ISSUER, T4.ISOTC,
T4.SHORTNAME_G, T4.SHORTNAME_E, T4.SHORTNAME_F,
T4.SHORTNAME_I, T4.SHORTNAME_N, T4.NAME45_G, T4.NAME45_E,
T4.NAME45_F, T4.NAME45_I, T4.NAME45_N, T4.NAME35_G,
T4.NAME35_E, T4.NAME35_F, T4.NAME35_I, T4.NAME35_N,
T4.PREPARTICLE_G, T4.PREPARTICLE_E, T4.PREPARTICLE_F,
T4.PREPARTICLE_I, T4.PREPARTICLE_N, T4.POSTPARTICLE_G,
T4.POSTPARTICLE_E, T4.POSTPARTICLE_F, T4.POSTPARTICLE_I,
T4.POSTPARTICLE_N, T4.STATUSTYPE, T5.CATEGORYTKT,
T5.CATEGORYCSGTA, T6.NOMINALCURR_I2 NOMINALCURR_I2_UI,
T6.NOMINALCURR_I1 NOMINALCURR_I1_UI,
T6.NOMINALCURR_WS80 NOMINALCURR_WS80_UI,
T7.DOMICILE_A2 DOMICILE_A2_UI,
T7.DOMICILE_A3 DOMICILE_A3_UI,
T7.DOMICILE_WS80 DOMICILE_WS80_UI,
T7.SHORTNAME_G SHORTNAME_G_ISSUER_UI,
T7.SHORTNAME_E SHORTNAME_E_ISSUER_UI,
T7.SHORTNAME_F SHORTNAME_F_ISSUER_UI,
T7.SHORTNAME_I SHORTNAME_I_ISSUER_UI,
T7.SHORTNAME_N SHORTNAME_N_ISSUER_UI,
T7.NAME_G NAME_G_ISSUER_UI, T7.NAME_E NAME_E_ISSUER_UI,
T7.NAME_F NAME_F_ISSUER_UI, T7.NAME_I NAME_I_ISSUER_UI,
T7.NAME_N NAME_N_ISSUER_UI,
T7.INDUSTRYTKBN INDUSTRYTKBN_ISSUER_UI,
T7.INDUSTRYMSCI INDUSTRYMSCI_ISSUER_UI,
T1.UNDERINSTRUMENT_CUSIP, T1.FINALUNDERINSTR_CUSIP
FROM VDPSX.VTTOFF T1
INNER JOIN
VDPSX.VTINSTRFLATDATA T2
ON T2.INSTRUMENTID = T1.FINALUNDERINSTR
INNER JOIN
VDPSX.VTINSTITUTION T3
ON T3.INSTITUTIONID = T2.ISSUER
INNER JOIN
VDPSX.VTINSTRFLATDATA T4
ON T4.INSTRUMENTID = T1.INSTRUMENTID
INNER JOIN
VDPSX.VTINSTRFLATSYMBOLS T5
ON T5.INSTRUMENTID = T1.INSTRUMENTID
INNER JOIN
VDPSX.VTINSTRFLATDATA T6
ON T6.INSTRUMENTID = T1.UNDERINSTRUMENT
INNER JOIN
VDPSX.VTINSTITUTION T7
ON T7.INSTITUTIONID = T6.ISSUER ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.SMDS_RA08_V03
------------------------------------------------------------------------
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","F326930" ;
--
CREATE VIEW VDPSX.SMDS_RA08_V03 AS
SELECT DISTINCT '08' RECORD_TYPE,
SUBSTR(T1.IDSYMBOL, 1, 6) IDSYMBOL_GK,
SUBSTR(T3.SHORTNAME_E, 1, 20) SHORT_E,
SUBSTR(T3.SHORTNAME_G, 1, 20) SHORT_G,
SUBSTR(T3.SHORTNAME_I, 1, 20) SHORT_I,
SUBSTR(T3.SHORTNAME_F, 1, 20) SHORT_F,
SUBSTR(T3.SHORTNAME_N, 1, 20) SHORT_N,
SUBSTR(T3.NAME_E, 1, 80) LONG_E,
SUBSTR(T3.NAME_G, 1, 80) LONG_G,
SUBSTR(T3.NAME_I, 1, 80) LONG_I,
SUBSTR(T3.NAME_F, 1, 80) LONG_F,
SUBSTR(T3.NAME_N, 1, 80) LONG_N, T3.MAINLANGUAGETYPE,
T3.CREATETIMESTAMP, T3.UPDATETIMESTAMP, T3.STATUSTYPE,
T3.DOMICILE_A2 DOMICILE_A2,
T3.TAXDOMICILE_A2 TAXDOMICILE_A2, T3.INDUSTRYTKBN TKBN
FROM VDPSX.VTINSTIIDENT T1
INNER JOIN
VDPSX.VTINSTIROLE T2
ON T2.INSTITUTIONID = T1.INSTITUTIONID AND T2.ROLETYPE IN(1
, 25)
INNER JOIN
VDPSX.VTINSTITUTION T3
ON T3.INSTITUTIONID = T1.INSTITUTIONID AND (T3.ROWSTATUS
IS NULL OR T3.ROWSTATUS <> 2)
WHERE T1.SCHEMESYMBOL = 'GK'
AND T1.ROWSTATUS = 1 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.SMDS_RA15
------------------------------------------------------------------------
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","F273764" ;
--
CREATE VIEW VDPSX.SMDS_RA15 AS
SELECT DISTINCT '15' RECORD_TYPE, T1.IDSYMBOL TKKEY,
T9.IDSYMBOL ISIN, T3.IDSYMBOL CURRENCY_CS,
T6.TRADINGPLACE_BCN EXCHANGE_CODE, T7.IDSYMBOL TICKER,
SUBSTR(T5.SHORTNAME_G, 1, 20) SHORTNAME_G,
SUBSTR(T5.SHORTNAME_E, 1, 20) SHORTNAME_E,
SUBSTR(T5.SHORTNAME_I, 1, 20) SHORTNAME_I,
SUBSTR(T5.SHORTNAME_F, 1, 20) SHORTNAME_F,
SUBSTR(T5.SHORTNAME_N, 1, 20) SHORTNAME_N,
T6.CURRENCY LISTING_CURRENCY,
SUBSTR(T6.SHORTNAME_G, 1, 20) LISTINGNAME_G,
SUBSTR(T6.SHORTNAME_E, 1, 20) LISTINGNAME_E,
SUBSTR(T6.SHORTNAME_I, 1, 20) LISTINGNAME_I,
SUBSTR(T6.SHORTNAME_F, 1, 20) LISTINGNAME_F,
SUBSTR(T6.SHORTNAME_N, 1, 20) LISTINGNAME_N,
T6.MARKTPRACTIDSYMBOL, T6.FIRSTTRADINGDATE,
T6.LASTTRADINGDATE, T6.ISMAINTRADINGPLACE,
T6.ISHOMETRADINGPLACE, T6.CREATETIMESTAMP,
T6.UPDATETIMESTAMP, T6.LISTINGSTATUSTYPE,
T8.INSTITUTIONID INSTRSERVICEID, T8.HASPHYSICALTRADING,
T8.HASELTRONICTRADING, T8.HASELTRONICMATCH
FROM VDPSX.VTLISTING T6
INNER JOIN
VDPSX.VTINSTRIDENT T1
ON T1.INSTRUMENTID = T6.INSTRUMENTID
INNER JOIN
VDPSX.VTINSTRUMENT T2
ON T2.INSTRUMENTID = T1.INSTRUMENTID AND T2.ROWSTATUS IS
NULL AND T2.ISRELEVANT = 1
INNER JOIN
VDPSX.VTINSTITUTION T5
ON T5.INSTITUTIONID = T6.TRADINGPLACE AND T5.ROWSTATUS IS
NULL
INNER JOIN
VDPSX.VTTRADINGPLACE T8
ON T8.INSTITUTIONID = T6.TRADINGPLACE
LEFT OUTER JOIN
VDPSX.VTINSTRIDENT T9
ON T9.INSTRUMENTID = T1.INSTRUMENTID AND T9.SCHEMESYMBOL =
'I-' AND T9.ROWSTATUS = 1
LEFT OUTER JOIN
VDPSX.VTINSTRIDENT T3
ON T3.INSTRUMENTID = T6.CURRENCY AND T3.SCHEMESYMBOL =
'I2' AND T3.ROWSTATUS = 1
LEFT OUTER JOIN
VDPSX.VTLISTINGIDENT T7
ON T7.INSTRUMENTID = T6.INSTRUMENTID AND T7.LISTINGNO = T6.
LISTINGNO AND T7.SCHEMESYMBOL = 'TKH'
WHERE T1.SCHEMESYMBOL = 'CH'
AND T1.ROWSTATUS = 1
AND T7.IDSYMBOL IS NOT NULL
AND T6.LISTINGSTATUSTYPE <> 9
AND T6.LISTINGSTATUSTYPE <> 18 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.VVV_XPS_IL#VLIID_V01
------------------------------------------------------------------------
--
--
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_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_IL#VINLI
------------------------------------------------------------------------
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","F326930" ;
--
CREATE VIEW VDPSX.XPS_IL#VINLI AS
SELECT CHAR(T1.IDSYMBOL, 9) AS VALORNR,
T5.IDSYMBOL AS IDSYMBOL_GK,
CHAR(T4.DOMICILE_WS80, 3) AS DOMICILE_CS, T4.SHORTNAME_G,
T4.SHORTNAME_E, T4.SHORTNAME_F, T4.SHORTNAME_I,
T4.SHORTNAME_N, T4.NAME_G, T4.NAME_E, T4.NAME_F, T4.NAME_I,
T4.NAME_N, DEC(T6.RESERVENUMBER6, 15, 6) AS RESNR6,
CHAR(T4.INDUSTRYCS, 3) AS CS_BRAN,
CHAR(T4.INDUSTRYTKBN, 2) AS TKBN
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.VTINSTIROLE T3
ON T3.INSTRUMENTID = T1.INSTRUMENTID AND T3.ROLETYPE IN(1,
25)
INNER JOIN
VDPSX.VTINSTITUTION T4
ON T4.INSTITUTIONID = T3.INSTITUTIONID AND (T4.ROWSTATUS
IS NULL OR T4.ROWSTATUS <> 2)
INNER JOIN
VDPSX.VTINSTIIDENT T5
ON T5.INSTITUTIONID = T4.INSTITUTIONID AND T5.SCHEMESYMBOL
= 'GK' AND T5.ROWSTATUS = 1
LEFT OUTER JOIN
VDPSX.CTINSTRSP42DETAILS T6
ON T6.INSTRUMENTID = T2.INSTRUMENTID AND T6.MANDATOR = 1
WHERE T1.SCHEMESYMBOL = 'CH'
AND T1.ROWSTATUS = 1 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.XPS_IL#VLIID
------------------------------------------------------------------------
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","F273764" ;
--
CREATE VIEW VDPSX.XPS_IL#VLIID 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.XPS_VCOMP000
------------------------------------------------------------------------
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","F326930" ;
--
CREATE VIEW VDPSX.XPS_VCOMP000 AS
SELECT T1.IDSYMBOL, T1.SCHEMESYMBOL, T1.INSTITUTIONID,
T2.PORTFOLIONO, T2.ACCOUNTINGCURR,
T4.IDSYMBOL ACCOUNTINGCURR_I2,
T5.IDSYMBOL ACCOUNTINGCURR_CS, T2.FOUNDATIONDATE,
T2.PREVFINYEARENDDATE, T2.ACTFINYEARENDDATE,
T2.REGISTERENTRYDATE, T2.REGENTRYDELETIONDT,
T2.LEGALFORMTYPE, T2.CREATETIMESTAMP, T2.UPDATETIMESTAMP
FROM VDPSX.VTINSTIIDENT T1
INNER JOIN
VDPSX.VTINSTITUTION T2
ON T2.INSTITUTIONID = T1.INSTITUTIONID AND (T2.ROWSTATUS
IS NULL OR T2.ROWSTATUS <> 2)
LEFT OUTER JOIN
VDPSX.VTINSTRIDENT T4
ON T4.INSTRUMENTID = T2.ACCOUNTINGCURR AND T4.SCHEMESYMBOL
= 'I2' AND T4.ROWSTATUS = 1
LEFT OUTER JOIN
VDPSX.VTINSTRIDENT T5
ON T5.INSTRUMENTID = T2.ACCOUNTINGCURR AND T5.SCHEMESYMBOL
= 'CS-WS80-WHRG' AND T5.ROWSTATUS = 1
WHERE T1.ROWSTATUS = 1 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.XPS_VCOPR002_V02
------------------------------------------------------------------------
--
--
CREATE VIEW VDPSX.XPS_VCOPR002_V02 AS
SELECT T1.SYMBOLCH, T1.SYMBOLISIN IDSYMBOL_ISIN,
T1.CATEGORYCSGTA IDSYMBOL_CSGTA, T2.STATUSTYPE, T2.NAME_G,
T2.NAME_E, T2.NAME_F, T2.NAME_I, T2.NAME_N,
T4.IDSYMBOL NOMINALCURR_I2, T7.MATURITYDATE,
A1.SYMBOLCH IDSYMBOL_SNB,
CAST(A2.SHORTNAME_E AS CHAR( 30)) SHORTNAME_E_SNB,
T8.ROLETYPE, T8.INSTITUTIONID, T9.IDSYMBOL IDSYMBOL_GK,
T10.SHORTNAME_G, T10.SHORTNAME_E, T10.SHORTNAME_F,
T10.SHORTNAME_I, T10.SHORTNAME_N, T2.CREATETIMESTAMP,
T2.UPDATETIMESTAMP, T10.CREATETIMESTAMP CREATETIMESTAMP_IS,
T10.UPDATETIMESTAMP UPDATETIMESTAMP_IS
FROM VDPSX.VTINSTRFLATSYMBOLS A1
INNER JOIN
VDPSX.VTINSTRUMENT A2
ON A2.INSTRUMENTID = A1.INSTRUMENTID AND (A2.ROWSTATUS IS
NULL OR A2.ROWSTATUS <> 2)
INNER JOIN
VDPSX.VTINSTRSTRUCT A3
ON A3.INSTRUMENTID = A1.INSTRUMENTID
INNER JOIN
VDPSX.VTINSTRFLATSYMBOLS T1
ON T1.INSTRUMENTID = A3.CHILDINSTRID AND T1.ROWSTATUS = 1
INNER JOIN
VDPSX.VTINSTRUMENT T2
ON T2.INSTRUMENTID = T1.INSTRUMENTID AND T1.ROWSTATUS = 1
AND (T2.ROWSTATUS IS NULL OR T2.ROWSTATUS <> 2)
LEFT OUTER JOIN
VDPSX.VTINSTRIDENT T4
ON T4.INSTRUMENTID = T2.NOMINALCURR AND T4.SCHEMESYMBOL =
'I2' AND T4.ROWSTATUS = 1
LEFT OUTER JOIN
VDPSX.VTINSTRWITHCF T7
ON T7.INSTRUMENTID = T1.INSTRUMENTID
LEFT OUTER JOIN
VDPSX.VTINSTIROLE T8
ON T8.INSTRUMENTID = T1.INSTRUMENTID AND T8.ROLETYPE = 2
LEFT OUTER JOIN
VDPSX.VTINSTIIDENT T9
ON T9.INSTITUTIONID = T8.INSTITUTIONID AND T9.SCHEMESYMBOL
= 'GK' AND T9.ROWSTATUS = 1
LEFT OUTER JOIN
VDPSX.VTINSTITUTION T10
ON T10.INSTITUTIONID = T9.INSTITUTIONID AND (T10.ROWSTATUS
IS NULL OR T10.ROWSTATUS <> 2)
WHERE A1.ROWSTATUS = 1
AND A1.SYMBOLCH IN('2584417', '2584418', '1609728') ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.XPS_VDISP000
------------------------------------------------------------------------
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","F281992" ;
--
CREATE VIEW VDPSX.XPS_VDISP000 AS
SELECT T1.IDSYMBOL, T1.SCHEMESYMBOL,
T5.SCHEMESYMBOL PARENT_SCHEME, T5.IDSYMBOL PARENT_IDSYMBOL,
T3.BEGINDATE, T3.ENDDATE, T3.TYPEX, T3.MGMTCONTRACTTYPE,
T3.CHILDINSTIID, T3.PARENTINSTIID, T3.INSTISTRUCTNO,
T3.CREATETIMESTAMP, T3.UPDATETIMESTAMP,
T2.CREATETIMESTAMP CREATETIMESTAMP_IC,
T2.UPDATETIMESTAMP UPDATETIMESTAMP_IC,
T4.CREATETIMESTAMP CREATETIMESTAMP_IP,
T4.UPDATETIMESTAMP UPDATETIMESTAMP_IP
FROM VDPSX.VTINSTIIDENT T1
INNER JOIN
VDPSX.VTINSTITUTION T2
ON T2.INSTITUTIONID = T1.INSTITUTIONID AND (T2.ROWSTATUS
IS NULL OR T2.ROWSTATUS <> 2)
INNER JOIN
VDPSX.VTINSTISTRUCT T3
ON T3.CHILDINSTIID = T2.INSTITUTIONID
INNER JOIN
VDPSX.VTINSTITUTION T4
ON T4.INSTITUTIONID = T3.PARENTINSTIID AND (T4.ROWSTATUS
IS NULL OR T4.ROWSTATUS <> 2)
INNER JOIN
VDPSX.VTINSTIIDENT T5
ON T5.INSTITUTIONID = T4.INSTITUTIONID AND T5.ROWSTATUS = 1
WHERE T1.ROWSTATUS = 1 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.XPS_VDOMI000_V02
------------------------------------------------------------------------
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","OA1A" ;
--
CREATE VIEW VDPSX.XPS_VDOMI000_V02 AS
SELECT T1.IDSYMBOL, T1.SCHEMESYMBOL, T1.INSTITUTIONID,
T2.DOMICILE, T2.DOMICILE_WS80, T2.DOMICILE_A2,
T2.DOMICILE_A3, T2.CREATETIMESTAMP CREATETIMESTAMP_DO,
T2.UPDATETIMESTAMP UPDATETIMESTAMP_DO, T5.FOTYPE,
T5.LOCATIONTYPE, T5.REGIONTYPE, T5.VALIDFROMDATE,
T5.VALIDUNTILDATE, T5.CREATETIMESTAMP CREATETIMESTAMP_GU,
T5.UPDATETIMESTAMP UPDATETIMESTAMP_GU, T5.SHORTNAME_G,
T5.SHORTNAME_E, T5.SHORTNAME_F, T5.SHORTNAME_I,
T5.SHORTNAME_N, T5.NAME_G, T5.NAME_E, T5.NAME_F, T5.NAME_I,
T5.NAME_N
FROM VDPSX.VTINSTIIDENT T1
INNER JOIN
VDPSX.VTINSTITUTION T2
ON T2.INSTITUTIONID = T1.INSTITUTIONID AND (T2.ROWSTATUS
IS NULL OR T2.ROWSTATUS <> 2)
INNER JOIN
VDPSX.VTGEOUNIT T5
ON T5.GEOUNITID = T2.DOMICILE AND (T5.ROWSTATUS IS NULL
OR T5.ROWSTATUS <> 2)
WHERE T1.ROWSTATUS = 1 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.XPS_VGEUC000_V02
------------------------------------------------------------------------
--
--
CREATE VIEW VDPSX.XPS_VGEUC000_V02 AS
SELECT T1.IDSYMBOL, T1.SCHEMESYMBOL,
T6.SCHEMESYMBOL CURRENCY_SCHEME,
T6.IDSYMBOL CURRENCY_IDSYMBOL, T5.FUNCTIONTYPE,
T5.ISLEGALTENDER, T5.VALIDFROMDATE, T5.VALIDUNTILDATE,
T1.INSTITUTIONID, T2.DOMICILE, T5.GEOUNITCURRNO,
T5.CURRENCY, T2.CREATETIMESTAMP CREATETIMESTAMP_DO,
T2.UPDATETIMESTAMP UPDATETIMESTAMP_DO,
T4.CREATETIMESTAMP CREATETIMESTAMP_GU,
T4.UPDATETIMESTAMP UPDATETIMESTAMP_GU,
T5.CREATETIMESTAMP CREATETIMESTAMP_GC,
T5.UPDATETIMESTAMP UPDATETIMESTAMP_GC
FROM VDPSX.VTINSTIIDENT T1
INNER JOIN
VDPSX.VTINSTITUTION T2
ON T2.INSTITUTIONID = T1.INSTITUTIONID AND (T2.ROWSTATUS
IS NULL OR T2.ROWSTATUS <> 2)
INNER JOIN
VDPSX.VTGEOUNIT T4
ON T4.GEOUNITID = T2.DOMICILE AND (T4.ROWSTATUS IS NULL
OR T4.ROWSTATUS <> 2)
INNER JOIN
VDPSX.VTGEOUNITCURR T5
ON T5.GEOUNITID = T4.GEOUNITID
LEFT OUTER JOIN
VDPSX.VTINSTRIDENT T6
ON T6.INSTRUMENTID = T5.CURRENCY AND T6.ROWSTATUS = 1
WHERE T1.ROWSTATUS = 1 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.XPS_VINAC002_V02
------------------------------------------------------------------------
--
--
CREATE VIEW VDPSX.XPS_VINAC002_V02 AS
SELECT T1.IDSYMBOL, T1.SCHEMESYMBOL, T2.CREATETIMESTAMP,
T2.UPDATETIMESTAMP, T2.INDUSTRYCS, T2.INDUSTRYTKBN,
T2.INDUSTRYMSCI, T2.INDUSTRYDJ, T2.INDUSTRYFTSE,
T2.INDUSTRYMFIB, T2.INDUSTRYMFIS, T2.INDUSTRYICB,
T2.INDUSTRYBDF
FROM VDPSX.VTINSTIIDENT T1
INNER JOIN
VDPSX.VTINSTITUTION T2
ON T2.INSTITUTIONID = T1.INSTITUTIONID AND (T2.ROWSTATUS
IS NULL OR T2.ROWSTATUS <> 2)
WHERE T1.ROWSTATUS = 1 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.XPS_VINAC003_V02
------------------------------------------------------------------------
--
--
CREATE VIEW VDPSX.XPS_VINAC003_V02 AS
SELECT T1.IDSYMBOL, T1.SCHEMESYMBOL,
T1.ROWSTATUS ROWSTATUS_INSTIIDENT,
T2.ROWSTATUS ROWSTATUS_INSTITUTION,
T2.CREATETIMESTAMP CREATETIMESTAMP_INDUSTRYACT,
T2.UPDATETIMESTAMP UPDATETIMESTAMP_INDUSTRYACT,
T2.INDUSTRYCS, T2.INDUSTRYTKBN, T2.INDUSTRYMSCI,
T2.INDUSTRYDJ, T2.INDUSTRYFTSE, T2.INDUSTRYMFIB,
T2.INDUSTRYMFIS, T2.INDUSTRYICB, T2.INDUSTRYBDF
FROM VDPSX.VTINSTIIDENT T1
INNER JOIN
VDPSX.VTINSTITUTION T2
ON T2.INSTITUTIONID = T1.INSTITUTIONID ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.XPS_VINFD003
------------------------------------------------------------------------
--
--
CREATE VIEW VDPSX.XPS_VINFD003 AS
SELECT T1.INSTRUMENTID,
T1.CREATETIMESTAMP CREATETIMESTAMP_FLATSYMB,
T1.UPDATETIMESTAMP UPDATETIMESTAMP_FLATSYMB, T1.SYMBOLCH,
T1.SYMBOLCSFI, T1.SYMBOLISIN, T1.SYMBOLGB, T1.SYMBOLUS,
T1.SYMBOLDE, T1.SYMBOLXS, T1.ROWSTATUS, T2.CSSTATUSTYPE,
T2.ISSUEAMOUNT, T2.ISSUEPRICE, T2.ISSUEPRICECURR,
T2.ISSUEPRICECURR_I1, T2.ISSUEPRICECURR_I2,
T2.ISSUEPRICECURR_WS80, T2.SUBSCRBEGINDATE,
T2.SUBSCRPLNDENDDATE, T2.SUBSCRMETHODTYPE, T2.PAYMENTDATE,
T2.PLACEMENTTYPE, T2.ORIGINALISSUER, T2.ORIGINALISSUER_GK,
T2.ISSUER, T2.ISSUER_GK, T3.SHORTNAME_G ISSUER_SHORTNAME_G,
T3.SHORTNAME_E ISSUER_SHORTNAME_E,
T3.SHORTNAME_F ISSUER_SHORTNAME_F,
T3.SHORTNAME_I ISSUER_SHORTNAME_I,
T3.SHORTNAME_N ISSUER_SHORTNAME_N, T3.NAME_G ISSUER_NAME_G,
T3.NAME_E ISSUER_NAME_E, T3.NAME_F ISSUER_NAME_F,
T3.NAME_I ISSUER_NAME_I, T3.NAME_N ISSUER_NAME_N,
T3.DOMICILE ISSUER_DOMICILE,
T3.DOMICILE_A2 ISSUER_DOMICILE_A2,
T3.DOMICILE_A3 ISSUER_DOMICILE_A3,
T3.DOMICILE_WS80 ISSUER_DOMICILE_WS80,
T3.INDUSTRYCS ISSUER_INDUSTRYCS,
T3.INDUSTRYMSCI ISSUER_INDUSTRYMSCI,
T3.INDUSTRYTKBN ISSUER_INDUSTRYTKBN,
T4.SHORTNAME_G ORIG_ISSUER_SHORTNAME_G,
T4.SHORTNAME_E ORIG_ISSUER_SHORTNAME_E,
T4.SHORTNAME_F ORIG_ISSUER_SHORTNAME_F,
T4.SHORTNAME_I ORIG_ISSUER_SHORTNAME_I,
T4.SHORTNAME_N ORIG_ISSUER_SHORTNAME_N,
T4.NAME_G ORIG_ISSUER_NAME_G, T4.NAME_E ORIG_ISSUER_NAME_E,
T4.NAME_F ORIG_ISSUER_NAME_F, T4.NAME_I ORIG_ISSUER_NAME_I,
T4.NAME_N ORIG_ISSUER_NAME_N,
T4.DOMICILE ORIG_ISSUER_DOMICILE,
T4.DOMICILE_A2 ORIG_ISSUER_DOMICILE_A2,
T4.DOMICILE_A3 ORIG_ISSUER_DOMICILE_A3,
T4.DOMICILE_WS80 ORIG_ISSUER_DOMICILE_WS80,
T4.INDUSTRYCS ORIG_ISSUER_INDUSTRYCS,
T4.INDUSTRYMSCI ORIG_ISSUER_INDUSTRYMSCI,
T4.INDUSTRYTKBN ORIG_ISSUER_INDUSTRYTKBN
FROM VDPSX.VTINSTRFLATSYMBOLS T1
INNER JOIN
VDPSX.VTINSTRFLATDATA T2
ON T2.INSTRUMENTID = T1.INSTRUMENTID
INNER JOIN
VDPSX.VTINSTITUTION T3
ON T3.INSTITUTIONID = T2.ISSUER
LEFT OUTER JOIN
VDPSX.VTINSTITUTION T4
ON T4.INSTITUTIONID = T2.ORIGINALISSUER ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.XPS_VINFD008_V02
------------------------------------------------------------------------
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","A394898" ;
--
CREATE VIEW VDPSX.XPS_VINFD008_V02 AS
SELECT T1.INSTRUMENTID, T2.LISTINGNO, T2.CURRENCY, T2.CURRENCY_I1,
T2.CURRENCY_I2, T2.CURRENCY_WS80, T2.TRADINGPLACE,
T2.TRADINGPLACE_BCN, T2.TRADINGPLACE_MIC,
T2.TRADINGPLACE_RTX, T2.TRADINGPLACE_BBX,
T2.SHORTNAME_G LIST_SHORTNAME_G,
T2.SHORTNAME_E LIST_SHORTNAME_E,
T2.SHORTNAME_F LIST_SHORTNAME_F,
T2.SHORTNAME_I LIST_SHORTNAME_I,
T2.SHORTNAME_N LIST_SHORTNAME_N, T2.ISMAINTRADINGPLACE,
T2.LISTINGSYMBOLTK, T2.LISTINGSYMBOLRT, T2.LISTINGSYMBOLBB,
T2.LISTINGSTATUSTYPE, T2.TRADINGSTATUSTYPE,
T2.FIRSTTRADINGDATE, T2.LASTTRADINGDATE,
T2.ISHOMETRADINGPLACE, T2.LISTINGCLASSTYPE,
T2.PRICINGUNITNO, T2.PRICINGUNITTYPE, T2.TRADINGUNITTYPE,
T2.ISCSBESTVENUEOVERALL, T2.ISCSBESTVENUEPERCURR,
T2.ISBESTVOLUMEBESTSPREAD, T2.ISBESTVOLUME,
T2.ISBESTSPREAD, T2.ISHIGHESTTICKS, T2.ISBESTVOLUMEPERCURR,
T2.ISBESTSPREADPERCURR, T2.ISPRIMARYMARKETUSA,
T2.ISSINGLETRADINGPLACE, T2.ISISSUERPRICEPROVIDER,
T2.ISNAVINDEPENDENTSOURCE, T2.ISFUNDASSESSMENTSOURCE,
T2.ISPLACEOFLISTING, T2.ISPLACEOFTRADING,
T2.ISPLACEOFQUOTE, T3.SHORTNAME_G TRAD_SHORTNAME_G,
T3.SHORTNAME_E TRAD_SHORTNAME_E,
T3.SHORTNAME_F TRAD_SHORTNAME_F,
T3.SHORTNAME_I TRAD_SHORTNAME_I,
T3.SHORTNAME_N TRAD_SHORTNAME_N
FROM VDPSX.VTINSTRFLATDATA T1
INNER JOIN
VDPSX.VTLISTING T2
ON T2.INSTRUMENTID = T1.INSTRUMENTID
LEFT OUTER JOIN
VDPSX.VTINSTITUTION T3
ON T3.INSTITUTIONID = T1.ISSUER ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.XPS_VINGR009_V02
------------------------------------------------------------------------
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","F326930" ;
--
CREATE VIEW VDPSX.XPS_VINGR009_V02 AS
SELECT T1.SYMBOLCH, T1.SYMBOLISIN IDSYMBOL_ISIN,
T1.CATEGORYCSGTA IDSYMBOL_CSGTA, T2.STATUSTYPE, T2.NAME_G,
T2.NAME_E, T2.NAME_F, T2.NAME_I, T2.NAME_N,
T4.IDSYMBOL NOMINALCURR_I2, T7.MATURITYDATE,
T3.SCHEMESYMBOL SCHEME_ECBTR, T3.IDSYMBOL IDSYMBOL_ECBTR,
T8.ROLETYPE, T8.INSTITUTIONID, T9.IDSYMBOL IDSYMBOL_GK,
T10.SHORTNAME_G, T10.SHORTNAME_E, T10.SHORTNAME_F,
T10.SHORTNAME_I, T10.SHORTNAME_N, T2.CREATETIMESTAMP,
T2.UPDATETIMESTAMP, T10.CREATETIMESTAMP CREATETIMESTAMP_IS,
T10.UPDATETIMESTAMP UPDATETIMESTAMP_IS
FROM VDPSX.VTINSTRFLATSYMBOLS T1
INNER JOIN
VDPSX.VTINSTRUMENT T2
ON T2.INSTRUMENTID = T1.INSTRUMENTID AND (T2.ROWSTATUS IS
NULL OR T2.ROWSTATUS <> 2)
INNER JOIN
VDPSX.VTINSTRINGROUP T3
ON T3.INSTRUMENTID = T1.INSTRUMENTID AND T3.SCHEMESYMBOL =
'ECBTR'
LEFT OUTER JOIN
VDPSX.VTINSTRIDENT T4
ON T4.INSTRUMENTID = T2.NOMINALCURR AND T4.SCHEMESYMBOL =
'I2' AND T4.ROWSTATUS = 1
LEFT OUTER JOIN
VDPSX.VTINSTRWITHCF T7
ON T7.INSTRUMENTID = T1.INSTRUMENTID
LEFT OUTER JOIN
VDPSX.VTINSTIROLE T8
ON T8.INSTRUMENTID = T1.INSTRUMENTID AND T8.ROLETYPE = 2
LEFT OUTER JOIN
VDPSX.VTINSTIIDENT T9
ON T9.INSTITUTIONID = T8.INSTITUTIONID AND T9.SCHEMESYMBOL
= 'GK' AND T9.ROWSTATUS = 1
LEFT OUTER JOIN
VDPSX.VTINSTITUTION T10
ON T10.INSTITUTIONID = T9.INSTITUTIONID AND (T10.ROWSTATUS
IS NULL OR T10.ROWSTATUS <> 2)
WHERE T1.ROWSTATUS = 1 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.XPS_VINLI000_V05
------------------------------------------------------------------------
--
--
CREATE VIEW VDPSX.XPS_VINLI000_V05 AS
SELECT T1.IDSYMBOL, T1.SCHEMESYMBOL, T3.ROLETYPE,
T4.DOMICILE_WS80 DOMICILE_CS,
T4.DOMICILE_A2 DOMICILE_ISOA2,
T4.DOMICILE_A3 DOMICILE_ISOA3,
T4.TAXDOMICILE_WS80 TAXDOMICILE_CS,
T4.TAXDOMICILE_A2 TAXDOMICILE_ISOA2,
T4.TAXDOMICILE_A3 TAXDOMICILE_ISOA3,
T5.IDSYMBOL IDSYMBOL_INSTI, T5.SCHEMESYMBOL SCHEME_INSTI,
T5.VALIDFROMDATE VALIDFROMDATE_INSTI,
T5.VALIDUNTILDATE VALIDUNTILDATE_INSTI,
T3.GUARANTORROLETYPE, T4.ISGLOBALREGACC, T4.DELETIONDATE,
T4.STATUSTYPE, T4.DELETEREASONTYPE, T4.MAINLANGUAGETYPE,
T4.FOTYPE, T4.KANTONSCODETYPE, T4.INDUSTRYCS BRANCH_CS,
T4.INDUSTRYTKBN BRANCH_TKBN, T4.SHORTNAME_G,
T4.SHORTNAME_E, T4.SHORTNAME_F, T4.SHORTNAME_I,
T4.SHORTNAME_N, T4.NAME_G, T4.NAME_E, T4.NAME_F, T4.NAME_I,
T4.NAME_N, T4.CREATETIMESTAMP CREATETIMESTAMP_INSTI,
T4.UPDATETIMESTAMP UPDATETIMESTAMP_INSTI,
T6.CREDITWORTHINESSTP, T4.CSASSEMBLYNOTIFICATIONTYPE,
T1.ROWSTATUS ROWSTATUS_INSTRIDENT,
T2.ROWSTATUS ROWSTATUS_INSTRUMENT,
T4.ROWSTATUS ROWSTATUS_INSTITUTION,
T5.ROWSTATUS ROWSTATUS_INSTIIDENT,
T2.UPDATETIMESTAMP UPDATETIMESTAMP_INSTRUMENT,
T3.CREATETIMESTAMP CREATETIMESTAMP_RT,
T3.UPDATETIMESTAMP UPDATETIMESTAMP_RT
FROM VDPSX.VTINSTRIDENT T1
INNER JOIN
VDPSX.VTINSTRUMENT T2
ON T2.INSTRUMENTID = T1.INSTRUMENTID
INNER JOIN
VDPSX.VTINSTIROLE T3
ON T3.INSTRUMENTID = T1.INSTRUMENTID
INNER JOIN
VDPSX.VTINSTITUTION T4
ON T4.INSTITUTIONID = T3.INSTITUTIONID
INNER JOIN
VDPSX.VTINSTIIDENT T5
ON T5.INSTITUTIONID = T4.INSTITUTIONID
INNER JOIN
VDPSX.VTINSTRFLATDATA T6
ON T6.INSTRUMENTID = T1.INSTRUMENTID ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.XPS_VINLI007_V02
------------------------------------------------------------------------
--
--
CREATE VIEW VDPSX.XPS_VINLI007_V02 AS
SELECT T1.IDSYMBOL, T1.SCHEMESYMBOL, T3.ROLETYPE,
T3.GUARANTORROLETYPE,
T3.CREATETIMESTAMP CREATETIMESTAMP_RT,
T3.UPDATETIMESTAMP UPDATETIMESTAMP_RT,
T5.IDSYMBOL IDSYMBOL_INSTI, T5.SCHEMESYMBOL SCHEME_INSTI,
T5.VALIDFROMDATE VALIDFROMDATE_GK,
T5.VALIDUNTILDATE VALIDUNTILDATE_GK,
T4.CREATETIMESTAMP CREATETIMESTAMP_GK,
T4.UPDATETIMESTAMP UPDATETIMESTAMP_GK, T4.ISGLOBALREGACC,
T4.DELETIONDATE, T4.STATUSTYPE, T4.DELETEREASONTYPE,
T4.FOTYPE, T4.KANTONSCODETYPE, T4.MAINLANGUAGETYPE,
T4.SHORTNAME_G, T4.SHORTNAME_E, T4.SHORTNAME_F,
T4.SHORTNAME_I, T4.SHORTNAME_N, T4.NAME_G, T4.NAME_E,
T4.NAME_F, T4.NAME_I, T4.NAME_N,
T1.ROWSTATUS ROWSTATUS_INSTRIDENT,
T2.ROWSTATUS ROWSTATUS_INSTRUMENT,
T5.ROWSTATUS ROWSTATUS_INSTIIDENT,
T4.ROWSTATUS ROWSTATUS_INSTITUTION
FROM VDPSX.VTINSTRIDENT T1
INNER JOIN
VDPSX.VTINSTRUMENT T2
ON T2.INSTRUMENTID = T1.INSTRUMENTID
INNER JOIN
VDPSX.VTINSTIROLE T3
ON T3.INSTRUMENTID = T1.INSTRUMENTID
INNER JOIN
VDPSX.VTINSTITUTION T4
ON T4.INSTITUTIONID = T3.INSTITUTIONID
INNER JOIN
VDPSX.VTINSTIIDENT T5
ON T5.INSTITUTIONID = T4.INSTITUTIONID ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.XPS_VINLI008_V03
------------------------------------------------------------------------
--
--
CREATE VIEW VDPSX.XPS_VINLI008_V03 AS
SELECT T1.IDSYMBOL, T1.SCHEMESYMBOL, T3.ROLETYPE,
T0.SCHEMESYMBOL SCHEMESYMB_CSGME, T4.DOMICILE,
T4.TAXDOMICILE, T4.DOMICILE_WS80 DOMICILE_CS,
T4.TAXDOMICILE_WS80 TAXDOMICILE_CS,
T5.IDSYMBOL IDSYMBOL_INSTI, T5.SCHEMESYMBOL SCHEME_INSTI,
T4.ISGLOBALREGACC, T4.DELETIONDATE, T4.STATUSTYPE,
T4.DELETEREASONTYPE, T4.MAINLANGUAGETYPE, T4.FOTYPE,
T4.KANTONSCODETYPE, T4.SHORTNAME_G, T4.SHORTNAME_E,
T4.SHORTNAME_F, T4.SHORTNAME_I, T4.SHORTNAME_N, T4.NAME_G,
T4.NAME_E, T4.NAME_F, T4.NAME_I, T4.NAME_N,
T4.CREATETIMESTAMP, T4.UPDATETIMESTAMP,
T1.ROWSTATUS ROWSTATUS_INSTRIDENT,
T2.ROWSTATUS ROWSTATUS_INSTRUMENT,
T4.ROWSTATUS ROWSTATUS_INSTITUTION,
T5.ROWSTATUS ROWSTATUS_INSTIIDENT
FROM VDPSX.VTINSTRIDENT T1
INNER JOIN
VDPSX.VTINSTRUMENT T2
ON T2.INSTRUMENTID = T1.INSTRUMENTID
INNER JOIN
VDPSX.VTINSTIROLE T3
ON T3.INSTRUMENTID = T1.INSTRUMENTID
INNER JOIN
VDPSX.VTINSTITUTION T4
ON T4.INSTITUTIONID = T3.INSTITUTIONID
LEFT OUTER JOIN
VDPSX.VTINSTIGROUPKEY T0
ON T0.INSTITUTIONID = T3.INSTITUTIONID
INNER JOIN
VDPSX.VTINSTIIDENT T5
ON T5.INSTITUTIONID = T4.INSTITUTIONID ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.XPS_VINLI010_V01
------------------------------------------------------------------------
--
--
CREATE VIEW VDPSX.XPS_VINLI010_V01 AS
SELECT T1.IDSYMBOL, T1.SCHEMESYMBOL, T1.ROWSTATUS,
T1.INSTRUMENTID, T2.ROLETYPE, T2.GUARANTORROLETYPE,
T2.CREATETIMESTAMP CREATETIMESTAMP_RT,
T2.UPDATETIMESTAMP UPDATETIMESTAMP_RT, T2.INSTITUTIONID,
T4.ROWSTATUS ROWSTATUS_GK, T4.IDSYMBOL IDSYMBOL_GK,
T4.VALIDFROMDATE VALIDFROMDATE_GK,
T4.VALIDUNTILDATE VALIDUNTILDATE_GK,
T3.CREATETIMESTAMP CREATETIMESTAMP_GK,
T3.UPDATETIMESTAMP UPDATETIMESTAMP_GK, T3.ISGLOBALREGACC,
T3.DELETIONDATE, T3.STATUSTYPE, T3.DELETEREASONTYPE,
T3.FOTYPE, T3.KANTONSCODETYPE, T3.MAINLANGUAGETYPE,
T3.SHORTNAME_G, T3.SHORTNAME_E, T3.SHORTNAME_F,
T3.SHORTNAME_I, T3.SHORTNAME_N, T3.NAME_G, T3.NAME_E,
T3.NAME_F, T3.NAME_I, T3.NAME_N, T3.DOMICILE_A3,
T3.DOMICILE_A2, T3.DOMICILE_WS80, T3.INDUSTRYTKBN,
T3.INDUSTRYCS, T3.INDUSTRYMSCI, T5.SYMBOLCSID01,
T5.SYMBOLCSID03, T5.SYMBOLCSID05, T5.SYMBOLCSID06,
T6.NAME_G NAME_INDUSTRY_TKBN_G,
T6.NAME_E NAME_INDUSTRY_TKBN_E,
T6.NAME_F NAME_INDUSTRY_TKBN_F,
T6.NAME_I NAME_INDUSTRY_TKBN_I,
T6.NAME_N NAME_INDUSTRY_TKBN_N,
T7.NAME_G NAME_INDUSTRY_CS_G, T7.NAME_E NAME_INDUSTRY_CS_E,
T7.NAME_F NAME_INDUSTRY_CS_F, T7.NAME_I NAME_INDUSTRY_CS_I,
T7.NAME_N NAME_INDUSTRY_CS_N,
T8.NAME_G NAME_INDUSTRY_MSCI_G,
T8.NAME_E NAME_INDUSTRY_MSCI_E,
T8.NAME_F NAME_INDUSTRY_MSCI_F,
T8.NAME_I NAME_INDUSTRY_MSCI_I,
T8.NAME_N NAME_INDUSTRY_MSCI_N
FROM VDPSX.VTINSTRIDENT T1
INNER JOIN
VDPSX.VTINSTIROLE T2
ON T2.INSTRUMENTID = T1.INSTRUMENTID
INNER JOIN
VDPSX.VTINSTITUTION T3
ON T3.INSTITUTIONID = T2.INSTITUTIONID
INNER JOIN
VDPSX.VTINSTIIDENT T4
ON T4.INSTITUTIONID = T3.INSTITUTIONID AND T4.SCHEMESYMBOL
= 'GK' AND T4.ROWSTATUS IN(1, 2)
INNER JOIN
VDPSX.VTINSTIFLATSYMBOLS T5
ON T5.INSTITUTIONID = T2.INSTITUTIONID AND T5.ROWSTATUS = 1
LEFT OUTER JOIN
VDPSX.VTINDUSTRY T6
ON T6.IDSYMBOL = T3.INDUSTRYTKBN AND T6.SCHEMESYMBOL =
'TKBN'
LEFT OUTER JOIN
VDPSX.VTINDUSTRY T7
ON T7.IDSYMBOL = T3.INDUSTRYCS AND T7.SCHEMESYMBOL =
'CS-WS80-BRAN'
LEFT OUTER JOIN
VDPSX.VTINDUSTRY T8
ON T8.IDSYMBOL = T3.INDUSTRYMSCI AND T8.SCHEMESYMBOL =
'MSCI'
WHERE T1.ROWSTATUS IN(1, 2) ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.XPS_VINSH000
------------------------------------------------------------------------
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","F616617" ;
--
CREATE VIEW VDPSX.XPS_VINSH000 AS
SELECT T1.IDSYMBOL, T1.SCHEMESYMBOL, T5.CREATETIMESTAMP,
T5.UPDATETIMESTAMP, T4.IDSYMBOL IDSYMBOL_BCN, T5.MANDATOR,
T5.CONVERSIONFACTOR, T5.ISSTEERINGFLAG1,
T5.ISSTEERINGFLAG2, T5.ISSTEERINGFLAG3, T5.ISSTEERINGFLAG4,
T5.ISSTEERINGFLAG5, T5.ISSTEERINGFLAG6, T5.ISSTEERINGFLAG7,
T5.ISSTEERINGFLAG8, T5.PRIORITYCODE, T5.RESERVESYMBOL,
T5.TRADINGUNITTYPE
FROM VDPSX.VTINSTRIDENT T1
INNER JOIN
VDPSX.VTINSTRUMENT T2
ON T2.INSTRUMENTID = T1.INSTRUMENTID
INNER JOIN
VDPSX.VTLISTING T3
ON T3.INSTRUMENTID = T1.INSTRUMENTID
INNER JOIN
VDPSX.CTLISTING T5
ON T5.INSTRUMENTID = T3.INSTRUMENTID AND T5.LISTINGNO = T3.
LISTINGNO AND T5.ISSTEERINGFLAG4 = 1
INNER JOIN
VDPSX.VTINSTIIDENT T4
ON T4.INSTITUTIONID = T3.TRADINGPLACE AND T4.SCHEMESYMBOL
= 'BCN' AND T4.ROWSTATUS = 1
WHERE T1.ROWSTATUS = 1
AND (T2.ROWSTATUS IS NULL
OR T2.ROWSTATUS <> 2)
AND T3.LISTINGSTATUSTYPE <> 9
AND T3.LISTINGSTATUSTYPE <> 18 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.XPS_VINSH001
------------------------------------------------------------------------
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","F281992" ;
--
CREATE VIEW VDPSX.XPS_VINSH001 AS
SELECT T1.IDSYMBOL, T1.SCHEMESYMBOL, T5.IDSYMBOL IDSYMBOL_BCN,
T9.IDSYMBOL CURRENCY_I2, T3.CURRENCY, T3.TRADINGSTATUSTYPE,
T3.LISTINGSTATUSTYPE, T4.ISSTEERINGFLAG4, T4.MANDATOR,
T6.IDSYMBOL IDSYMBOL_RIC, T7.IDSYMBOL IDSYMBOL_BBI,
T8.IDSYMBOL IDSYMBOL_TK_79,
T3.CREATETIMESTAMP CREATETIMESTAMP_VL,
T3.UPDATETIMESTAMP UPDATETIMESTAMP_VL,
T4.CREATETIMESTAMP CREATETIMESTAMP_CL,
T4.UPDATETIMESTAMP UPDATETIMESTAMP_CL
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
INNER JOIN
VDPSX.CTLISTING T4
ON T4.INSTRUMENTID = T3.INSTRUMENTID AND T4.LISTINGNO = T3.
LISTINGNO AND T4.ISSTEERINGFLAG4 = 1
INNER JOIN
VDPSX.VTINSTIIDENT T5
ON T5.INSTITUTIONID = T3.TRADINGPLACE AND T5.SCHEMESYMBOL
= 'BCN' AND T5.ROWSTATUS = 1
LEFT OUTER JOIN
VDPSX.VTLISTINGIDENT T6
ON T6.INSTRUMENTID = T3.INSTRUMENTID AND T6.LISTINGNO = T3.
LISTINGNO AND T6.SCHEMESYMBOL = 'RIC' AND (T6.ISSECONDARY
IS NULL OR T6.ISSECONDARY = 0)
LEFT OUTER JOIN
VDPSX.VTLISTINGIDENT T7
ON T7.INSTRUMENTID = T3.INSTRUMENTID AND T7.LISTINGNO = T3.
LISTINGNO AND T7.SCHEMESYMBOL = 'BBI' AND (T7.ISSECONDARY
IS NULL OR T7.ISSECONDARY = 0)
LEFT OUTER JOIN
VDPSX.VTLISTINGGRPKEY T8
ON T8.INSTRUMENTID = T3.INSTRUMENTID AND T8.LISTINGNO = T3.
LISTINGNO AND T8.INSTRGRSCHMSYMBOL = 'TK' AND T8.IDSYMBOL
= '79'
LEFT OUTER JOIN
VDPSX.VTINSTRIDENT T9
ON T9.INSTRUMENTID = T3.CURRENCY AND T9.SCHEMESYMBOL =
'I2' AND T9.ROWSTATUS = 1
WHERE T1.ROWSTATUS = 1 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.XPS_VINSH002
------------------------------------------------------------------------
--
--
CREATE VIEW VDPSX.XPS_VINSH002 AS
SELECT T1.IDSYMBOL, T1.SCHEMESYMBOL, T5.IDSYMBOL IDSYMBOL_BCN,
T9.IDSYMBOL CURRENCY_I2, T3.CURRENCY, T3.TRADINGSTATUSTYPE,
T3.LISTINGSTATUSTYPE, T4.ISSTEERINGFLAG4, T4.MANDATOR,
T6.IDSYMBOL IDSYMBOL_RIC, T7.IDSYMBOL IDSYMBOL_BBI,
T8.IDSYMBOL IDSYMBOL_TK_79,
T3.CREATETIMESTAMP CREATETIMESTAMP_VL,
T3.UPDATETIMESTAMP UPDATETIMESTAMP_VL,
T4.CREATETIMESTAMP CREATETIMESTAMP_CL,
T4.UPDATETIMESTAMP UPDATETIMESTAMP_CL
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
INNER JOIN
VDPSX.CTLISTING T4
ON T4.INSTRUMENTID = T3.INSTRUMENTID AND T4.LISTINGNO = T3.
LISTINGNO AND T4.ISSTEERINGFLAG4 = 1
INNER JOIN
VDPSX.VTINSTIIDENT T5
ON T5.INSTITUTIONID = T3.TRADINGPLACE AND T5.SCHEMESYMBOL
= 'BCN' AND T5.ROWSTATUS = 1
LEFT OUTER JOIN
VDPSX.VTLISTINGIDENT T6
ON T6.INSTRUMENTID = T3.INSTRUMENTID AND T6.LISTINGNO = T3.
LISTINGNO AND T6.SCHEMESYMBOL = 'RIC' AND (T6.ISSECONDARY
IS NULL OR T6.ISSECONDARY = 0)
LEFT OUTER JOIN
VDPSX.VTLISTINGIDENT T7
ON T7.INSTRUMENTID = T3.INSTRUMENTID AND T7.LISTINGNO = T3.
LISTINGNO AND T7.SCHEMESYMBOL = 'BBI' AND (T7.ISSECONDARY
IS NULL OR T7.ISSECONDARY = 0)
LEFT OUTER JOIN
VDPSX.VTLISTINGGRPKEY T8
ON T8.INSTRUMENTID = T3.INSTRUMENTID AND T8.LISTINGNO = T3.
LISTINGNO AND T8.INSTRGRSCHMSYMBOL = 'TK' AND T8.IDSYMBOL
= '79'
LEFT OUTER JOIN
VDPSX.VTINSTRIDENT T9
ON T9.INSTRUMENTID = T3.CURRENCY AND T9.SCHEMESYMBOL =
'I2' AND T9.ROWSTATUS = 1
WHERE T1.ROWSTATUS = 1 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.XPS_VISID001
------------------------------------------------------------------------
--
--
CREATE VIEW VDPSX.XPS_VISID001 AS
SELECT T1.IDSYMBOL, T1.SCHEMESYMBOL, T3.IDSYMBOL IDSYMBOL_ID,
T3.SCHEMESYMBOL SCHEMESYMBOL_ID, T1.INSTITUTIONID,
T1.CREATETIMESTAMP, T1.UPDATETIMESTAMP, T1.VALIDFROMDATE,
T1.VALIDUNTILDATE, T3.CREATETIMESTAMP CREATETIMESTAMP_ID,
T3.UPDATETIMESTAMP UPDATETIMESTAMP_ID,
T3.VALIDFROMDATE VALIDFROMDATE_ID,
T3.VALIDUNTILDATE VALIDUNTILDATE_ID
FROM VDPSX.VTINSTIIDENT T1
INNER JOIN
VDPSX.VTINSTITUTION T2
ON T2.INSTITUTIONID = T1.INSTITUTIONID AND (T2.ROWSTATUS
IS NULL OR T2.ROWSTATUS <> 2)
INNER JOIN
VDPSX.VTINSTIIDENT T3
ON T3.INSTITUTIONID = T1.INSTITUTIONID AND T3.ROWSTATUS = 1
WHERE T1.ROWSTATUS = 1 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.XPS_VISID002
------------------------------------------------------------------------
--
--
CREATE VIEW VDPSX.XPS_VISID002 AS
SELECT T1.IDSYMBOL, T1.SCHEMESYMBOL, T3.IDSYMBOL IDSYMBOL_ID,
T3.SCHEMESYMBOL SCHEMESYMBOL_ID, T1.INSTITUTIONID,
T1.VALIDFROMDATE, T1.VALIDUNTILDATE, T1.CREATETIMESTAMP,
T1.UPDATETIMESTAMP, T3.VALIDFROMDATE VALIDFROMDATE_ID,
T3.VALIDUNTILDATE VALIDUNTILDATE_ID,
T3.CREATETIMESTAMP CREATETIMESTAMP_ID,
T3.UPDATETIMESTAMP UPDATETIMESTAMP_ID,
T4.VALIDFROMDATE VALIDFROMDATE_IS,
T4.VALIDUNTILDATE VALIDUNTILDATE_IS,
T4.CREATETIMESTAMP CREATETIMESTAMP_IS,
T4.UPDATETIMESTAMP UPDATETIMESTAMP_IS, T4.NAME_G,
T4.NAME_E, T4.NAME_F, T4.NAME_I, T4.NAME_N
FROM VDPSX.VTINSTIIDENT T1
INNER JOIN
VDPSX.VTINSTITUTION T2
ON T2.INSTITUTIONID = T1.INSTITUTIONID AND (T2.ROWSTATUS
IS NULL OR T2.ROWSTATUS <> 2)
INNER JOIN
VDPSX.VTINSTIIDENT T3
ON T3.INSTITUTIONID = T1.INSTITUTIONID AND T3.ROWSTATUS = 1
INNER JOIN
VDPSX.VTINSTIIDSCHEME T4
ON T4.SCHEMESYMBOL = T3.SCHEMESYMBOL AND (T4.ROWSTATUS IS
NULL OR T4.ROWSTATUS <> 2)
WHERE T1.ROWSTATUS = 1 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.XPS_VISRG000_V02
------------------------------------------------------------------------
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","F326930" ;
--
CREATE VIEW VDPSX.XPS_VISRG000_V02 AS
SELECT T1.IDSYMBOL, T1.SCHEMESYMBOL, T3.ROLETYPE,
T5.IDSYMBOL IDSYMBOL_INSTI, T5.SCHEMESYMBOL SCHEME_INSTI,
T6.IDSYMBOL IDSYMBOL_RATING, T6.SCHEMESYMBOL SCHEME_RATING,
T6.RATINGDATE, T6.RATINGSTATUSTYPE, T6.REVIEWDATE,
T6.WATCHLISTSTATTYPE, T6.SOURCETYPE, T6.UNIQUENUMBER,
T6.CREATETIMESTAMP, T6.UPDATETIMESTAMP,
T1.ROWSTATUS ROWSTATUS_INSTRIDENT,
T2.ROWSTATUS ROWSTATUS_INSTRUMENT,
T5.ROWSTATUS ROWSTATUS_INSTIIDENT,
T4.ROWSTATUS ROWSTATUS_INSTITUTION
FROM VDPSX.VTINSTRIDENT T1
INNER JOIN
VDPSX.VTINSTRUMENT T2
ON T2.INSTRUMENTID = T1.INSTRUMENTID
INNER JOIN
VDPSX.VTINSTIROLE T3
ON T3.INSTRUMENTID = T1.INSTRUMENTID
INNER JOIN
VDPSX.VTINSTITUTION T4
ON T4.INSTITUTIONID = T3.INSTITUTIONID
INNER JOIN
VDPSX.VTINSTIIDENT T5
ON T5.INSTITUTIONID = T4.INSTITUTIONID
INNER JOIN
VDPSX.VTINSTIRATING T6
ON T6.INSTITUTIONID = T3.INSTITUTIONID ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.XPS_VISRG002
------------------------------------------------------------------------
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","F281992" ;
--
CREATE VIEW VDPSX.XPS_VISRG002 AS
SELECT T1.IDSYMBOL, T1.SCHEMESYMBOL,
T3.SCHEMESYMBOL SCHEME_RATING, T3.IDSYMBOL IDSYMBOL_RATING,
T1.INSTITUTIONID, T3.INSTIRATINGNO, T3.RATINGDATE,
T3.RATINGSTATUSTYPE, T3.REVIEWDATE, T3.WATCHLISTSTATTYPE,
T3.SOURCETYPE, T3.UNIQUENUMBER, T3.CREATETIMESTAMP,
T3.UPDATETIMESTAMP
FROM VDPSX.VTINSTIIDENT T1
INNER JOIN
VDPSX.VTINSTITUTION T2
ON T2.INSTITUTIONID = T1.INSTITUTIONID AND T2.ROWSTATUS IS
NULL
INNER JOIN
VDPSX.VTINSTIRATING T3
ON T3.INSTITUTIONID = T2.INSTITUTIONID
WHERE T1.ROWSTATUS = 1 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.XPS_VISTI000
------------------------------------------------------------------------
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","F273764" ;
--
CREATE VIEW VDPSX.XPS_VISTI000 AS
SELECT T1.IDSYMBOL, T1.SCHEMESYMBOL, T1.INSTITUTIONID,
T2.PORTFOLIONO, T2.FOTYPE, T2.STATUSTYPE,
T2.ISGLOBALREGACC, T2.DELETIONDATE, T2.DELETEREASONTYPE,
T2.KANTONSCODETYPE, T2.MAINLANGUAGETYPE, T2.DOMICILE,
T2.DOMICILE_A2, T2.DOMICILE_WS80, T2.TAXDOMICILE,
T2.TAXDOMICILE_A2, T2.TAXDOMICILE_WS80, T2.INDUSTRYCS,
T2.INDUSTRYTKBN, T2.INDUSTRYMSCI, T2.INDUSTRYDJ,
T2.INDUSTRYFTSE, T2.INDUSTRYMFIB, T2.INDUSTRYMFIS,
T2.INDUSTRYICB, T2.INDUSTRYBDF, T2.CREATETIMESTAMP,
T2.UPDATETIMESTAMP, T2.ACCOUNTINGCURR,
T2.ACTFINYEARENDDATE, T2.FOUNDATIONDATE, T2.LEGALFORMTYPE,
T2.PREVFINYEARENDDATE, T2.REGISTERENTRYDATE,
T2.REGENTRYDELETIONDT, T2.LOCATION, T2.INITIALMARGINRATE,
T2.NEXTSEMESTERREPORT, T2.NONTAXABLEDATE,
T2.NONTAXABLENUMBER, T2.PREVIOUSYEARENDDT, T2.TAXNUMBER,
T2.TRUSTLEGALGUIDETP, T2.TRUSTSTATUSTYPE, T2.YEARENDDATE,
T2.ADDRESS, T2.ADDRESSDESCR, T2.ADDRESSLOCATION,
T2.BANKACCOUNTNUMBER, T2.CITY, T2.EMAILNAME,
T2.HEADOFFICEDESCR, T2.HOUSENUMBER, T2.IBAN,
T2.INTERNETDOMAIN, T2.NATIONALBANKCODE, T2.PHONENUMBER,
T2.STREET, T2.TELEFAXNUMBER, T2.ZIP, T2.SHORTNAME_G,
T2.SHORTNAME_E, T2.SHORTNAME_F, T2.SHORTNAME_I,
T2.SHORTNAME_N, T2.NAME_G, T2.NAME_E, T2.NAME_F, T2.NAME_I,
T2.NAME_N
FROM VDPSX.VTINSTIIDENT T1
INNER JOIN
VDPSX.VTINSTITUTION T2
ON T2.INSTITUTIONID = T1.INSTITUTIONID AND (T2.ROWSTATUS
IS NULL OR T2.ROWSTATUS <> 2)
WHERE T1.ROWSTATUS = 1 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.XPS_VITGK002
------------------------------------------------------------------------
--
--
CREATE VIEW VDPSX.XPS_VITGK002 AS
SELECT T1.IDSYMBOL, T1.SCHEMESYMBOL, T1.INSTITUTIONID, T2.FOTYPE,
T2.CREATETIMESTAMP CREATETIMESTAMP_IST,
T2.UPDATETIMESTAMP UPDATETIMESTAMP_IST,
T3.IDSYMBOL IDSYMBOL_GROUP,
T3.SCHEMESYMBOL SCHEMESYMBOL_GROUP,
T3.CREATETIMESTAMP CREATETIMESTAMP_IGK,
T3.UPDATETIMESTAMP UPDATETIMESTAMP_IGK, T4.NAME_G,
T4.NAME_E, T4.NAME_F, T4.NAME_I, T4.NAME_N
FROM VDPSX.VTINSTIIDENT T1
INNER JOIN
VDPSX.VTINSTITUTION T2
ON T2.INSTITUTIONID = T1.INSTITUTIONID AND (T2.ROWSTATUS
IS NULL OR T2.ROWSTATUS <> 2)
INNER JOIN
VDPSX.VTINSTIGROUPKEY T3
ON T3.INSTITUTIONID = T1.INSTITUTIONID
INNER JOIN
VDPSX.VTINSTITUTIONGROUP T4
ON T4.IDSYMBOL = T3.IDSYMBOL AND T4.SCHEMESYMBOL = T3.
SCHEMESYMBOL AND (T4.ROWSTATUS IS NULL OR T4.ROWSTATUS <>
2)
WHERE T1.ROWSTATUS = 1 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.XPS_VLIID000_V02
------------------------------------------------------------------------
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","F616617" ;
--
CREATE VIEW VDPSX.XPS_VLIID000_V02 AS
SELECT T1.IDSYMBOL, T1.SCHEMESYMBOL,
LID.SCHEMESYMBOL SCHEME_TICKER,
LI1.CREATETIMESTAMP VTLISTCREATETIME,
LI1.UPDATETIMESTAMP VTLISTUPDATETIME,
LI2.CREATETIMESTAMP CTLISTCREATETIME,
LI2.UPDATETIMESTAMP CTLISTUPDATETIME,
LID.CREATETIMESTAMP LISTIDCREATETIME,
LID.UPDATETIMESTAMP LISTIDUPDATETIME,
LI1.ISMAINTRADINGPLACE TK_HAUPTBOEPLATZ,
LI1.ISHOMETRADINGPLACE, LI1.ISONLIMITEDHALT,
LI1.HASNOMCURRSETTLE, LI1.CURRENCY, LI1.MARKTPRACTIDSYMBOL,
LI1.FIRSTTRADINGDATE, LI1.LASTTRADINGDATE,
LI1.HALTFROMDATE, LI1.HALTUNTILDATE, LI1.FIRSTTRDDTAFHALT,
LI1.TRADINGSTATUSTYPE, LI1.LISTINGSTATUSTYPE,
LI1.EXCHANGERATETYPE, LI1.LISTPURPOSETYPE, LI1.SHORTNAME_G,
LI1.SHORTNAME_E, LI1.SHORTNAME_F, LI1.SHORTNAME_I,
LI1.SHORTNAME_N, LI1.DESCRIPTION_G, LI1.DESCRIPTION_E,
LI1.DESCRIPTION_F, LI1.DESCRIPTION_I, LI1.DESCRIPTION_N,
LI1.CSLISTINGCODETYPE, LI2.PRIORITYCODE,
LI2.ISSTEERINGFLAG1, LI2.ISSTEERINGFLAG2,
LI2.ISSTEERINGFLAG3, LI2.ISSTEERINGFLAG4 CS_HAUPTBOEPLATZ,
LI2.ISSTEERINGFLAG5, LI2.ISSTEERINGFLAG6,
LI2.ISSTEERINGFLAG7, LI2.ISSTEERINGFLAG8,
LI2.CONVERSIONFACTOR, LI2.RESERVESYMBOL,
LI2.TRADINGUNITTYPE, LID.IDSYMBOL IDSYMBOL_TICKER,
LID.VALIDFROMDATE, LID.VALIDUNTILDATE,
BCN.IDSYMBOL IDSYMBOL_BCN, BCNCS.IDSYMBOL IDSYMBOL_BCNCS,
BCA.IDSYMBOL IDSYMBOL_BCA, LI2.MANDATOR
FROM VDPSX.VTINSTRIDENT T1
INNER JOIN
VDPSX.VTINSTRUMENT
ON T1.INSTRUMENTID = VDPSX.VTINSTRUMENT.INSTRUMENTID AND (
VDPSX.VTINSTRUMENT.ROWSTATUS IS NULL OR VDPSX.
VTINSTRUMENT.ROWSTATUS <> 2) AND T1.ROWSTATUS = 1
INNER JOIN
VDPSX.VTLISTING LI1
ON T1.INSTRUMENTID = LI1.INSTRUMENTID AND LI1.
LISTINGSTATUSTYPE <> 9 AND LI1.LISTINGSTATUSTYPE <> 18
LEFT OUTER JOIN
VDPSX.CTLISTING LI2
ON LI1.INSTRUMENTID = LI2.INSTRUMENTID AND LI1.LISTINGNO =
LI2.LISTINGNO
LEFT OUTER JOIN
VDPSX.VTLISTINGIDENT LID
ON LI1.INSTRUMENTID = LID.INSTRUMENTID AND LI1.LISTINGNO =
LID.LISTINGNO
INNER JOIN
VDPSX.VTINSTIIDENT BCN
ON LI1.TRADINGPLACE = BCN.INSTITUTIONID AND BCN.
SCHEMESYMBOL = 'BCN' AND BCN.ROWSTATUS = 1
LEFT OUTER JOIN
VDPSX.VTINSTIIDENT BCNCS
ON LI1.TRADINGPLACE = BCNCS.INSTITUTIONID AND BCNCS.
SCHEMESYMBOL = 'CS-WS80-BPL' AND BCNCS.ROWSTATUS = 1
LEFT OUTER JOIN
VDPSX.VTINSTIIDENT BCA
ON LI1.TRADINGPLACE = BCA.INSTITUTIONID AND BCA.
SCHEMESYMBOL = 'BCA' AND BCA.ROWSTATUS = 1 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.XPS_VLIID001_V03
------------------------------------------------------------------------
--
--
CREATE VIEW VDPSX.XPS_VLIID001_V03 AS
SELECT T9.IDSYMBOL, IID.IDSYMBOL IDSYMBOL_BCN,
VDPSX.CTLISTING.ISSTEERINGFLAG1 BPL_ST,
VDPSX.CTLISTING.ISSTEERINGFLAG2,
VDPSX.CTLISTING.ISSTEERINGFLAG3 BPL_KS,
VDPSX.CTLISTING.ISSTEERINGFLAG4,
VDPSX.CTLISTING.ISSTEERINGFLAG5 BPL_HA,
VDPSX.CTLISTING.ISSTEERINGFLAG6 AIS_SP,
VDPSX.CTLISTING.ISSTEERINGFLAG7 BPL_IN,
VDPSX.CTLISTING.ISSTEERINGFLAG8 BPL_SP,
VDPSX.CTLISTING.CONVERSIONFACTOR SIZE_UAMT,
VDPSX.CTLISTING.PRIORITYCODE AIS_PRIO,
VDPSX.CTLISTING.TRADINGUNITTYPE HANDLHEIT,
LI1.TRADINGSTATUSTYPE, LI1.LISTINGSTATUSTYPE,
X.IDSYMBOL CURRENCY_CS, T1.SCHEMESYMBOL,
T1.IDSYMBOL IDSYMBOL_TICKER, LI3.RESERVENUMBER2 GENERATION,
LI1.LASTTRADINGDATE GUELTIG_VON
FROM VDPSX.VTINSTRIDENT T9
INNER JOIN
VDPSX.VTINSTRUMENT
ON T9.INSTRUMENTID = VDPSX.VTINSTRUMENT.INSTRUMENTID
INNER JOIN
VDPSX.VTLISTING LI1
ON T9.INSTRUMENTID = LI1.INSTRUMENTID
LEFT OUTER JOIN
VDPSX.CTINSTRSP42DETAILS LI3
ON T9.INSTRUMENTID = LI3.INSTRUMENTID
LEFT OUTER JOIN
VDPSX.VTINSTRIDENT X
ON LI1.CURRENCY = X.INSTRUMENTID AND X.SCHEMESYMBOL =
'CS-WS80-WHRG'
LEFT OUTER JOIN
VDPSX.VTLISTINGIDENT T1
ON LI1.INSTRUMENTID = T1.INSTRUMENTID AND T1.SCHEMESYMBOL
IN('TKH', 'TKE', 'TKL', 'TKM', 'TKT', 'TKS', 'RIC') AND T1.
LISTINGNO = LI1.LISTINGNO
LEFT OUTER JOIN
VDPSX.CTLISTING
ON LI1.INSTRUMENTID = VDPSX.CTLISTING.INSTRUMENTID AND
VDPSX.CTLISTING.LISTINGNO = LI1.LISTINGNO AND VDPSX.
CTLISTING.MANDATOR = 1,
VDPSX.VTINSTIIDENT IID
WHERE T9.SCHEMESYMBOL = 'CH'
AND T9.ROWSTATUS = 1
AND (VDPSX.VTINSTRUMENT.ROWSTATUS IS NULL
OR VDPSX.VTINSTRUMENT.ROWSTATUS <> 2)
AND IID.INSTITUTIONID = LI1.TRADINGPLACE
AND IID.SCHEMESYMBOL = 'CS-WS80-BPL'
AND IID.ROWSTATUS = 1 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.XPS_VLIID001_V04
------------------------------------------------------------------------
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","F326930" ;
--
CREATE VIEW VDPSX.XPS_VLIID001_V04 AS
SELECT T1.IDSYMBOL, T7.IDSYMBOL IDSYMBOL_BCN,
T6.ISSTEERINGFLAG1 BPL_ST, T6.ISSTEERINGFLAG2,
T6.ISSTEERINGFLAG3 BPL_KS, T6.ISSTEERINGFLAG4,
T6.ISSTEERINGFLAG5 BPL_HA, T6.ISSTEERINGFLAG6 AIS_SP,
T6.ISSTEERINGFLAG7 BPL_IN, T6.ISSTEERINGFLAG8 BPL_SP,
T6.CONVERSIONFACTOR SIZE_UAMT, T6.PRIORITYCODE AIS_PRIO,
T6.TRADINGUNITTYPE HANDLHEIT, T3.TRADINGSTATUSTYPE,
T3.LISTINGSTATUSTYPE, T4.IDSYMBOL CURRENCY_CS,
T5.SCHEMESYMBOL, T5.IDSYMBOL IDSYMBOL_TICKER,
T3.LASTTRADINGDATE GUELTIG_VON, T3.NONVERSEAMOUNT,
T6.PRICECALCTYPE
FROM VDPSX.VTINSTRIDENT T1
INNER JOIN
VDPSX.VTINSTRUMENT T2
ON T1.INSTRUMENTID = T2.INSTRUMENTID
INNER JOIN
VDPSX.VTLISTING T3
ON T1.INSTRUMENTID = T3.INSTRUMENTID
LEFT OUTER JOIN
VDPSX.VTINSTRIDENT T4
ON T3.CURRENCY = T4.INSTRUMENTID AND T4.SCHEMESYMBOL =
'CS-WS80-WHRG'
LEFT OUTER JOIN
VDPSX.VTLISTINGIDENT T5
ON T3.INSTRUMENTID = T5.INSTRUMENTID AND T5.SCHEMESYMBOL IN
('TKH', 'TKE', 'TKL', 'TKM', 'TKT', 'TKS', 'RIC') AND T5.
LISTINGNO = T3.LISTINGNO
LEFT OUTER JOIN
VDPSX.CTLISTING T6
ON T3.INSTRUMENTID = T6.INSTRUMENTID AND T6.LISTINGNO = T3.
LISTINGNO AND T6.MANDATOR = 1
INNER JOIN
VDPSX.VTINSTIIDENT T7
ON T7.INSTITUTIONID = T3.TRADINGPLACE AND T7.SCHEMESYMBOL
= 'CS-WS80-BPL' AND T7.ROWSTATUS = 1
WHERE T1.SCHEMESYMBOL = 'CH'
AND T1.ROWSTATUS = 1
AND (T2.ROWSTATUS IS NULL
OR T2.ROWSTATUS <> 2) ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.XPS_VLIID002_V07
------------------------------------------------------------------------
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","F273764" ;
--
CREATE VIEW VDPSX.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_VLIID003
------------------------------------------------------------------------
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","F281992" ;
--
CREATE VIEW VDPSX.XPS_VLIID003 AS
SELECT T1.IDSYMBOL, T1.SCHEMESYMBOL, T3.LISTINGNO,
T4.IDSYMBOL IDSYMBOL_BCN, T5.IDSYMBOL CURRENCY_I2,
T3.TRADINGPLACE, T3.CURRENCY, T3.TRADINGSTATUSTYPE,
T3.LISTINGSTATUSTYPE, T3.EXCHANGETYPE, T3.CREATETIMESTAMP,
T3.UPDATETIMESTAMP, T6.IDSYMBOL IDSYMBOL_RIC,
T7.IDSYMBOL IDSYMBOL_BBI
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
INNER JOIN
VDPSX.VTINSTIIDENT T4
ON T4.INSTITUTIONID = T3.TRADINGPLACE AND T4.SCHEMESYMBOL
= 'BCN' AND T4.ROWSTATUS = 1
LEFT OUTER JOIN
VDPSX.VTINSTRIDENT T5
ON T5.INSTRUMENTID = T3.CURRENCY AND T5.SCHEMESYMBOL =
'I2' AND T5.ROWSTATUS = 1
LEFT OUTER JOIN
VDPSX.VTLISTINGIDENT T6
ON T6.INSTRUMENTID = T3.INSTRUMENTID AND T6.LISTINGNO = T3.
LISTINGNO AND T6.SCHEMESYMBOL = 'RIC' AND (T6.ISSECONDARY
IS NULL OR T6.ISSECONDARY = 0)
LEFT OUTER JOIN
VDPSX.VTLISTINGIDENT T7
ON T7.INSTRUMENTID = T3.INSTRUMENTID AND T7.LISTINGNO = T3.
LISTINGNO AND T7.SCHEMESYMBOL = 'BBI' AND (T7.ISSECONDARY
IS NULL OR T7.ISSECONDARY = 0)
WHERE T1.ROWSTATUS = 1 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.XPS_VLIID004
------------------------------------------------------------------------
--
--
CREATE VIEW VDPSX.XPS_VLIID004 AS
SELECT T1.IDSYMBOL, T1.SCHEMESYMBOL, T3.LISTINGNO,
T4.IDSYMBOL IDSYMBOL_BCN, T5.IDSYMBOL CURRENCY_I2,
T3.TRADINGPLACE, T3.CURRENCY, T3.TRADINGSTATUSTYPE,
T3.LISTINGSTATUSTYPE, T3.EXCHANGETYPE, T3.CREATETIMESTAMP,
T3.UPDATETIMESTAMP, T6.IDSYMBOL IDSYMBOL_RIC,
T7.IDSYMBOL IDSYMBOL_BBI
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
INNER JOIN
VDPSX.VTINSTIIDENT T4
ON T4.INSTITUTIONID = T3.TRADINGPLACE AND T4.SCHEMESYMBOL
= 'BCN' AND T4.ROWSTATUS = 1
LEFT OUTER JOIN
VDPSX.VTINSTRIDENT T5
ON T5.INSTRUMENTID = T3.CURRENCY AND T5.SCHEMESYMBOL =
'I2' AND T5.ROWSTATUS = 1
LEFT OUTER JOIN
VDPSX.VTLISTINGIDENT T6
ON T6.INSTRUMENTID = T3.INSTRUMENTID AND T6.LISTINGNO = T3.
LISTINGNO AND T6.SCHEMESYMBOL = 'RIC' AND (T6.ISSECONDARY
IS NULL OR T6.ISSECONDARY = 0)
LEFT OUTER JOIN
VDPSX.VTLISTINGIDENT T7
ON T7.INSTRUMENTID = T3.INSTRUMENTID AND T7.LISTINGNO = T3.
LISTINGNO AND T7.SCHEMESYMBOL = 'BBI' AND (T7.ISSECONDARY
IS NULL OR T7.ISSECONDARY = 0)
WHERE T1.ROWSTATUS = 1 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.XPS_VLIID005_V02
------------------------------------------------------------------------
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","F326930" ;
--
CREATE VIEW VDPSX.XPS_VLIID005_V02 AS
SELECT T1.IDSYMBOL, T1.SCHEMESYMBOL, T3.CURRENCY,
T3.CSLISTINGCODETYPE, T3.TRADINGPLACE,
T3.TRADINGSTATUSTYPE, T3.LISTINGSTATUSTYPE,
T4.ISSTEERINGFLAG4 CS_HAUPTBOEPLATZ,
T5.IDSYMBOL IDSYMBOL_BCA, T7.IDSYMBOL IDSYMBOL_BCN,
T6.IDSYMBOL IDSYMBOL_TICKER, T6.ISSECONDARY,
T6.SCHEMESYMBOL SCHEMESYMBOL_LIST
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.CTLISTING T4
ON T4.INSTRUMENTID = T3.INSTRUMENTID AND T4.LISTINGNO = T3.
LISTINGNO
INNER JOIN
VDPSX.VTINSTIIDENT T5
ON T5.INSTITUTIONID = T3.TRADINGPLACE AND T5.SCHEMESYMBOL
= 'BCA' AND T5.ROWSTATUS = 1
LEFT OUTER JOIN
VDPSX.VTINSTIIDENT T7
ON T7.INSTITUTIONID = T3.TRADINGPLACE AND T7.SCHEMESYMBOL
= 'BCN' AND T7.ROWSTATUS = 1
LEFT OUTER JOIN
VDPSX.VTLISTINGIDENT T6
ON T6.INSTRUMENTID = T3.INSTRUMENTID AND T6.LISTINGNO = T3.
LISTINGNO
WHERE T1.ROWSTATUS = 1 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.XPS_VNTP001
------------------------------------------------------------------------
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","S100447" ;
--
CREATE VIEW VDPSX.XPS_VNTP001 AS SELECT CAST(FS.SYMBOLCH AS CHAR( 9))
VALOR, CAST(';' AS CHAR( 1)) DL01 , CAST(FS.SYMBOLISIN AS CHAR( 12)) ISI
N, CAST(';' AS CHAR( 1)) DL02, CAST(CASE WHEN Z.MAINLANGUAGETYPE = 1 T
HEN Z.NAME_G WHEN Z.MAINLANGUAGETYPE = 2 THEN Z.NAME_F WHEN Z.MAINLANG
UAGETYPE = 3 THEN Z.NAME_I WHEN Z.MAINLANGUAGETYPE = 4 THEN Z.NAME_E W
HEN Z.MAINLANGUAGETYPE = 5 THEN Z.NAME_N WHEN Z.MAINLANGUAGETYPE = 9999
THEN NULL ELSE NULL END AS CHAR( 254)) ISSUER_NAME, CAST(';' AS CHAR(
1)) DL03, CAST(CASE WHEN A.MAINLANGUAGETYPE = 1 THEN FD.PREPARTICLE_G
WHEN A.MAINLANGUAGETYPE = 2 THEN FD.PREPARTICLE_F WHEN A.MAINLANGUAGETY
PE = 3 THEN FD.PREPARTICLE_I WHEN A.MAINLANGUAGETYPE = 4 THEN FD.PREPAR
TICLE_E WHEN A.MAINLANGUAGETYPE = 5 THEN FD.PREPARTICLE_N WHEN A.MAINL
ANGUAGETYPE = 9999 THEN NULL ELSE NULL END AS CHAR( 254)) INSTR_PREPART
, CAST(';' AS CHAR( 1)) DL04, CAST(CASE WHEN A.MAINLANGUAGETYPE = 1 THE
N FD.POSTPARTICLE_G WHEN A.MAINLANGUAGETYPE = 2 THEN FD.POSTPARTICLE_F
WHEN A.MAINLANGUAGETYPE = 3 THEN FD.POSTPARTICLE_I WHEN A.MAINLANGUAGE
TYPE = 4 THEN FD.POSTPARTICLE_E WHEN A.MAINLANGUAGETYPE = 5 THEN FD.POS
TPARTICLE_N WHEN A.MAINLANGUAGETYPE = 9999 THEN NULL ELSE NULL END AS C
HAR( 254)) INSTR_POSTPART, CAST(';' AS CHAR( 1)) DL05, CAST(A.MAINLANGU
AGETYPE AS CHAR( 4)) MAINLANGUAGETYPE, CAST(';' AS CHAR( 1)) DL06, CAST
(FD. CSSTATUSTYPE AS CHAR( 4)) CSSTATUSTYPE, CAST(';' AS CHAR( 1)) DL07,
CAST(FD.STATUSTYPE AS CHAR( 4)) TKSTATUSTYPE, CAST(';' AS CHAR( 1)) D
L08, CAST(CASE WHEN FD.ISINTERNAL = 1 THEN FD.ISINTERNAL ELSE 0 END AS
CHAR( 1)) CSGIV , CAST(';' AS CHAR( 1)) DL09, FS.CATEGORYCSGMS CSGMS, CA
ST(';' AS CHAR ( 1)) DL10, CAST(FD.CSFUNDTYPE AS CHAR( 4)) CSFUNDTYPE, C
AST(';' AS CHAR( 1)) DL11, CAST(FD.CREDITWORTHINESSTP AS CHAR( 4)) BONI
TAETSCODE, CAST(';' AS CHAR( 1)) DL12, CAST('1' AS CHAR( 1)) MANDATOR,
CAST(';' AS CHAR( 1)) DL13, CAST(CASE WHEN H.NAME_E IS NOT NULL THEN H
.NAME_E WHEN H.NAME_G IS NOT NULL THEN H.NAME_G WHEN H.NAME_F IS NOT N
ULL THEN H.NAME_F WHEN H.NAME_I IS NOT NULL THEN H.NAME_I WHEN H.NAME_
N IS NOT NULL THEN H.NAME_N ELSE NULL END AS CHAR( 254)) MAINDEPOS_NAME
, CAST(';' AS CHAR( 1)) DL14, CAST(Z.YEARENDDATE AS CHAR ( 30)) YEARENDD
ATE, CAST(';' AS CHAR( 1)) DL15, CAST(L. INVENTORYFREQUENCY AS CHAR( 10)
) INVENTORYFREQUENCY, CAST(';' AS CHAR( 1)) DL16, CAST(L.INVENTORYFRUNI
TTP AS CHAR( 4)) INVENTORYFRUNITTP, CAST (';' AS CHAR( 1)) DL17, CAST(L.
NAVPUBLICATDESCR AS CHAR( 254)) NAVPUBLICATDESCR, CAST(';' AS CHAR( 1))
DL18, M.TRADINGPLACE_BCN BCN, CAST(';' AS CHAR( 1)) DL19, M.CURRENCY_I
2 IDSYMBOL_I2, CAST(';' AS CHAR ( 1)) DL20, CAST(CASE WHEN P.ISSTEERING
FLAG4 = 1 THEN '1' WHEN P.ISSTEERINGFLAG4 = 0 THEN '0' WHEN P.ISSTEERI
NGFLAG4 IS NULL THEN ' ' ELSE ' ' END AS CHAR( 1)) ISSTEERINGFLAG4, CAS
T(';' AS CHAR( 1)) DL21, FD.INSTRUMENTID, CAST(';' AS CHAR( 1)) DL22 FR
OM VDPSX.VTINSTRFLATDATA FD INNER JOIN VDPSX. VTINSTRUMENT A ON FD.INSTR
UMENTID = A.INSTRUMENTID AND FD.CSFUNDTYPE IN (2, 3, 6, 10, 11, 12, 14,
18, 23, 27, 28, 29, 30, 31, 32, 33, 34) AND FD.CSSTATUSTYPE IN(4, 6, 7)
INNER JOIN VDPSX.VTINSTITUTION Z ON FD. ISSUER = Z.INSTITUTIONID INNER
JOIN VDPSX.VTINSTITUTION H ON FD. MAINDEPOSITARY = H.INSTITUTIONID INNER
JOIN VDPSX.VTINSTRFLATSYMBOLS FS ON FD.INSTRUMENTID = FS.INSTRUMENTID
AND FS.ROWSTATUS = 1 INNER JOIN VDPSX.CTINSTRB42STOCK I ON I.INSTRUMENT
ID = FD.INSTRUMENTID AND I. HOLDINGSTOTAL = 999999 AND I.MANDATOR = 1 IN
NER JOIN VDPSX.VTLISTING M ON M.INSTRUMENTID = FD.INSTRUMENTID AND M.LI
STINGSTATUSTYPE <> 9 AND M. LISTINGSTATUSTYPE <> 18 LEFT OUTER JOIN VDPS
X.CTLISTING P ON P. INSTRUMENTID = M.INSTRUMENTID AND M.LISTINGNO = P.LI
STINGNO AND P. MANDATOR = 1 LEFT OUTER JOIN VDPSX.VTTRUSTDETAIL L ON L.I
NSTRUMENTID = FD.INSTRUMENTID ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.XPS_VRISI000
------------------------------------------------------------------------
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","F281992" ;
--
CREATE VIEW VDPSX.XPS_VRISI000 AS
SELECT T1.INSTITUTIONID, T1.FOTYPE, T1.ISGLOBALREGACC,
T1.KANTONSCODETYPE, T1.MAINLANGUAGETYPE, T1.STATUSTYPE,
T1.DELETIONDATE, T1.DELETEREASONTYPE, T1.CREATETIMESTAMP,
T1.UPDATETIMESTAMP, T2.SCHEMESYMBOL SCHEMESYMBOL_BCN,
T2.IDSYMBOL IDSYMBOL_BCN,
T2.VALIDFROMDATE VALIDFROMDATE_BCN,
T2.VALIDUNTILDATE VALIDUNTILDATE_BCN,
T2.CREATETIMESTAMP CREATETIMESTAMP_BCN,
T2.UPDATETIMESTAMP UPDATETIMESTAMP_BCN,
T3.SCHEMESYMBOL SCHEMESYMBOL_BCA, T3.IDSYMBOL IDSYMBOL_BCA,
T3.VALIDFROMDATE VALIDFROMDATE_BCA,
T3.VALIDUNTILDATE VALIDUNTILDATE_BCA,
T3.CREATETIMESTAMP CREATETIMESTAMP_BCA,
T3.UPDATETIMESTAMP UPDATETIMESTAMP_BCA,
T4.SCHEMESYMBOL SCHEMESYMBOL_CS, T4.IDSYMBOL IDSYMBOL_CS,
T4.VALIDFROMDATE VALIDFROMDATE_CS,
T4.VALIDUNTILDATE VALIDUNTILDATE_CS,
T4.CREATETIMESTAMP CREATETIMESTAMP_CS,
T4.UPDATETIMESTAMP UPDATETIMESTAMP_CS,
T5.SCHEMESYMBOL SCHEMESYMBOL_MIC, T5.IDSYMBOL IDSYMBOL_MIC,
T5.VALIDFROMDATE VALIDFROMDATE_MIC,
T5.VALIDUNTILDATE VALIDUNTILDATE_MIC,
T5.CREATETIMESTAMP CREATETIMESTAMP_MIC,
T5.UPDATETIMESTAMP UPDATETIMESTAMP_MIC, T1.SHORTNAME_G,
T1.SHORTNAME_E, T1.SHORTNAME_F, T1.SHORTNAME_I,
T1.SHORTNAME_N, T1.NAME_G, T1.NAME_E, T1.NAME_F, T1.NAME_I,
T1.NAME_N
FROM VDPSX.VTINSTITUTION T1
LEFT OUTER JOIN
VDPSX.VTINSTIIDENT T2
ON T2.INSTITUTIONID = T1.INSTITUTIONID AND T2.SCHEMESYMBOL
= 'BCN' AND T2.ROWSTATUS = 1
LEFT OUTER JOIN
VDPSX.VTINSTIIDENT T3
ON T3.INSTITUTIONID = T1.INSTITUTIONID AND T3.SCHEMESYMBOL
= 'BCA' AND T3.ROWSTATUS = 1
LEFT OUTER JOIN
VDPSX.VTINSTIIDENT T4
ON T4.INSTITUTIONID = T1.INSTITUTIONID AND T4.SCHEMESYMBOL
= 'CS-WS80-BPL' AND T4.ROWSTATUS = 1
LEFT OUTER JOIN
VDPSX.VTINSTIIDENT T5
ON T5.INSTITUTIONID = T1.INSTITUTIONID AND T5.SCHEMESYMBOL
= 'MIC' AND T5.ROWSTATUS = 1
WHERE T1.FOTYPE = 104
AND (T1.ROWSTATUS IS NULL
OR T1.ROWSTATUS <> 2) ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.XPS_VROPP000
------------------------------------------------------------------------
--
--
CREATE VIEW VDPSX.XPS_VROPP000 AS
SELECT T1.IDSYMBOL, T1.SCHEMESYMBOL, T3.ROLETYPE,
T4.SCHEMESYMBOL ROLEOBJECTINSTI_SC,
T4.IDSYMBOL ROLEOBJECTINSTI_ID, T1.INSTITUTIONID,
T3.ROLEOBJECTINSTIID, T3.INSTIINSTIROLENO,
T3.CREATETIMESTAMP CREATETIMESTAMP_RP,
T3.UPDATETIMESTAMP UPDATETIMESTAMP_RP, T5.FOTYPE,
T5.DELETEREASONTYPE, T5.DELETIONDATE, T5.ISGLOBALREGACC,
T5.KANTONSCODETYPE, T5.MAINLANGUAGETYPE, T5.STATUSTYPE,
T5.CREATETIMESTAMP CREATETIMESTAMP_IN,
T5.UPDATETIMESTAMP UPDATETIMESTAMP_IN, T5.SHORTNAME_G,
T5.SHORTNAME_E, T5.SHORTNAME_F, T5.SHORTNAME_I,
T5.SHORTNAME_N, T5.NAME_G, T5.NAME_E, T5.NAME_F, T5.NAME_I,
T5.NAME_N
FROM VDPSX.VTINSTIIDENT T1
INNER JOIN
VDPSX.VTINSTITUTION T2
ON T2.INSTITUTIONID = T1.INSTITUTIONID AND T2.ROWSTATUS IS
NULL
INNER JOIN
VDPSX.VTINSTIINSTIROLE T3
ON T3.ROLEPLAYERINSTIID = T2.INSTITUTIONID
INNER JOIN
VDPSX.VTINSTIIDENT T4
ON T4.INSTITUTIONID = T3.ROLEOBJECTINSTIID AND T4.
ROWSTATUS = 1
INNER JOIN
VDPSX.VTINSTITUTION T5
ON T5.INSTITUTIONID = T4.INSTITUTIONID AND T5.ROWSTATUS IS
NULL
WHERE T1.ROWSTATUS = 1 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.XPS_VTRPL001
------------------------------------------------------------------------
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","F616617" ;
--
CREATE VIEW VDPSX.XPS_VTRPL001 AS
SELECT VDPSX.VTINSTRIDENT.IDSYMBOL,
VDPSX.VTINSTIIDENT.IDSYMBOL IDSYMBOL_BCN,
VDPSX.VTTRADINGPLACE.HASELTRONICMATCH
FROM VDPSX.VTINSTRUMENT,
VDPSX.VTINSTRIDENT,
VDPSX.VTINSTIIDENT,
VDPSX.VTLISTING,
VDPSX.VTTRADINGPLACE
WHERE VDPSX.VTINSTRIDENT.SCHEMESYMBOL = 'CH'
AND VDPSX.VTINSTRIDENT.ROWSTATUS = 1
AND VDPSX.VTINSTRIDENT.INSTRUMENTID = VDPSX.VTINSTRUMENT.
INSTRUMENTID
AND (VDPSX.VTINSTRUMENT.ROWSTATUS IS NULL
OR VDPSX.VTINSTRUMENT.ROWSTATUS <> 2)
AND VDPSX.VTLISTING.INSTRUMENTID = VDPSX.VTINSTRUMENT.
INSTRUMENTID
AND VDPSX.VTLISTING.TRADINGPLACE = VDPSX.VTINSTIIDENT.
INSTITUTIONID
AND VDPSX.VTTRADINGPLACE.INSTITUTIONID = VDPSX.VTINSTIIDENT.
INSTITUTIONID
AND VDPSX.VTINSTIIDENT.SCHEMESYMBOL = 'BCN'
AND VDPSX.VTLISTING.LISTINGSTATUSTYPE <> 9
AND VDPSX.VTLISTING.LISTINGSTATUSTYPE <> 18 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.XPS_VTRUS000_V02
------------------------------------------------------------------------
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","F326930" ;
--
CREATE VIEW VDPSX.XPS_VTRUS000_V02 AS
SELECT T1.IDSYMBOL, T1.SCHEMESYMBOL, T1.INSTITUTIONID,
T2.PORTFOLIONO, T2.ACCOUNTINGCURR,
T4.IDSYMBOL ACCOUNTINGCURR_I2,
T5.IDSYMBOL ACCOUNTINGCURR_CS, T2.INITIALMARGINRATE,
T2.TAXNUMBER, T2.NONTAXABLENUMBER, T2.YEARENDDATE,
T2.FOUNDATIONDATE, T2.NEXTSEMESTERREPORT,
T2.NONTAXABLEDATE, T2.LEGALFORMTYPE, T2.TRUSTLEGALGUIDETP,
T2.TRUSTSTATUSTYPE, T2.CREATETIMESTAMP, T2.UPDATETIMESTAMP,
T2.PREVIOUSYEARENDDT
FROM VDPSX.VTINSTIIDENT T1
INNER JOIN
VDPSX.VTINSTITUTION T2
ON T2.INSTITUTIONID = T1.INSTITUTIONID AND (T2.ROWSTATUS
IS NULL OR T2.ROWSTATUS <> 2)
LEFT OUTER JOIN
VDPSX.VTINSTRIDENT T4
ON T4.INSTRUMENTID = T2.ACCOUNTINGCURR AND T4.SCHEMESYMBOL
= 'I2' AND T4.ROWSTATUS = 1
LEFT OUTER JOIN
VDPSX.VTINSTRIDENT T5
ON T5.INSTRUMENTID = T2.ACCOUNTINGCURR AND T5.SCHEMESYMBOL
= 'CS-WS80-WHRG' AND T5.ROWSTATUS = 1
WHERE T1.ROWSTATUS = 1 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- ADB2GEN - End of generated DDL --
------------------------------------------------------------------------
--