zOs/TX/WK920DDT
------------------------------------------------------------------------
-- --
-- Database 2 Administration Tool (DB2 Admin) , program 5697-L90 --
-- --
-- ADB2GEN - Extract object definitions from the DB2 Catalog tables --
-- --
-- Title : TRG VDPS442C 0 --
-- --
-- Input prepared on : DBAF (915) Extract time : 2009-09-04 10:02 --
-- --
-- Catalog values overridden : none
-- --
-- Generate : SG=Y DB=Y TS=Y TB=Y VW=Y IX=Y SY=Y AL=Y LB=Y CM=Y FK=Y --
-- TG=Y UT=Y UF=Y SP=Y SQ=Y RO=Y --
-- Grants : SG=N DB=Y TS=Y TB=Y VW=Y SC=Y UT=Y UF=Y SP=Y SQ=Y --
-- --
------------------------------------------------------------------------
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Table=VDPS2.VTLISTING
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Table=VDPS2.VTLISTING In VV24A1A.VDPS185
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
CREATE TABLE VDPS2.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,
CONSTRAINT INSTRUMENTID
PRIMARY KEY (INSTRUMENTID,
LISTINGNO))
IN VV24A1A.VDPS185
AUDIT NONE
DATA CAPTURE NONE
CCSID EBCDIC
NOT VOLATILE;
--
COMMIT;
--
--
------------------------------------------------------------------------
-- Stogroup=GSMS
------------------------------------------------------------------------
--
SET CURRENT SQLID='A547484';
--
CREATE STOGROUP GSMS
VOLUMES("*")
VCAT DBAF ;
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=VV24A1A
-- Index=VDPS2.VTXLISTING1 On VDPS2.VTLISTING
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
CREATE UNIQUE INDEX VDPS2.VTXLISTING1
ON VDPS2.VTLISTING
(INSTRUMENTID ASC,
LISTINGNO ASC)
USING STOGROUP GSMS
PRIQTY 720 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=VV24A1A
-- Index=VDPS2.VTXLISTING5 On VDPS2.VTLISTING
------------------------------------------------------------------------
--
CREATE INDEX VDPS2.VTXLISTING5
ON VDPS2.VTLISTING
(EXCHANGETYPE ASC)
USING STOGROUP GSMS
PRIQTY -1 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=VDPS2.VTINSTITUTION
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Table=VDPS2.VTINSTITUTION In VV23A1A.VDPS121
------------------------------------------------------------------------
--
CREATE TABLE VDPS2.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,
CONSTRAINT INSTITUTIONID
PRIMARY KEY (INSTITUTIONID))
IN VV23A1A.VDPS121
AUDIT NONE
DATA CAPTURE NONE
CCSID EBCDIC
NOT VOLATILE;
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=VV23A1A
-- Index=VDPS2.VTXINSTITUTION1 On VDPS2.VTINSTITUTION
------------------------------------------------------------------------
--
CREATE UNIQUE INDEX VDPS2.VTXINSTITUTION1
ON VDPS2.VTINSTITUTION
(INSTITUTIONID ASC)
USING STOGROUP GSMS
PRIQTY 720 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=VV23A1A
-- Index=VDPS2.VTXINSTITUTION20 On VDPS2.VTINSTITUTION
------------------------------------------------------------------------
--
CREATE INDEX VDPS2.VTXINSTITUTION20
ON VDPS2.VTINSTITUTION
(INSTITUTIONTYPE ASC)
USING STOGROUP GSMS
PRIQTY 720 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=VV23A1A
-- Index=VDPS2.VTXINSTITUTION5 On VDPS2.VTINSTITUTION
------------------------------------------------------------------------
--
CREATE INDEX VDPS2.VTXINSTITUTION5
ON VDPS2.VTINSTITUTION
(CREATETIMESTAMP ASC)
PADDED
USING STOGROUP GSMS
PRIQTY 720 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=VV23A1A
-- Index=VDPS2.VTXINSTITUTION50 On VDPS2.VTINSTITUTION
------------------------------------------------------------------------
--
CREATE INDEX VDPS2.VTXINSTITUTION50
ON VDPS2.VTINSTITUTION
(STATUSTYPE ASC)
USING STOGROUP GSMS
PRIQTY 720 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=VV23A1A
-- Index=VDPS2.VTXINSTITUTION6 On VDPS2.VTINSTITUTION
------------------------------------------------------------------------
--
CREATE INDEX VDPS2.VTXINSTITUTION6
ON VDPS2.VTINSTITUTION
(UPDATETIMESTAMP ASC)
PADDED
USING STOGROUP GSMS
PRIQTY 720 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=VV23A1A
-- Index=VDPS2.VTXINSTITUTION7 On VDPS2.VTINSTITUTION
------------------------------------------------------------------------
--
CREATE INDEX VDPS2.VTXINSTITUTION7
ON VDPS2.VTINSTITUTION
(FOTYPE ASC)
USING STOGROUP GSMS
PRIQTY 720 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;
--
SET CURRENT SQLID='S107189';
--
CREATE ALIAS S107189.VTINSTITUTION FOR VDPS2.VTINSTITUTION ;
--
COMMIT;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.VTINSTITUTION FOR VDPS2.VTINSTITUTION ;
--
COMMIT;
--
SET CURRENT SQLID='S107189';
--
CREATE ALIAS S107189.VTLISTING FOR VDPS2.VTLISTING ;
--
COMMIT;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.VTLISTING FOR VDPS2.VTLISTING ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.IDS_SMDSTEST
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPSX';
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","F578271" ;
--
CREATE VIEW VDPSX.IDS_SMDSTEST AS
SELECT T1.INSTRUMENTID, T2.CATEGORYVDPS, T2.STATUSTYPE,
T2.ROWSTATUS, T2.UPDATETIMESTAMP, T2.SYMBOLCH,
T2.SYMBOLCSFI, T2.SYMBOLISIN, 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.TRADINGRULETYPE,
T1.TRADINGSTATUSTYPE, T1.TRADINGUNITNO, T1.TRADINGUNITTYPE,
T1.LISTINGSYMBOLRT, T1.LISTINGSYMBOLBB,
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
FROM VDPS2.VTLISTING T1
INNER JOIN
VDPS2.VTINSTRFLATSYMBOLS T2
ON T2.INSTRUMENTID = T1.INSTRUMENTID
INNER JOIN
VDPS2.VTINSTRFLATDATA T3
ON T3.INSTRUMENTID = T2.INSTRUMENTID
LEFT OUTER JOIN
VDPS2.VTLISTINGIDENT T4
ON T4.INSTRUMENTID = T1.INSTRUMENTID AND T4.LISTINGNO = T1.
LISTINGNO AND T4.SCHEMESYMBOL = 'TKM'
LEFT OUTER JOIN
VDPS2.VTLISTINGIDENT T5
ON T5.INSTRUMENTID = T1.INSTRUMENTID AND T5.LISTINGNO = T1.
LISTINGNO AND T5.SCHEMESYMBOL = 'TKL' ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.SMDS_RA15_V01
------------------------------------------------------------------------
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","F273764" ;
--
CREATE VIEW VDPSX.SMDS_RA15_V01 AS
SELECT '15' RECORD_TYPE, T1.SYMBOLCH TKKEY, T1.SYMBOLISIN ISIN,
T6.CURRENCY_I2 CURRENCY_CS,
T6.TRADINGPLACE_BCN EXCHANGE_CODE,
T6.LISTINGSYMBOLTK 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 VDPS2.VTLISTING T6
INNER JOIN
VDPS2.VTINSTRFLATSYMBOLS T1
ON T1.INSTRUMENTID = T6.INSTRUMENTID
INNER JOIN
VDPS2.VTINSTRUMENT T2
ON T2.INSTRUMENTID = T1.INSTRUMENTID AND T2.ROWSTATUS IS
NULL AND T2.ISRELEVANT = 1
INNER JOIN
VDPS2.VTINSTITUTION T5
ON T5.INSTITUTIONID = T6.TRADINGPLACE AND T5.ROWSTATUS IS
NULL
INNER JOIN
VDPS2.VTTRADINGPLACE T8
ON T8.INSTITUTIONID = T6.TRADINGPLACE
WHERE T1.ROWSTATUS = 1
AND T6.LISTINGSTATUSTYPE <> 9
AND T6.LISTINGSTATUSTYPE <> 18 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.SMDS_RA15_V02
------------------------------------------------------------------------
--
--
CREATE VIEW VDPSX.SMDS_RA15_V02 AS
SELECT DISTINCT '15' RECORD_TYPE, T1.SYMBOLCH TKKEY,
T1.SYMBOLISIN ISIN, T6.CURRENCY_I2 CURRENCY_CS,
T6.TRADINGPLACE_BCN EXCHANGE_CODE,
T6.LISTINGSYMBOLTK TICKER, T5.SHORTNAME_G SHORTNAME_G,
T5.SHORTNAME_E SHORTNAME_E, T5.SHORTNAME_I SHORTNAME_I,
T5.SHORTNAME_F SHORTNAME_F, T5.SHORTNAME_N SHORTNAME_N,
T6.CURRENCY LISTING_CURRENCY, T6.SHORTNAME_G LISTINGNAME_G,
T6.SHORTNAME_E LISTINGNAME_E, T6.SHORTNAME_I LISTINGNAME_I,
T6.SHORTNAME_F LISTINGNAME_F, T6.SHORTNAME_N 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 VDPS2.VTLISTING T6
INNER JOIN
VDPS2.VTINSTRFLATSYMBOLS T1
ON T1.INSTRUMENTID = T6.INSTRUMENTID
INNER JOIN
VDPS2.VTINSTRUMENT T2
ON T2.INSTRUMENTID = T1.INSTRUMENTID AND T2.ROWSTATUS IS
NULL AND T2.ISRELEVANT = 1
INNER JOIN
VDPS2.VTINSTITUTION T5
ON T5.INSTITUTIONID = T6.TRADINGPLACE AND T5.ROWSTATUS IS
NULL
INNER JOIN
VDPS2.VTTRADINGPLACE T8
ON T8.INSTITUTIONID = T6.TRADINGPLACE
WHERE T1.ROWSTATUS = 1
AND T6.LISTINGSTATUSTYPE NOT IN(9, 18) ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPSX.XPS_VLIID002_V05
------------------------------------------------------------------------
--
--
CREATE VIEW VDPSX.XPS_VLIID002_V05 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 VDPS.VTINSTRIDENT T1
INNER JOIN
VDPS.VTINSTRUMENT T2
ON T2.INSTRUMENTID = T1.INSTRUMENTID AND (T2.ROWSTATUS IS
NULL OR T2.ROWSTATUS <> 2)
INNER JOIN
VDPS.VTLISTING T3
ON T3.INSTRUMENTID = T1.INSTRUMENTID
INNER JOIN
VDPS.VTINSTIIDENT T4
ON T4.INSTITUTIONID = T3.TRADINGPLACE AND T4.SCHEMESYMBOL
= 'BCN' AND T4.ROWSTATUS = 1
INNER JOIN
VDPS.VTINSTITUTION T5
ON T5.INSTITUTIONID = T3.TRADINGPLACE AND (T5.ROWSTATUS IS
NULL OR T5.ROWSTATUS <> 2)
LEFT OUTER JOIN
VDPS.VTLISTINGIDENT T6
ON T6.INSTRUMENTID = T3.INSTRUMENTID AND T6.LISTINGNO = T3.
LISTINGNO AND T6.SCHEMESYMBOL IN('TKH', 'RIC', 'BBI')
LEFT OUTER JOIN
VDPS.CTLISTING T7
ON T7.INSTRUMENTID = T3.INSTRUMENTID AND T7.LISTINGNO = T3.
LISTINGNO AND T7.MANDATOR = 1
LEFT OUTER JOIN
VDPS.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_VNTP002
------------------------------------------------------------------------
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","F589435" ;
--
CREATE VIEW VDPSX.XPS_VNTP002 AS SELECT CAST(FS.SYMBOLCH AS CHAR( 9))
VALOR, CAST(';' AS CHAR( 1)) DL01 , CAST(CASE WHEN FS.SYMBOLISIN IS NOT
NULL THEN FS.SYMBOLISIN ELSE '?' END AS CHAR ( 12)) ISIN, CAST(';' AS C
HAR( 1)) DL02, CAST(CASE WHEN Z.MAINLANGUAGETYPE = 1 THEN Z.NAME_G WHE
N Z.MAINLANGUAGETYPE = 2 THEN Z.NAME_F WHEN Z.MAINLANGUAGETYPE = 3 THEN
Z.NAME_I WHEN Z.MAINLANGUAGETYPE = 4 THEN Z.NAME_E WHEN Z.MAINLANGUAG
ETYPE = 5 THEN Z.NAME_N WHEN Z.MAINLANGUAGETYPE = 9999 THEN '?' ELSE '?
' END AS CHAR( 254)) ISSUER_NAME, CAST(';' AS CHAR( 1)) DL03, CAST(CASE
WHEN A.MAINLANGUAGETYPE = 1 THEN FD.PREPARTICLE_G WHEN A.MAINLANGUAGE
TYPE = 2 THEN FD.PREPARTICLE_F WHEN A.MAINLANGUAGETYPE = 3 THEN FD.PREP
ARTICLE_I WHEN A.MAINLANGUAGETYPE = 4 THEN FD.PREPARTICLE_E WHEN A.MAI
NLANGUAGETYPE = 5 THEN FD.PREPARTICLE_N WHEN A.MAINLANGUAGETYPE = 9999
THEN '?' ELSE '?' END AS CHAR( 254)) INSTR_PREPART, CAST(';' AS CHAR( 1
)) DL04, CAST(CASE WHEN A.MAINLANGUAGETYPE = 1 THEN FD.POSTPARTICLE_G
WHEN FD.POSTPARTICLE_G IS NULL THEN '?' WHEN A.MAINLANGUAGETYPE = 2 THE
N FD.POSTPARTICLE_F WHEN FD.POSTPARTICLE_F IS NULL THEN '?' WHEN A.MAI
NLANGUAGETYPE = 3 THEN FD.POSTPARTICLE_I WHEN FD.POSTPARTICLE_I IS NULL
THEN '?' WHEN A.MAINLANGUAGETYPE = 4 THEN FD.POSTPARTICLE_E WHEN FD.P
OSTPARTICLE_E IS NULL THEN '?' WHEN A.MAINLANGUAGETYPE = 5 THEN FD.POST
PARTICLE_N WHEN FD.POSTPARTICLE_N IS NULL THEN '?' WHEN A.MAINLANGUAGE
TYPE = 9999 THEN '?' ELSE '?' END AS CHAR( 254)) INSTR_POSTPART, CAST('
;' AS CHAR( 1)) DL05, CAST(CASE WHEN A.MAINLANGUAGETYPE IS NOT NULL THE
N CAST(A.MAINLANGUAGETYPE AS CHAR( 04)) ELSE '?' END AS CHAR( 4)) MAINL
ANGUAGETYPE, CAST(';' AS CHAR ( 1)) DL06, CAST(CASE WHEN FD.CSSTATUSTYP
E IS NOT NULL THEN CAST(FD.CSSTATUSTYPE AS CHAR( 04) ) ELSE '?' END AS C
HAR( 4)) CSSTATUSTYPE, CAST(';' AS CHAR( 1)) DL07, CAST(CASE WHEN FD.S
TATUSTYPE IS NOT NULL THEN CAST(FD.STATUSTYPE AS CHAR( 04)) ELSE '?' EN
D AS CHAR( 4)) TKSTATUSTYPE, CAST(';' AS CHAR( 1)) DL08, CAST(CASE WHE
N FD.ISINTERNAL = 1 THEN FD.ISINTERNAL ELSE 0 END AS CHAR( 1)) CSGIV , C
AST(';' AS CHAR( 1)) DL09, CAST(CASE WHEN FS.CATEGORYCSGMS IS NOT NULL
THEN CAST(FS.CATEGORYCSGMS AS CHAR( 30)) ELSE '?' END AS CHAR( 30)) CSG
MS, CAST(';' AS CHAR( 1)) DL10, CAST (CASE WHEN FD.CSFUNDTYPE IS NOT NU
LL THEN CAST(FD.CSFUNDTYPE AS CHAR( 4)) ELSE '?' END AS CHAR( 4)) CSFUN
DTYPE, CAST(';' AS CHAR( 1)) DL11, CAST( CASE WHEN FD.CREDITWORTHINESST
P IS NOT NULL THEN CAST(FD.CREDITWORTHINESSTP AS CHAR( 4)) ELSE '?' END
AS CHAR( 4)) BONITAETSCODE, CAST(';' AS CHAR ( 1)) DL12, CAST('1' AS CH
AR( 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 NULL THEN H.NAME_F WHEN H.NAME_I IS NOT NULL THEN H.NA
ME_I WHEN H.NAME_N IS NOT NULL THEN H.NAME_N ELSE '?' END AS CHAR( 254)
) MAINDEPOS_NAME, CAST(';' AS CHAR( 1)) DL14, CAST(CASE WHEN Z.YEAREND
DATE IS NOT NULL THEN CAST(Z.YEARENDDATE AS CHAR( 30)) ELSE '?' END AS
CHAR( 30)) YEARENDDATE, CAST(';' AS CHAR( 1)) DL15, CAST(CASE WHEN L.I
NVENTORYFREQUENCY IS NOT NULL THEN CAST(L.INVENTORYFREQUENCY AS CHAR( 1
0)) ELSE '?' END AS CHAR( 10)) INVENTORYFREQUENCY, CAST(';' AS CHAR( 1)
) DL16, CAST(CASE WHEN L.INVENTORYFRUNITTP IS NOT NULL THEN CAST(L.INVE
NTORYFRUNITTP AS CHAR( 4)) ELSE '?' END AS CHAR( 4)) INVENTORYFRUNITTP,
CAST(';' AS CHAR ( 1)) DL17, CAST(CASE WHEN L.NAVPUBLICATDESCR IS NOT
NULL THEN CAST(L.NAVPUBLICATDESCR AS CHAR( 254)) ELSE '?' END AS CHAR(
254)) NAVPUBLICATDESCR, CAST(';' AS CHAR( 1)) DL18, CAST(CASE WHEN M.T
RADINGPLACE_BCN IS NOT NULL THEN CAST(M.TRADINGPLACE_BCN AS CHAR( 30))
ELSE '?' END AS CHAR( 30)) BCN, CAST(';' AS CHAR( 1)) DL19, CAST(CASE
WHEN M.CURRENCY_I2 IS NOT NULL THEN CAST(M.CURRENCY_I2 AS CHAR( 30)) EL
SE '?' END AS CHAR( 30)) IDSYMBOL_I2, CAST(';' AS CHAR( 1)) DL20, CAST(
CASE WHEN P.ISSTEERINGFLAG4 = 1 THEN '1' WHEN P.ISSTEERINGFLAG4 = 0 TH
EN '0' WHEN P.ISSTEERINGFLAG4 IS NULL THEN '?' ELSE '?' END AS CHAR( 1)
) ISSTEERINGFLAG4, CAST(';' AS CHAR( 1)) DL21, FD.INSTRUMENTID, CAST(';
' AS CHAR( 1)) DL22 FROM VDPS2.VTINSTRFLATDATA FD INNER JOIN VDPS2. VTI
NSTRUMENT A ON FD.INSTRUMENTID = 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.C
SSTATUSTYPE IN(4, 6, 7) INNER JOIN VDPS2.VTINSTITUTION Z ON FD. ISSUER =
Z.INSTITUTIONID INNER JOIN VDPS2.VTINSTITUTION H ON FD. MAINDEPOSITARY
= H.INSTITUTIONID INNER JOIN VDPS2.VTINSTRFLATSYMBOLS FS ON FD.INSTRUME
NTID = FS.INSTRUMENTID AND FS.ROWSTATUS = 1 INNER JOIN VDPS2.CTINSTRB42
STOCK I ON I.INSTRUMENTID = FD.INSTRUMENTID AND I. HOLDINGSTOTAL = 99999
9 AND I.MANDATOR = 1 INNER JOIN VDPS2.VTLISTING M ON M.INSTRUMENTID = F
D.INSTRUMENTID AND M.LISTINGSTATUSTYPE <> 9 AND M. LISTINGSTATUSTYPE <>
18 LEFT OUTER JOIN VDPS2.CTLISTING P ON P. INSTRUMENTID = M.INSTRUMENTID
AND M.LISTINGNO = P.LISTINGNO AND P. MANDATOR = 1 LEFT OUTER JOIN VDPS2
.VTTRUSTDETAIL L ON L.INSTRUMENTID = FD.INSTRUMENTID ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPS2.IDS_SMDSA101
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","OA1A" ;
--
CREATE VIEW VDPS2.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 VDPS2.VTINSTRFLATSYMBOLS T1
INNER JOIN
VDPS2.VTINSTRFLATDATA T2
ON T2.INSTRUMENTID = T1.INSTRUMENTID
LEFT OUTER JOIN
VDPS2.VTLISTING T3
ON T3.INSTRUMENTID = T1.INSTRUMENTID AND T3.
ISMAINTRADINGPLACE = 1
LEFT OUTER JOIN
VDPS2.CTCODESET T4
ON T4.INSTRUMENTID = T1.INSTRUMENTID AND T4.CODETYPE = 7
LEFT OUTER JOIN
VDPS2.VTINSTRINGROUP T5
ON T5.INSTRUMENTID = T1.INSTRUMENTID AND T5.SCHEMESYMBOL =
'CSGIV' ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.IDS_SMDSA101 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_SMDSA101 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_SMDSA101 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_SMDSA101 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_SMDSA101 TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.IDS_SMDSA101 FOR VDPS2.IDS_SMDSA101 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPS2.IDS_SMDSA104
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
CREATE VIEW VDPS2.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 VDPS2.VTINSTITUTION T1
INNER JOIN
VDPS2.VTINSTIIDENT T2
ON T2.INSTITUTIONID = T1.INSTITUTIONID AND T2.SCHEMESYMBOL
= 'GK'
LEFT OUTER JOIN
VDPS2.VTINSTIIDENT T3
ON T3.INSTITUTIONID = T1.INSTITUTIONID AND T3.SCHEMESYMBOL
= 'UIC'
LEFT OUTER JOIN
VDPS2.VTINSTIIDENT T4
ON T4.INSTITUTIONID = T1.INSTITUTIONID AND T4.SCHEMESYMBOL
= 'UKCN'
LEFT OUTER JOIN
VDPS2.VTINSTIIDENT T5
ON T5.INSTITUTIONID = T1.INSTITUTIONID AND T5.SCHEMESYMBOL
= 'OENB'
LEFT OUTER JOIN
VDPS2.VTINSTIIDENT T6
ON T6.INSTITUTIONID = T1.INSTITUTIONID AND T6.SCHEMESYMBOL
= 'CVR'
LEFT OUTER JOIN
VDPS2.VTINSTIIDENT T7
ON T7.INSTITUTIONID = T1.INSTITUTIONID AND T7.SCHEMESYMBOL
= 'TVABE'
LEFT OUTER JOIN
VDPS2.VTINSTIIDENT T8
ON T8.INSTITUTIONID = T1.INSTITUTIONID AND T8.SCHEMESYMBOL
= 'RCS'
LEFT OUTER JOIN
VDPS2.VTINSTIIDENT T9
ON T9.INSTITUTIONID = T1.INSTITUTIONID AND T9.SCHEMESYMBOL
= 'DUNS'
LEFT OUTER JOIN
VDPS2.VTGEOUNITIDENT T10
ON T10.GEOUNITID = T1.DOMICILE AND T10.SCHEMESYMBOL =
'ISON'
LEFT OUTER JOIN
VDPS2.VTGEOUNITIDENT T11
ON T11.GEOUNITID = T1.DOMICILE AND T11.SCHEMESYMBOL = 'TKN'
LEFT OUTER JOIN
VDPS2.VTGEOUNITIDENT T12
ON T12.GEOUNITID = T1.DOMICILE AND T12.SCHEMESYMBOL = 'TKR' ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.IDS_SMDSA104 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_SMDSA104 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_SMDSA104 TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.IDS_SMDSA104 FOR VDPS2.IDS_SMDSA104 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPS2.IDS_SMDSA106
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
CREATE VIEW VDPS2.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 VDPS2.VTINSTIFLATSYMBOLS T1
INNER JOIN
VDPS2.VTINSTITUTION T2
ON T2.INSTITUTIONID = T1.INSTITUTIONID ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.IDS_SMDSA106 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_SMDSA106 TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.IDS_SMDSA106 FOR VDPS2.IDS_SMDSA106 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPS2.IDS_SMDSA107
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
CREATE VIEW VDPS2.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 VDPS2.VTINSTIFLATSYMBOLS T1
INNER JOIN
VDPS2.VTINSTITUTION T2
ON T2.INSTITUTIONID = T1.INSTITUTIONID ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.IDS_SMDSA107 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_SMDSA107 TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.IDS_SMDSA107 FOR VDPS2.IDS_SMDSA107 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPS2.IDS_SMDSA112
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
CREATE VIEW VDPS2.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 VDPS2.VTINSTIFLATSYMBOLS T1
INNER JOIN
(SELECT TA.INSTITUTIONID, TA.IDSYMBOL, TA.SCHEMESYMBOL,
TA.RATINGDATE, TA.WATCHLISTSTATTYPE,
TA.RATINGSTATUSTYPE, TA.REVIEWDATE, TA.SOURCETYPE,
TA.UNIQUENUMBER
FROM VDPS2.VTINSTIRATING TA
WHERE TA.SCHEMESYMBOL = 'CSIB'
AND TA.RATINGDATE = (
SELECT MAX(TC.RATINGDATE)
FROM VDPS2.VTINSTIRATING TC
WHERE TC.INSTITUTIONID = TA.INSTITUTIONID
AND TC.SCHEMESYMBOL = 'CSIB')) T2
ON T2.INSTITUTIONID = T1.INSTITUTIONID
INNER JOIN
VDPS2.VTINSTITUTION T3
ON T3.INSTITUTIONID = T1.INSTITUTIONID ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.IDS_SMDSA112 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_SMDSA112 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_SMDSA112 TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.IDS_SMDSA112 FOR VDPS2.IDS_SMDSA112 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPS2.IDS_SMDSA114
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
CREATE VIEW VDPS2.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 VDPS2.VTINSTIFLATSYMBOLS T1
INNER JOIN
(SELECT TA.INSTITUTIONID, TA.IDSYMBOL, TA.SCHEMESYMBOL,
TA.RATINGDATE, TA.WATCHLISTSTATTYPE,
TA.RATINGSTATUSTYPE, TA.REVIEWDATE, TA.SOURCETYPE,
TA.UNIQUENUMBER
FROM VDPS2.VTINSTIRATING TA
WHERE TA.SCHEMESYMBOL IN(
SELECT DISTINCT TB.SCHEMESYMBOL
FROM VDPS2.VTINSTIRATING TB
WHERE TA.INSTITUTIONID = TB.INSTITUTIONID)
AND TA.RATINGDATE = (
SELECT MAX(TC.RATINGDATE)
FROM VDPS2.VTINSTIRATING TC
WHERE TC.INSTITUTIONID = TA.INSTITUTIONID
AND TC.SCHEMESYMBOL = TA.SCHEMESYMBOL
GROUP BY TC.SCHEMESYMBOL)) T2
ON T2.INSTITUTIONID = T1.INSTITUTIONID
INNER JOIN
VDPS2.VTRATINGSCHEME T3
ON T3.SCHEMESYMBOL = T2.SCHEMESYMBOL AND T3.INSTITUTIONID
= 10052339
INNER JOIN
VDPS2.VTINSTITUTION T4
ON T4.INSTITUTIONID = T1.INSTITUTIONID ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.IDS_SMDSA114 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_SMDSA114 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_SMDSA114 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_SMDSA114 TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.IDS_SMDSA114 FOR VDPS2.IDS_SMDSA114 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPS2.IDS_SMDSA116
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
CREATE VIEW VDPS2.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 VDPS2.VTINSTIFLATSYMBOLS T1
INNER JOIN
(SELECT TA.INSTITUTIONID, TA.IDSYMBOL, TA.SCHEMESYMBOL,
TA.RATINGDATE, TA.WATCHLISTSTATTYPE,
TA.RATINGSTATUSTYPE, TA.REVIEWDATE, TA.SOURCETYPE,
TA.UNIQUENUMBER
FROM VDPS2.VTINSTIRATING TA
WHERE TA.SCHEMESYMBOL IN(
SELECT DISTINCT TB.SCHEMESYMBOL
FROM VDPS2.VTINSTIRATING TB
WHERE TA.INSTITUTIONID = TB.INSTITUTIONID)
AND TA.RATINGDATE = (
SELECT MAX(TC.RATINGDATE)
FROM VDPS2.VTINSTIRATING TC
WHERE TC.INSTITUTIONID = TA.INSTITUTIONID
AND TC.SCHEMESYMBOL = TA.SCHEMESYMBOL
GROUP BY TC.SCHEMESYMBOL)) T2
ON T2.INSTITUTIONID = T1.INSTITUTIONID
INNER JOIN
VDPS2.VTRATINGSCHEME T3
ON T3.SCHEMESYMBOL = T2.SCHEMESYMBOL AND T3.INSTITUTIONID
= 10052338
INNER JOIN
VDPS2.VTINSTITUTION T4
ON T4.INSTITUTIONID = T1.INSTITUTIONID ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.IDS_SMDSA116 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_SMDSA116 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_SMDSA116 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_SMDSA116 TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.IDS_SMDSA116 FOR VDPS2.IDS_SMDSA116 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPS2.IDS_SMDS1501
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
CREATE VIEW VDPS2.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 VDPS2.VTLISTING T1
INNER JOIN
VDPS2.VTINSTRFLATSYMBOLS T2
ON T2.INSTRUMENTID = T1.INSTRUMENTID
INNER JOIN
VDPS2.VTINSTRFLATDATA T3
ON T3.INSTRUMENTID = T2.INSTRUMENTID
LEFT OUTER JOIN
VDPS2.VTLISTINGIDENT T4
ON T4.INSTRUMENTID = T1.INSTRUMENTID AND T4.LISTINGNO = T1.
LISTINGNO AND T4.SCHEMESYMBOL = 'TKM'
LEFT OUTER JOIN
VDPS2.VTLISTINGIDENT T5
ON T5.INSTRUMENTID = T1.INSTRUMENTID AND T5.LISTINGNO = T1.
LISTINGNO AND T5.SCHEMESYMBOL = 'TKL'
LEFT OUTER JOIN
VDPS2.VTLISTINGIDENT T6
ON T6.INSTRUMENTID = T1.INSTRUMENTID AND T6.LISTINGNO = T1.
LISTINGNO AND T6.SCHEMESYMBOL = 'TKE' ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.IDS_SMDS1501 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_SMDS1501 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_SMDS1501 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_SMDS1501 TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.IDS_SMDS1501 FOR VDPS2.IDS_SMDS1501 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPS2.IDS_VCLDP148_V02
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
CREATE VIEW VDPS2.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 VDPS2.VTINSTRFLATSYMBOLS A
INNER JOIN
VDPS2.VTINSTIROLE B
ON B.INSTRUMENTID = A.INSTRUMENTID AND B.ROLETYPE = 6
INNER JOIN
VDPS2.VTCLEARINGCUSTODY C
ON C.INSTRUMENTID = B.INSTRUMENTID
INNER JOIN
VDPS2.VTINSTITUTION D
ON D.INSTITUTIONID = B.INSTITUTIONID ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.IDS_VCLDP148_V02 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_VCLDP148_V02 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_VCLDP148_V02 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_VCLDP148_V02 TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.IDS_VCLDP148_V02 FOR VDPS2.IDS_VCLDP148_V02 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPS2.IDS_VGNTY113
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
CREATE VIEW VDPS2.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 VDPS2.VTINSTRFLATSYMBOLS A
INNER JOIN
VDPS2.VTINSTIROLE B
ON B.INSTRUMENTID = A.INSTRUMENTID AND B.ROLETYPE = 2
INNER JOIN
VDPS2.VTGUARANTY C
ON C.INSTRUMENTID = B.INSTRUMENTID AND C.INSTIROLENO = B.
INSTIROLENO
INNER JOIN
VDPS2.VTINSTITUTION D
ON D.INSTITUTIONID = B.INSTITUTIONID ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.IDS_VGNTY113 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_VGNTY113 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_VGNTY113 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_VGNTY113 TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.IDS_VGNTY113 FOR VDPS2.IDS_VGNTY113 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPS2.IDS_VINIR133_V02
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
CREATE VIEW VDPS2.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 VDPS2.VTINSTIROLE T1
INNER JOIN
VDPS2.VTINSTIFLATSYMBOLS T2
ON T2.INSTITUTIONID = T1.INSTITUTIONID
INNER JOIN
VDPS2.VTINSTITUTION T3
ON T3.INSTITUTIONID = T2.INSTITUTIONID ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.IDS_VINIR133_V02 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_VINIR133_V02 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_VINIR133_V02 TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.IDS_VINIR133_V02 FOR VDPS2.IDS_VINIR133_V02 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPS2.IDS_VINOP131
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
CREATE VIEW VDPS2.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 VDPS2.VTINSTRFLATSYMBOLS T1
INNER JOIN
VDPS2.VTINSTRFLATDATA T2
ON T2.INSTRUMENTID = T1.INSTRUMENTID
INNER JOIN
VDPS2.VTINSTITUTION T3
ON T3.INSTITUTIONID = T2.ORIGINALISSUER
INNER JOIN
VDPS2.VTINSTITUTION T4
ON T4.INSTITUTIONID = T2.ISSUER ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.IDS_VINOP131 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_VINOP131 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_VINOP131 TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.IDS_VINOP131 FOR VDPS2.IDS_VINOP131 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPS2.IDS_VINOP140
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
CREATE VIEW VDPS2.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 VDPS2.VTINSTRFLATSYMBOLS T1
INNER JOIN
VDPS2.VTINSTRFLATDATA T2
ON T2.INSTRUMENTID = T1.INSTRUMENTID
INNER JOIN
VDPS2.VTINSTIFLATSYMBOLS T3
ON T3.INSTITUTIONID = T2.ORIGINALISSUER
INNER JOIN
VDPS2.VTINSTITUTION T4
ON T4.INSTITUTIONID = T2.ORIGINALISSUER
INNER JOIN
VDPS2.VTINSTRUMENT T9
ON T9.INSTRUMENTID = T1.INSTRUMENTID
INNER JOIN
VDPS2.VTINSTIFLATSYMBOLS T5
ON T5.INSTITUTIONID = T2.ISSUER
INNER JOIN
VDPS2.VTINSTITUTION T6
ON T6.INSTITUTIONID = T2.ISSUER
LEFT OUTER JOIN
VDPS2.CTINSTRDETAILS T7
ON T7.INSTRUMENTID = T1.INSTRUMENTID
LEFT OUTER JOIN
VDPS2.CTINSTRSP42DETAILS T8
ON T8.INSTRUMENTID = T1.INSTRUMENTID ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.IDS_VINOP140 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_VINOP140 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_VINOP140 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_VINOP140 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_VINOP140 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_VINOP140 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_VINOP140 TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.IDS_VINOP140 FOR VDPS2.IDS_VINOP140 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPS2.IDS_VINOP140_V02
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
CREATE VIEW VDPS2.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 VDPS2.VTINSTRFLATSYMBOLS T1
INNER JOIN
VDPS2.VTINSTRFLATDATA T2
ON T2.INSTRUMENTID = T1.INSTRUMENTID
INNER JOIN
VDPS2.VTINSTIFLATSYMBOLS T3
ON T3.INSTITUTIONID = T2.ORIGINALISSUER
INNER JOIN
VDPS2.VTINSTITUTION T4
ON T4.INSTITUTIONID = T2.ORIGINALISSUER
INNER JOIN
VDPS2.VTINSTRUMENT T9
ON T9.INSTRUMENTID = T1.INSTRUMENTID
INNER JOIN
VDPS2.VTINSTIFLATSYMBOLS T5
ON T5.INSTITUTIONID = T2.ISSUER
INNER JOIN
VDPS2.VTINSTITUTION T6
ON T6.INSTITUTIONID = T2.ISSUER
LEFT OUTER JOIN
VDPS2.CTINSTRDETAILS T7
ON T7.INSTRUMENTID = T1.INSTRUMENTID
LEFT OUTER JOIN
VDPS2.CTINSTRSP42DETAILS T8
ON T8.INSTRUMENTID = T1.INSTRUMENTID ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.IDS_VINOP140_V02 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_VINOP140_V02 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_VINOP140_V02 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_VINOP140_V02 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_VINOP140_V02 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_VINOP140_V02 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_VINOP140_V02 TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.IDS_VINOP140_V02 FOR VDPS2.IDS_VINOP140_V02 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPS2.IDS_VINOP140_V03
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
CREATE VIEW VDPS2.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.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,
T9.NOMINALCURR, T9.COMPOUNDTYPE, T9.PORTFOLIONO,
T9.ISINSTANCE, T9.CAPMARKETLOCATION, T9.STATUSDATE,
T9.DELIVERYTYPE, 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 VDPS2.VTINSTRFLATSYMBOLS T1
INNER JOIN
VDPS2.VTINSTRFLATDATA T2
ON T2.INSTRUMENTID = T1.INSTRUMENTID
INNER JOIN
VDPS2.VTINSTIFLATSYMBOLS T3
ON T3.INSTITUTIONID = T2.ORIGINALISSUER
INNER JOIN
VDPS2.VTINSTITUTION T4
ON T4.INSTITUTIONID = T2.ORIGINALISSUER
INNER JOIN
VDPS2.VTINSTRUMENT T9
ON T9.INSTRUMENTID = T1.INSTRUMENTID
INNER JOIN
VDPS2.VTINSTIFLATSYMBOLS T5
ON T5.INSTITUTIONID = T2.ISSUER
INNER JOIN
VDPS2.VTINSTITUTION T6
ON T6.INSTITUTIONID = T2.ISSUER
LEFT OUTER JOIN
VDPS2.CTINSTRDETAILS T7
ON T7.INSTRUMENTID = T1.INSTRUMENTID
LEFT OUTER JOIN
VDPS2.CTINSTRSP42DETAILS T8
ON T8.INSTRUMENTID = T1.INSTRUMENTID ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.IDS_VINOP140_V03 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_VINOP140_V03 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_VINOP140_V03 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_VINOP140_V03 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_VINOP140_V03 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_VINOP140_V03 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_VINOP140_V03 TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.IDS_VINOP140_V03 FOR VDPS2.IDS_VINOP140_V03 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPS2.IDS_VINSS105
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
CREATE VIEW VDPS2.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 VDPS2.VTINSTRFLATDATA T1
LEFT OUTER JOIN
VDPS2.VTINSTRFLATDATA T2
ON T2.INSTRUMENTID = T1.UNDERINSTRUMENT
INNER JOIN
VDPS2.VTINSTITUTION T3
ON T3.INSTITUTIONID = T2.ISSUER ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.IDS_VINSS105 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_VINSS105 TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.IDS_VINSS105 FOR VDPS2.IDS_VINSS105 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPS2.IDS_VISCD103
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","S100447" ;
--
CREATE VIEW VDPS2.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 VDPS2.VTINSTRFLATDATA T1
INNER JOIN
VDPS2.VTINSTITUTION T2
ON T2.INSTITUTIONID = T1.ORIGINALISSUER
INNER JOIN
VDPS2.VTINSTITUTION T3
ON T3.INSTITUTIONID = T1.ISSUER ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.IDS_VISCD103 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_VISCD103 TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.IDS_VISCD103 FOR VDPS2.IDS_VISCD103 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPS2.IDS_VITBD112
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
CREATE VIEW VDPS2.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 VDPS2.VTINSTITUTION T1
INNER JOIN
VDPS2.VTINSTIFLATSYMBOLS T2
ON T1.INSTITUTIONID = T2.INSTITUTIONID ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.IDS_VITBD112 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_VITBD112 TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.IDS_VITBD112 FOR VDPS2.IDS_VITBD112 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPS2.IDS_VITCR118_V02
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","OA1A" ;
--
CREATE VIEW VDPS2.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 VDPS2.VTINSTRFLATSYMBOLS T1
INNER JOIN
VDPS2.VTINSTIROLE T2
ON T2.INSTRUMENTID = T1.INSTRUMENTID
INNER JOIN
VDPS2.VTINSTIRATING T3
ON T3.INSTITUTIONID = T2.INSTITUTIONID
INNER JOIN
VDPS2.VTRATINGSYMBOL T4
ON T4.RATINGSYMBOLID = T3.INSTIRATINGNO
INNER JOIN
VDPS2.VTRATINGSCHEME T5
ON T5.SCHEMESYMBOL = T3.SCHEMESYMBOL
INNER JOIN
VDPS2.VTINSTIIDENT T6
ON T6.INSTITUTIONID = T5.INSTITUTIONID
INNER JOIN
VDPS2.VTINSTIIDENT T7
ON T7.INSTITUTIONID = T2.INSTITUTIONID
INNER JOIN
VDPS2.VTINSTITUTION T8
ON T8.INSTITUTIONID = T2.INSTITUTIONID ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.IDS_VITCR118_V02 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_VITCR118_V02 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_VITCR118_V02 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_VITCR118_V02 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_VITCR118_V02 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_VITCR118_V02 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_VITCR118_V02 TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.IDS_VITCR118_V02 FOR VDPS2.IDS_VITCR118_V02 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPS2.IDS_VLSTG111
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
CREATE VIEW VDPS2.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 VDPS2.VTLISTING T1
INNER JOIN
VDPS2.VTINSTRFLATSYMBOLS T2
ON T1.INSTRUMENTID = T2.INSTRUMENTID
INNER JOIN
VDPS2.VTINSTITUTION T3
ON T3.INSTITUTIONID = T1.TRADINGPLACE ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.IDS_VLSTG111 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_VLSTG111 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_VLSTG111 TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.IDS_VLSTG111 FOR VDPS2.IDS_VLSTG111 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPS2.IDS_VLSTG111_V02
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","OA1P" ;
--
CREATE VIEW VDPS2.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.TRADINGUNITNO,
T1.TRADINGUNITTYPE TRADINGUNITTYPE_LISTING,
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,
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 VDPS2.VTLISTING T1
INNER JOIN
VDPS2.CTLISTING T2
ON T2.INSTRUMENTID = T1.INSTRUMENTID AND T2.LISTINGNO = T1.
LISTINGNO
INNER JOIN
VDPS2.VTINSTRFLATSYMBOLS T3
ON T3.INSTRUMENTID = T1.INSTRUMENTID
INNER JOIN
VDPS2.VTINSTITUTION T4
ON T4.INSTITUTIONID = T1.TRADINGPLACE ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.IDS_VLSTG111_V02 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_VLSTG111_V02 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_VLSTG111_V02 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_VLSTG111_V02 TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.IDS_VLSTG111_V02 FOR VDPS2.IDS_VLSTG111_V02 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPS2.IDS_VTOFF110
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","OA1A" ;
--
CREATE VIEW VDPS2.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 VDPS2.VTTOFF T1
INNER JOIN
VDPS2.VTINSTRFLATDATA T2
ON T2.INSTRUMENTID = T1.FINALUNDERINSTR
INNER JOIN
VDPS2.VTINSTITUTION T3
ON T3.INSTITUTIONID = T2.ISSUER
INNER JOIN
VDPS2.VTINSTRFLATDATA T4
ON T4.INSTRUMENTID = T1.INSTRUMENTID
INNER JOIN
VDPS2.VTINSTRFLATSYMBOLS T5
ON T5.INSTRUMENTID = T1.INSTRUMENTID
INNER JOIN
VDPS2.VTINSTRFLATDATA T6
ON T6.INSTRUMENTID = T1.UNDERINSTRUMENT
INNER JOIN
VDPS2.VTINSTITUTION T7
ON T7.INSTITUTIONID = T6.ISSUER ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.IDS_VTOFF110 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_VTOFF110 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_VTOFF110 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_VTOFF110 TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.IDS_VTOFF110 FOR VDPS2.IDS_VTOFF110 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPS2.SMDS_RA08_V03
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
CREATE VIEW VDPS2.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 VDPS2.VTINSTIIDENT T1
INNER JOIN
VDPS2.VTINSTIROLE T2
ON T2.INSTITUTIONID = T1.INSTITUTIONID AND T2.ROLETYPE IN(1
, 25)
INNER JOIN
VDPS2.VTINSTITUTION T3
ON T3.INSTITUTIONID = T1.INSTITUTIONID AND (T3.ROWSTATUS
IS NULL OR T3.ROWSTATUS <> 2)
WHERE T1.SCHEMESYMBOL = 'GK'
AND T1.ROWSTATUS = 1 ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.SMDS_RA08_V03 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.SMDS_RA08_V03 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.SMDS_RA08_V03 TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.SMDS_RA08_V03 FOR VDPS2.SMDS_RA08_V03 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPS2.SMDS_RA15
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
CREATE VIEW VDPS2.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 VDPS2.VTLISTING T6
INNER JOIN
VDPS2.VTINSTRIDENT T1
ON T1.INSTRUMENTID = T6.INSTRUMENTID
INNER JOIN
VDPS2.VTINSTRUMENT T2
ON T2.INSTRUMENTID = T1.INSTRUMENTID AND T2.ROWSTATUS IS
NULL AND T2.ISRELEVANT = 1
INNER JOIN
VDPS2.VTINSTITUTION T5
ON T5.INSTITUTIONID = T6.TRADINGPLACE AND T5.ROWSTATUS IS
NULL
INNER JOIN
VDPS2.VTTRADINGPLACE T8
ON T8.INSTITUTIONID = T6.TRADINGPLACE
LEFT OUTER JOIN
VDPS2.VTINSTRIDENT T9
ON T9.INSTRUMENTID = T1.INSTRUMENTID AND T9.SCHEMESYMBOL =
'I-' AND T9.ROWSTATUS = 1
LEFT OUTER JOIN
VDPS2.VTINSTRIDENT T3
ON T3.INSTRUMENTID = T6.CURRENCY AND T3.SCHEMESYMBOL =
'I2' AND T3.ROWSTATUS = 1
LEFT OUTER JOIN
VDPS2.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 ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.SMDS_RA15 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.SMDS_RA15 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.SMDS_RA15 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.SMDS_RA15 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.SMDS_RA15 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.SMDS_RA15 TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.SMDS_RA15 FOR VDPS2.SMDS_RA15 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPS2.VVV_XPS_IL#VLIID_V01
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
CREATE VIEW VDPS2.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 VDPS2.VTINSTRIDENT T1
INNER JOIN
VDPS2.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
VDPS2.VTLISTING T3
ON T3.INSTRUMENTID = T1.INSTRUMENTID
LEFT OUTER JOIN
VDPS2.VTINSTIIDENT T4
ON T4.INSTITUTIONID = T3.TRADINGPLACE AND T4.SCHEMESYMBOL
= 'BCN' AND T4.ROWSTATUS = 1
INNER JOIN
VDPS2.VTINSTITUTION T5
ON T5.INSTITUTIONID = T3.TRADINGPLACE AND (T5.ROWSTATUS IS
NULL OR T5.ROWSTATUS <> 2)
LEFT OUTER JOIN
VDPS2.VTLISTINGIDENT T6
ON T6.INSTRUMENTID = T3.INSTRUMENTID AND T6.LISTINGNO = T3.
LISTINGNO AND T6.SCHEMESYMBOL IN('TKH', 'RIC', 'BBI', 'TKE')
LEFT OUTER JOIN
VDPS2.CTLISTING T7
ON T7.INSTRUMENTID = T3.INSTRUMENTID AND T7.LISTINGNO = T3.
LISTINGNO AND T7.MANDATOR = 1
LEFT OUTER JOIN
VDPS2.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) ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.VVV_XPS_IL#VLIID_V01 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.VVV_XPS_IL#VLIID_V01 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.VVV_XPS_IL#VLIID_V01 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.VVV_XPS_IL#VLIID_V01 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.VVV_XPS_IL#VLIID_V01 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.VVV_XPS_IL#VLIID_V01 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.VVV_XPS_IL#VLIID_V01 TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.VVV_XPS_IL#VLIID_V01 FOR VDPS2.VVV_XPS_IL#VLIID_V01
;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPS2.VVV_XPS_VLIID002_V07
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
CREATE VIEW VDPS2.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 VDPS2.VTINSTRIDENT T1
INNER JOIN
VDPS2.VTINSTRUMENT T2
ON T2.INSTRUMENTID = T1.INSTRUMENTID AND (T2.ROWSTATUS IS
NULL OR T2.ROWSTATUS <> 2)
INNER JOIN
VDPS2.VTLISTING T3
ON T3.INSTRUMENTID = T1.INSTRUMENTID
LEFT OUTER JOIN
VDPS2.VTINSTIIDENT T4
ON T4.INSTITUTIONID = T3.TRADINGPLACE AND T4.SCHEMESYMBOL
= 'BCN' AND T4.ROWSTATUS = 1
INNER JOIN
VDPS2.VTINSTITUTION T5
ON T5.INSTITUTIONID = T3.TRADINGPLACE AND (T5.ROWSTATUS IS
NULL OR T5.ROWSTATUS <> 2)
LEFT OUTER JOIN
VDPS2.VTLISTINGIDENT T6
ON T6.INSTRUMENTID = T3.INSTRUMENTID AND T6.LISTINGNO = T3.
LISTINGNO AND T6.SCHEMESYMBOL IN('TKH', 'RIC', 'BBI', 'TKE')
LEFT OUTER JOIN
VDPS2.CTLISTING T7
ON T7.INSTRUMENTID = T3.INSTRUMENTID AND T7.LISTINGNO = T3.
LISTINGNO AND T7.MANDATOR = 1
LEFT OUTER JOIN
VDPS2.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 ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.VVV_XPS_VLIID002_V07 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.VVV_XPS_VLIID002_V07 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.VVV_XPS_VLIID002_V07 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.VVV_XPS_VLIID002_V07 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.VVV_XPS_VLIID002_V07 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.VVV_XPS_VLIID002_V07 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.VVV_XPS_VLIID002_V07 TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.VVV_XPS_VLIID002_V07 FOR VDPS2.VVV_XPS_VLIID002_V07
;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPS2.XPS_IL#VINLI
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
CREATE VIEW VDPS2.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 VDPS2.VTINSTRIDENT T1
INNER JOIN
VDPS2.VTINSTRUMENT T2
ON T2.INSTRUMENTID = T1.INSTRUMENTID AND (T2.ROWSTATUS IS
NULL OR T2.ROWSTATUS <> 2)
INNER JOIN
VDPS2.VTINSTIROLE T3
ON T3.INSTRUMENTID = T1.INSTRUMENTID AND T3.ROLETYPE IN(1,
25)
INNER JOIN
VDPS2.VTINSTITUTION T4
ON T4.INSTITUTIONID = T3.INSTITUTIONID AND (T4.ROWSTATUS
IS NULL OR T4.ROWSTATUS <> 2)
INNER JOIN
VDPS2.VTINSTIIDENT T5
ON T5.INSTITUTIONID = T4.INSTITUTIONID AND T5.SCHEMESYMBOL
= 'GK' AND T5.ROWSTATUS = 1
LEFT OUTER JOIN
VDPS2.CTINSTRSP42DETAILS T6
ON T6.INSTRUMENTID = T2.INSTRUMENTID AND T6.MANDATOR = 1
WHERE T1.SCHEMESYMBOL = 'CH'
AND T1.ROWSTATUS = 1 ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.XPS_IL#VINLI TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_IL#VINLI TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_IL#VINLI TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_IL#VINLI TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_IL#VINLI TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_IL#VINLI TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.XPS_IL#VINLI FOR VDPS2.XPS_IL#VINLI ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPS2.XPS_IL#VLIID
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
CREATE VIEW VDPS2.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 VDPS2.VTINSTRIDENT T1
INNER JOIN
VDPS2.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
VDPS2.VTLISTING T3
ON T3.INSTRUMENTID = T1.INSTRUMENTID
LEFT OUTER JOIN
VDPS2.VTINSTIIDENT T4
ON T4.INSTITUTIONID = T3.TRADINGPLACE AND T4.SCHEMESYMBOL
= 'BCN' AND T4.ROWSTATUS = 1
INNER JOIN
VDPS2.VTINSTITUTION T5
ON T5.INSTITUTIONID = T3.TRADINGPLACE AND (T5.ROWSTATUS IS
NULL OR T5.ROWSTATUS <> 2)
LEFT OUTER JOIN
VDPS2.VTLISTINGIDENT T6
ON T6.INSTRUMENTID = T3.INSTRUMENTID AND T6.LISTINGNO = T3.
LISTINGNO AND T6.SCHEMESYMBOL IN('TKH', 'RIC', 'BBI')
LEFT OUTER JOIN
VDPS2.CTLISTING T7
ON T7.INSTRUMENTID = T3.INSTRUMENTID AND T7.LISTINGNO = T3.
LISTINGNO AND T7.MANDATOR = 1
LEFT OUTER JOIN
VDPS2.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) ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.XPS_IL#VLIID TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_IL#VLIID TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_IL#VLIID TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_IL#VLIID TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_IL#VLIID TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_IL#VLIID TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_IL#VLIID TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.XPS_IL#VLIID FOR VDPS2.XPS_IL#VLIID ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPS2.XPS_VCOMP000
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","F326930" ;
--
CREATE VIEW VDPS2.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 VDPS2.VTINSTIIDENT T1
INNER JOIN
VDPS2.VTINSTITUTION T2
ON T2.INSTITUTIONID = T1.INSTITUTIONID AND (T2.ROWSTATUS
IS NULL OR T2.ROWSTATUS <> 2)
LEFT OUTER JOIN
VDPS2.VTINSTRIDENT T4
ON T4.INSTRUMENTID = T2.ACCOUNTINGCURR AND T4.SCHEMESYMBOL
= 'I2' AND T4.ROWSTATUS = 1
LEFT OUTER JOIN
VDPS2.VTINSTRIDENT T5
ON T5.INSTRUMENTID = T2.ACCOUNTINGCURR AND T5.SCHEMESYMBOL
= 'CS-WS80-WHRG' AND T5.ROWSTATUS = 1
WHERE T1.ROWSTATUS = 1 ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.XPS_VCOMP000 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VCOMP000 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VCOMP000 TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.XPS_VCOMP000 FOR VDPS2.XPS_VCOMP000 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPS2.XPS_VCOPR002_V02
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","OA1A" ;
--
CREATE VIEW VDPS2.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 VDPS2.VTINSTRFLATSYMBOLS A1
INNER JOIN
VDPS2.VTINSTRUMENT A2
ON A2.INSTRUMENTID = A1.INSTRUMENTID AND (A2.ROWSTATUS IS
NULL OR A2.ROWSTATUS <> 2)
INNER JOIN
VDPS2.VTINSTRSTRUCT A3
ON A3.INSTRUMENTID = A1.INSTRUMENTID
INNER JOIN
VDPS2.VTINSTRFLATSYMBOLS T1
ON T1.INSTRUMENTID = A3.CHILDINSTRID AND T1.ROWSTATUS = 1
INNER JOIN
VDPS2.VTINSTRUMENT T2
ON T2.INSTRUMENTID = T1.INSTRUMENTID AND T1.ROWSTATUS = 1
AND (T2.ROWSTATUS IS NULL OR T2.ROWSTATUS <> 2)
LEFT OUTER JOIN
VDPS2.VTINSTRIDENT T4
ON T4.INSTRUMENTID = T2.NOMINALCURR AND T4.SCHEMESYMBOL =
'I2' AND T4.ROWSTATUS = 1
LEFT OUTER JOIN
VDPS2.VTINSTRWITHCF T7
ON T7.INSTRUMENTID = T1.INSTRUMENTID
LEFT OUTER JOIN
VDPS2.VTINSTIROLE T8
ON T8.INSTRUMENTID = T1.INSTRUMENTID AND T8.ROLETYPE = 2
LEFT OUTER JOIN
VDPS2.VTINSTIIDENT T9
ON T9.INSTITUTIONID = T8.INSTITUTIONID AND T9.SCHEMESYMBOL
= 'GK' AND T9.ROWSTATUS = 1
LEFT OUTER JOIN
VDPS2.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') ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.XPS_VCOPR002_V02 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VCOPR002_V02 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VCOPR002_V02 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VCOPR002_V02 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VCOPR002_V02 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VCOPR002_V02 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VCOPR002_V02 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VCOPR002_V02 TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.XPS_VCOPR002_V02 FOR VDPS2.XPS_VCOPR002_V02 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPS2.XPS_VDISP000
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","F281992" ;
--
CREATE VIEW VDPS2.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 VDPS2.VTINSTIIDENT T1
INNER JOIN
VDPS2.VTINSTITUTION T2
ON T2.INSTITUTIONID = T1.INSTITUTIONID AND (T2.ROWSTATUS
IS NULL OR T2.ROWSTATUS <> 2)
INNER JOIN
VDPS2.VTINSTISTRUCT T3
ON T3.CHILDINSTIID = T2.INSTITUTIONID
INNER JOIN
VDPS2.VTINSTITUTION T4
ON T4.INSTITUTIONID = T3.PARENTINSTIID AND (T4.ROWSTATUS
IS NULL OR T4.ROWSTATUS <> 2)
INNER JOIN
VDPS2.VTINSTIIDENT T5
ON T5.INSTITUTIONID = T4.INSTITUTIONID AND T5.ROWSTATUS = 1
WHERE T1.ROWSTATUS = 1 ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.XPS_VDISP000 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VDISP000 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VDISP000 TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.XPS_VDISP000 FOR VDPS2.XPS_VDISP000 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPS2.XPS_VDOMI000_V02
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","OA1A" ;
--
CREATE VIEW VDPS2.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 VDPS2.VTINSTIIDENT T1
INNER JOIN
VDPS2.VTINSTITUTION T2
ON T2.INSTITUTIONID = T1.INSTITUTIONID AND (T2.ROWSTATUS
IS NULL OR T2.ROWSTATUS <> 2)
INNER JOIN
VDPS2.VTGEOUNIT T5
ON T5.GEOUNITID = T2.DOMICILE AND (T5.ROWSTATUS IS NULL
OR T5.ROWSTATUS <> 2)
WHERE T1.ROWSTATUS = 1 ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.XPS_VDOMI000_V02 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VDOMI000_V02 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VDOMI000_V02 TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.XPS_VDOMI000_V02 FOR VDPS2.XPS_VDOMI000_V02 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPS2.XPS_VGEUC000_V02
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
CREATE VIEW VDPS2.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 VDPS2.VTINSTIIDENT T1
INNER JOIN
VDPS2.VTINSTITUTION T2
ON T2.INSTITUTIONID = T1.INSTITUTIONID AND (T2.ROWSTATUS
IS NULL OR T2.ROWSTATUS <> 2)
INNER JOIN
VDPS2.VTGEOUNIT T4
ON T4.GEOUNITID = T2.DOMICILE AND (T4.ROWSTATUS IS NULL
OR T4.ROWSTATUS <> 2)
INNER JOIN
VDPS2.VTGEOUNITCURR T5
ON T5.GEOUNITID = T4.GEOUNITID
LEFT OUTER JOIN
VDPS2.VTINSTRIDENT T6
ON T6.INSTRUMENTID = T5.CURRENCY AND T6.ROWSTATUS = 1
WHERE T1.ROWSTATUS = 1 ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.XPS_VGEUC000_V02 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VGEUC000_V02 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VGEUC000_V02 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VGEUC000_V02 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VGEUC000_V02 TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.XPS_VGEUC000_V02 FOR VDPS2.XPS_VGEUC000_V02 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPS2.XPS_VINAC002_V02
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
CREATE VIEW VDPS2.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 VDPS2.VTINSTIIDENT T1
INNER JOIN
VDPS2.VTINSTITUTION T2
ON T2.INSTITUTIONID = T1.INSTITUTIONID AND (T2.ROWSTATUS
IS NULL OR T2.ROWSTATUS <> 2)
WHERE T1.ROWSTATUS = 1 ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.XPS_VINAC002_V02 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VINAC002_V02 TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.XPS_VINAC002_V02 FOR VDPS2.XPS_VINAC002_V02 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPS2.XPS_VINAC003_V02
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
CREATE VIEW VDPS2.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 VDPS2.VTINSTIIDENT T1
INNER JOIN
VDPS2.VTINSTITUTION T2
ON T2.INSTITUTIONID = T1.INSTITUTIONID ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.XPS_VINAC003_V02 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VINAC003_V02 TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.XPS_VINAC003_V02 FOR VDPS2.XPS_VINAC003_V02 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPS2.XPS_VINFD003
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
CREATE VIEW VDPS2.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 VDPS2.VTINSTRFLATSYMBOLS T1
INNER JOIN
VDPS2.VTINSTRFLATDATA T2
ON T2.INSTRUMENTID = T1.INSTRUMENTID
INNER JOIN
VDPS2.VTINSTITUTION T3
ON T3.INSTITUTIONID = T2.ISSUER
LEFT OUTER JOIN
VDPS2.VTINSTITUTION T4
ON T4.INSTITUTIONID = T2.ORIGINALISSUER ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.XPS_VINFD003 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VINFD003 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VINFD003 TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.XPS_VINFD003 FOR VDPS2.XPS_VINFD003 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPS2.XPS_VINFD008_V02
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
CREATE VIEW VDPS2.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 VDPS2.VTINSTRFLATDATA T1
INNER JOIN
VDPS2.VTLISTING T2
ON T2.INSTRUMENTID = T1.INSTRUMENTID
LEFT OUTER JOIN
VDPS2.VTINSTITUTION T3
ON T3.INSTITUTIONID = T1.ISSUER ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.XPS_VINFD008_V02 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VINFD008_V02 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VINFD008_V02 TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.XPS_VINFD008_V02 FOR VDPS2.XPS_VINFD008_V02 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPS2.XPS_VINGR009_V02
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
CREATE VIEW VDPS2.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 VDPS2.VTINSTRFLATSYMBOLS T1
INNER JOIN
VDPS2.VTINSTRUMENT T2
ON T2.INSTRUMENTID = T1.INSTRUMENTID AND (T2.ROWSTATUS IS
NULL OR T2.ROWSTATUS <> 2)
INNER JOIN
VDPS2.VTINSTRINGROUP T3
ON T3.INSTRUMENTID = T1.INSTRUMENTID AND T3.SCHEMESYMBOL =
'ECBTR'
LEFT OUTER JOIN
VDPS2.VTINSTRIDENT T4
ON T4.INSTRUMENTID = T2.NOMINALCURR AND T4.SCHEMESYMBOL =
'I2' AND T4.ROWSTATUS = 1
LEFT OUTER JOIN
VDPS2.VTINSTRWITHCF T7
ON T7.INSTRUMENTID = T1.INSTRUMENTID
LEFT OUTER JOIN
VDPS2.VTINSTIROLE T8
ON T8.INSTRUMENTID = T1.INSTRUMENTID AND T8.ROLETYPE = 2
LEFT OUTER JOIN
VDPS2.VTINSTIIDENT T9
ON T9.INSTITUTIONID = T8.INSTITUTIONID AND T9.SCHEMESYMBOL
= 'GK' AND T9.ROWSTATUS = 1
LEFT OUTER JOIN
VDPS2.VTINSTITUTION T10
ON T10.INSTITUTIONID = T9.INSTITUTIONID AND (T10.ROWSTATUS
IS NULL OR T10.ROWSTATUS <> 2)
WHERE T1.ROWSTATUS = 1 ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.XPS_VINGR009_V02 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VINGR009_V02 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VINGR009_V02 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VINGR009_V02 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VINGR009_V02 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VINGR009_V02 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VINGR009_V02 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VINGR009_V02 TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.XPS_VINGR009_V02 FOR VDPS2.XPS_VINGR009_V02 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPS2.XPS_VINLI000_V05
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
CREATE VIEW VDPS2.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 VDPS2.VTINSTRIDENT T1
INNER JOIN
VDPS2.VTINSTRUMENT T2
ON T2.INSTRUMENTID = T1.INSTRUMENTID
INNER JOIN
VDPS2.VTINSTIROLE T3
ON T3.INSTRUMENTID = T1.INSTRUMENTID
INNER JOIN
VDPS2.VTINSTITUTION T4
ON T4.INSTITUTIONID = T3.INSTITUTIONID
INNER JOIN
VDPS2.VTINSTIIDENT T5
ON T5.INSTITUTIONID = T4.INSTITUTIONID
INNER JOIN
VDPS2.VTINSTRFLATDATA T6
ON T6.INSTRUMENTID = T1.INSTRUMENTID ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.XPS_VINLI000_V05 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VINLI000_V05 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VINLI000_V05 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VINLI000_V05 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VINLI000_V05 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VINLI000_V05 TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.XPS_VINLI000_V05 FOR VDPS2.XPS_VINLI000_V05 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPS2.XPS_VINLI007_V02
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
CREATE VIEW VDPS2.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 VDPS2.VTINSTRIDENT T1
INNER JOIN
VDPS2.VTINSTRUMENT T2
ON T2.INSTRUMENTID = T1.INSTRUMENTID
INNER JOIN
VDPS2.VTINSTIROLE T3
ON T3.INSTRUMENTID = T1.INSTRUMENTID
INNER JOIN
VDPS2.VTINSTITUTION T4
ON T4.INSTITUTIONID = T3.INSTITUTIONID
INNER JOIN
VDPS2.VTINSTIIDENT T5
ON T5.INSTITUTIONID = T4.INSTITUTIONID ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.XPS_VINLI007_V02 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VINLI007_V02 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VINLI007_V02 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VINLI007_V02 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VINLI007_V02 TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.XPS_VINLI007_V02 FOR VDPS2.XPS_VINLI007_V02 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPS2.XPS_VINLI008_V03
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
CREATE VIEW VDPS2.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 VDPS2.VTINSTRIDENT T1
INNER JOIN
VDPS2.VTINSTRUMENT T2
ON T2.INSTRUMENTID = T1.INSTRUMENTID
INNER JOIN
VDPS2.VTINSTIROLE T3
ON T3.INSTRUMENTID = T1.INSTRUMENTID
INNER JOIN
VDPS2.VTINSTITUTION T4
ON T4.INSTITUTIONID = T3.INSTITUTIONID
LEFT OUTER JOIN
VDPS2.VTINSTIGROUPKEY T0
ON T0.INSTITUTIONID = T3.INSTITUTIONID
INNER JOIN
VDPS2.VTINSTIIDENT T5
ON T5.INSTITUTIONID = T4.INSTITUTIONID ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.XPS_VINLI008_V03 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VINLI008_V03 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VINLI008_V03 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VINLI008_V03 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VINLI008_V03 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VINLI008_V03 TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.XPS_VINLI008_V03 FOR VDPS2.XPS_VINLI008_V03 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPS2.XPS_VINLI010_V01
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
CREATE VIEW VDPS2.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 VDPS2.VTINSTRIDENT T1
INNER JOIN
VDPS2.VTINSTIROLE T2
ON T2.INSTRUMENTID = T1.INSTRUMENTID
INNER JOIN
VDPS2.VTINSTITUTION T3
ON T3.INSTITUTIONID = T2.INSTITUTIONID
INNER JOIN
VDPS2.VTINSTIIDENT T4
ON T4.INSTITUTIONID = T3.INSTITUTIONID AND T4.SCHEMESYMBOL
= 'GK' AND T4.ROWSTATUS IN(1, 2)
INNER JOIN
VDPS2.VTINSTIFLATSYMBOLS T5
ON T5.INSTITUTIONID = T2.INSTITUTIONID AND T5.ROWSTATUS = 1
LEFT OUTER JOIN
VDPS2.VTINDUSTRY T6
ON T6.IDSYMBOL = T3.INDUSTRYTKBN AND T6.SCHEMESYMBOL =
'TKBN'
LEFT OUTER JOIN
VDPS2.VTINDUSTRY T7
ON T7.IDSYMBOL = T3.INDUSTRYCS AND T7.SCHEMESYMBOL =
'CS-WS80-BRAN'
LEFT OUTER JOIN
VDPS2.VTINDUSTRY T8
ON T8.IDSYMBOL = T3.INDUSTRYMSCI AND T8.SCHEMESYMBOL =
'MSCI'
WHERE T1.ROWSTATUS IN(1, 2) ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.XPS_VINLI010_V01 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VINLI010_V01 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VINLI010_V01 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VINLI010_V01 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VINLI010_V01 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VINLI010_V01 TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.XPS_VINLI010_V01 FOR VDPS2.XPS_VINLI010_V01 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPS2.XPS_VINSH000
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","F616617" ;
--
CREATE VIEW VDPS2.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 VDPS2.VTINSTRIDENT T1
INNER JOIN
VDPS2.VTINSTRUMENT T2
ON T2.INSTRUMENTID = T1.INSTRUMENTID
INNER JOIN
VDPS2.VTLISTING T3
ON T3.INSTRUMENTID = T1.INSTRUMENTID
INNER JOIN
VDPS2.CTLISTING T5
ON T5.INSTRUMENTID = T3.INSTRUMENTID AND T5.LISTINGNO = T3.
LISTINGNO AND T5.ISSTEERINGFLAG4 = 1
INNER JOIN
VDPS2.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 ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.XPS_VINSH000 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VINSH000 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VINSH000 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VINSH000 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VINSH000 TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.XPS_VINSH000 FOR VDPS2.XPS_VINSH000 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPS2.XPS_VINSH001
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","OA1A" ;
--
CREATE VIEW VDPS2.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 VDPS2.VTINSTRIDENT T1
INNER JOIN
VDPS2.VTINSTRUMENT T2
ON T2.INSTRUMENTID = T1.INSTRUMENTID AND (T2.ROWSTATUS IS
NULL OR T2.ROWSTATUS <> 2)
INNER JOIN
VDPS2.VTLISTING T3
ON T3.INSTRUMENTID = T1.INSTRUMENTID
INNER JOIN
VDPS2.CTLISTING T4
ON T4.INSTRUMENTID = T3.INSTRUMENTID AND T4.LISTINGNO = T3.
LISTINGNO AND T4.ISSTEERINGFLAG4 = 1
INNER JOIN
VDPS2.VTINSTIIDENT T5
ON T5.INSTITUTIONID = T3.TRADINGPLACE AND T5.SCHEMESYMBOL
= 'BCN' AND T5.ROWSTATUS = 1
LEFT OUTER JOIN
VDPS2.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
VDPS2.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
VDPS2.VTLISTINGGRPKEY T8
ON T8.INSTRUMENTID = T3.INSTRUMENTID AND T8.LISTINGNO = T3.
LISTINGNO AND T8.INSTRGRSCHMSYMBOL = 'TK' AND T8.IDSYMBOL
= '79'
LEFT OUTER JOIN
VDPS2.VTINSTRIDENT T9
ON T9.INSTRUMENTID = T3.CURRENCY AND T9.SCHEMESYMBOL =
'I2' AND T9.ROWSTATUS = 1
WHERE T1.ROWSTATUS = 1 ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.XPS_VINSH001 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VINSH001 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VINSH001 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VINSH001 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VINSH001 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VINSH001 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VINSH001 TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.XPS_VINSH001 FOR VDPS2.XPS_VINSH001 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPS2.XPS_VINSH002
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
CREATE VIEW VDPS2.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 VDPS2.VTINSTRIDENT T1
INNER JOIN
VDPS2.VTINSTRUMENT T2
ON T2.INSTRUMENTID = T1.INSTRUMENTID AND (T2.ROWSTATUS IS
NULL OR T2.ROWSTATUS <> 2)
INNER JOIN
VDPS2.VTLISTING T3
ON T3.INSTRUMENTID = T1.INSTRUMENTID
INNER JOIN
VDPS2.CTLISTING T4
ON T4.INSTRUMENTID = T3.INSTRUMENTID AND T4.LISTINGNO = T3.
LISTINGNO AND T4.ISSTEERINGFLAG4 = 1
INNER JOIN
VDPS2.VTINSTIIDENT T5
ON T5.INSTITUTIONID = T3.TRADINGPLACE AND T5.SCHEMESYMBOL
= 'BCN' AND T5.ROWSTATUS = 1
LEFT OUTER JOIN
VDPS2.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
VDPS2.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
VDPS2.VTLISTINGGRPKEY T8
ON T8.INSTRUMENTID = T3.INSTRUMENTID AND T8.LISTINGNO = T3.
LISTINGNO AND T8.INSTRGRSCHMSYMBOL = 'TK' AND T8.IDSYMBOL
= '79'
LEFT OUTER JOIN
VDPS2.VTINSTRIDENT T9
ON T9.INSTRUMENTID = T3.CURRENCY AND T9.SCHEMESYMBOL =
'I2' AND T9.ROWSTATUS = 1
WHERE T1.ROWSTATUS = 1 ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.XPS_VINSH002 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VINSH002 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VINSH002 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VINSH002 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VINSH002 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VINSH002 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VINSH002 TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.XPS_VINSH002 FOR VDPS2.XPS_VINSH002 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPS2.XPS_VISID001
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","F281992" ;
--
CREATE VIEW VDPS2.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 VDPS2.VTINSTIIDENT T1
INNER JOIN
VDPS2.VTINSTITUTION T2
ON T2.INSTITUTIONID = T1.INSTITUTIONID AND (T2.ROWSTATUS
IS NULL OR T2.ROWSTATUS <> 2)
INNER JOIN
VDPS2.VTINSTIIDENT T3
ON T3.INSTITUTIONID = T1.INSTITUTIONID AND T3.ROWSTATUS = 1
WHERE T1.ROWSTATUS = 1 ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.XPS_VISID001 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VISID001 TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.XPS_VISID001 FOR VDPS2.XPS_VISID001 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPS2.XPS_VISID002
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
CREATE VIEW VDPS2.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 VDPS2.VTINSTIIDENT T1
INNER JOIN
VDPS2.VTINSTITUTION T2
ON T2.INSTITUTIONID = T1.INSTITUTIONID AND (T2.ROWSTATUS
IS NULL OR T2.ROWSTATUS <> 2)
INNER JOIN
VDPS2.VTINSTIIDENT T3
ON T3.INSTITUTIONID = T1.INSTITUTIONID AND T3.ROWSTATUS = 1
INNER JOIN
VDPS2.VTINSTIIDSCHEME T4
ON T4.SCHEMESYMBOL = T3.SCHEMESYMBOL AND (T4.ROWSTATUS IS
NULL OR T4.ROWSTATUS <> 2)
WHERE T1.ROWSTATUS = 1 ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.XPS_VISID002 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VISID002 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VISID002 TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.XPS_VISID002 FOR VDPS2.XPS_VISID002 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPS2.XPS_VISRG000_V02
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","OA1A" ;
--
CREATE VIEW VDPS2.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 VDPS2.VTINSTRIDENT T1
INNER JOIN
VDPS2.VTINSTRUMENT T2
ON T2.INSTRUMENTID = T1.INSTRUMENTID
INNER JOIN
VDPS2.VTINSTIROLE T3
ON T3.INSTRUMENTID = T1.INSTRUMENTID
INNER JOIN
VDPS2.VTINSTITUTION T4
ON T4.INSTITUTIONID = T3.INSTITUTIONID
INNER JOIN
VDPS2.VTINSTIIDENT T5
ON T5.INSTITUTIONID = T4.INSTITUTIONID
INNER JOIN
VDPS2.VTINSTIRATING T6
ON T6.INSTITUTIONID = T3.INSTITUTIONID ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.XPS_VISRG000_V02 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VISRG000_V02 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VISRG000_V02 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VISRG000_V02 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VISRG000_V02 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VISRG000_V02 TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.XPS_VISRG000_V02 FOR VDPS2.XPS_VISRG000_V02 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPS2.XPS_VISRG002
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","F281992" ;
--
CREATE VIEW VDPS2.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 VDPS2.VTINSTIIDENT T1
INNER JOIN
VDPS2.VTINSTITUTION T2
ON T2.INSTITUTIONID = T1.INSTITUTIONID AND T2.ROWSTATUS IS
NULL
INNER JOIN
VDPS2.VTINSTIRATING T3
ON T3.INSTITUTIONID = T2.INSTITUTIONID
WHERE T1.ROWSTATUS = 1 ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.XPS_VISRG002 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VISRG002 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VISRG002 TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.XPS_VISRG002 FOR VDPS2.XPS_VISRG002 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPS2.XPS_VISTI000
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","F273764" ;
--
CREATE VIEW VDPS2.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 VDPS2.VTINSTIIDENT T1
INNER JOIN
VDPS2.VTINSTITUTION T2
ON T2.INSTITUTIONID = T1.INSTITUTIONID AND (T2.ROWSTATUS
IS NULL OR T2.ROWSTATUS <> 2)
WHERE T1.ROWSTATUS = 1 ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.XPS_VISTI000 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VISTI000 TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.XPS_VISTI000 FOR VDPS2.XPS_VISTI000 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPS2.XPS_VITGK002
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
CREATE VIEW VDPS2.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 VDPS2.VTINSTIIDENT T1
INNER JOIN
VDPS2.VTINSTITUTION T2
ON T2.INSTITUTIONID = T1.INSTITUTIONID AND (T2.ROWSTATUS
IS NULL OR T2.ROWSTATUS <> 2)
INNER JOIN
VDPS2.VTINSTIGROUPKEY T3
ON T3.INSTITUTIONID = T1.INSTITUTIONID
INNER JOIN
VDPS2.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 ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.XPS_VITGK002 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VITGK002 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VITGK002 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VITGK002 TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.XPS_VITGK002 FOR VDPS2.XPS_VITGK002 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPS2.XPS_VLIID000_V02
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","OA1A" ;
--
CREATE VIEW VDPS2.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 VDPS2.VTINSTRIDENT T1
INNER JOIN
VDPS2.VTINSTRUMENT
ON T1.INSTRUMENTID = VDPS2.VTINSTRUMENT.INSTRUMENTID AND (
VDPS2.VTINSTRUMENT.ROWSTATUS IS NULL OR VDPS2.
VTINSTRUMENT.ROWSTATUS <> 2) AND T1.ROWSTATUS = 1
INNER JOIN
VDPS2.VTLISTING LI1
ON T1.INSTRUMENTID = LI1.INSTRUMENTID AND LI1.
LISTINGSTATUSTYPE <> 9 AND LI1.LISTINGSTATUSTYPE <> 18
LEFT OUTER JOIN
VDPS2.CTLISTING LI2
ON LI1.INSTRUMENTID = LI2.INSTRUMENTID AND LI1.LISTINGNO =
LI2.LISTINGNO
LEFT OUTER JOIN
VDPS2.VTLISTINGIDENT LID
ON LI1.INSTRUMENTID = LID.INSTRUMENTID AND LI1.LISTINGNO =
LID.LISTINGNO
INNER JOIN
VDPS2.VTINSTIIDENT BCN
ON LI1.TRADINGPLACE = BCN.INSTITUTIONID AND BCN.
SCHEMESYMBOL = 'BCN' AND BCN.ROWSTATUS = 1
LEFT OUTER JOIN
VDPS2.VTINSTIIDENT BCNCS
ON LI1.TRADINGPLACE = BCNCS.INSTITUTIONID AND BCNCS.
SCHEMESYMBOL = 'CS-WS80-BPL' AND BCNCS.ROWSTATUS = 1
LEFT OUTER JOIN
VDPS2.VTINSTIIDENT BCA
ON LI1.TRADINGPLACE = BCA.INSTITUTIONID AND BCA.
SCHEMESYMBOL = 'BCA' AND BCA.ROWSTATUS = 1 ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.XPS_VLIID000_V02 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VLIID000_V02 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VLIID000_V02 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VLIID000_V02 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VLIID000_V02 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VLIID000_V02 TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.XPS_VLIID000_V02 FOR VDPS2.XPS_VLIID000_V02 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPS2.XPS_VLIID001_V04
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
CREATE VIEW VDPS2.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 VDPS2.VTINSTRIDENT T1
INNER JOIN
VDPS2.VTINSTRUMENT T2
ON T1.INSTRUMENTID = T2.INSTRUMENTID
INNER JOIN
VDPS2.VTLISTING T3
ON T1.INSTRUMENTID = T3.INSTRUMENTID
LEFT OUTER JOIN
VDPS2.VTINSTRIDENT T4
ON T3.CURRENCY = T4.INSTRUMENTID AND T4.SCHEMESYMBOL =
'CS-WS80-WHRG'
LEFT OUTER JOIN
VDPS2.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
VDPS2.CTLISTING T6
ON T3.INSTRUMENTID = T6.INSTRUMENTID AND T6.LISTINGNO = T3.
LISTINGNO AND T6.MANDATOR = 1
INNER JOIN
VDPS2.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) ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.XPS_VLIID001_V04 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VLIID001_V04 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VLIID001_V04 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VLIID001_V04 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VLIID001_V04 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VLIID001_V04 TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.XPS_VLIID001_V04 FOR VDPS2.XPS_VLIID001_V04 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPS2.XPS_VLIID002_V06
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
CREATE VIEW VDPS2.XPS_VLIID002_V06 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 VDPS2.VTINSTRIDENT T1
INNER JOIN
VDPS2.VTINSTRUMENT T2
ON T2.INSTRUMENTID = T1.INSTRUMENTID AND (T2.ROWSTATUS IS
NULL OR T2.ROWSTATUS <> 2)
INNER JOIN
VDPS2.VTLISTING T3
ON T3.INSTRUMENTID = T1.INSTRUMENTID
LEFT OUTER JOIN
VDPS2.VTINSTIIDENT T4
ON T4.INSTITUTIONID = T3.TRADINGPLACE AND T4.SCHEMESYMBOL
= 'BCN' AND T4.ROWSTATUS = 1
INNER JOIN
VDPS2.VTINSTITUTION T5
ON T5.INSTITUTIONID = T3.TRADINGPLACE AND (T5.ROWSTATUS IS
NULL OR T5.ROWSTATUS <> 2)
LEFT OUTER JOIN
VDPS2.VTLISTINGIDENT T6
ON T6.INSTRUMENTID = T3.INSTRUMENTID AND T6.LISTINGNO = T3.
LISTINGNO AND T6.SCHEMESYMBOL IN('TKH', 'RIC', 'BBI')
LEFT OUTER JOIN
VDPS2.CTLISTING T7
ON T7.INSTRUMENTID = T3.INSTRUMENTID AND T7.LISTINGNO = T3.
LISTINGNO AND T7.MANDATOR = 1
LEFT OUTER JOIN
VDPS2.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 ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.XPS_VLIID002_V06 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VLIID002_V06 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VLIID002_V06 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VLIID002_V06 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VLIID002_V06 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VLIID002_V06 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VLIID002_V06 TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.XPS_VLIID002_V06 FOR VDPS2.XPS_VLIID002_V06 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPS2.XPS_VLIID003
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
CREATE VIEW VDPS2.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 VDPS2.VTINSTRIDENT T1
INNER JOIN
VDPS2.VTINSTRUMENT T2
ON T2.INSTRUMENTID = T1.INSTRUMENTID AND (T2.ROWSTATUS IS
NULL OR T2.ROWSTATUS <> 2)
INNER JOIN
VDPS2.VTLISTING T3
ON T3.INSTRUMENTID = T1.INSTRUMENTID
INNER JOIN
VDPS2.VTINSTIIDENT T4
ON T4.INSTITUTIONID = T3.TRADINGPLACE AND T4.SCHEMESYMBOL
= 'BCN' AND T4.ROWSTATUS = 1
LEFT OUTER JOIN
VDPS2.VTINSTRIDENT T5
ON T5.INSTRUMENTID = T3.CURRENCY AND T5.SCHEMESYMBOL =
'I2' AND T5.ROWSTATUS = 1
LEFT OUTER JOIN
VDPS2.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
VDPS2.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 ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.XPS_VLIID003 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VLIID003 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VLIID003 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VLIID003 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VLIID003 TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.XPS_VLIID003 FOR VDPS2.XPS_VLIID003 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPS2.XPS_VLIID004
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
CREATE VIEW VDPS2.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 VDPS2.VTINSTRIDENT T1
INNER JOIN
VDPS2.VTINSTRUMENT T2
ON T2.INSTRUMENTID = T1.INSTRUMENTID AND (T2.ROWSTATUS IS
NULL OR T2.ROWSTATUS <> 2)
INNER JOIN
VDPS2.VTLISTING T3
ON T3.INSTRUMENTID = T1.INSTRUMENTID
INNER JOIN
VDPS2.VTINSTIIDENT T4
ON T4.INSTITUTIONID = T3.TRADINGPLACE AND T4.SCHEMESYMBOL
= 'BCN' AND T4.ROWSTATUS = 1
LEFT OUTER JOIN
VDPS2.VTINSTRIDENT T5
ON T5.INSTRUMENTID = T3.CURRENCY AND T5.SCHEMESYMBOL =
'I2' AND T5.ROWSTATUS = 1
LEFT OUTER JOIN
VDPS2.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
VDPS2.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 ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.XPS_VLIID004 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VLIID004 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VLIID004 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VLIID004 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VLIID004 TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.XPS_VLIID004 FOR VDPS2.XPS_VLIID004 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPS2.XPS_VLIID005_V02
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
CREATE VIEW VDPS2.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 VDPS2.VTINSTRIDENT T1
INNER JOIN
VDPS2.VTINSTRUMENT T2
ON T2.INSTRUMENTID = T1.INSTRUMENTID AND (T2.ROWSTATUS IS
NULL OR T2.ROWSTATUS <> 2)
INNER JOIN
VDPS2.VTLISTING T3
ON T3.INSTRUMENTID = T1.INSTRUMENTID
LEFT OUTER JOIN
VDPS2.CTLISTING T4
ON T4.INSTRUMENTID = T3.INSTRUMENTID AND T4.LISTINGNO = T3.
LISTINGNO
INNER JOIN
VDPS2.VTINSTIIDENT T5
ON T5.INSTITUTIONID = T3.TRADINGPLACE AND T5.SCHEMESYMBOL
= 'BCA' AND T5.ROWSTATUS = 1
LEFT OUTER JOIN
VDPS2.VTINSTIIDENT T7
ON T7.INSTITUTIONID = T3.TRADINGPLACE AND T7.SCHEMESYMBOL
= 'BCN' AND T7.ROWSTATUS = 1
LEFT OUTER JOIN
VDPS2.VTLISTINGIDENT T6
ON T6.INSTRUMENTID = T3.INSTRUMENTID AND T6.LISTINGNO = T3.
LISTINGNO
WHERE T1.ROWSTATUS = 1 ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.XPS_VLIID005_V02 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VLIID005_V02 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VLIID005_V02 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VLIID005_V02 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VLIID005_V02 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VLIID005_V02 TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.XPS_VLIID005_V02 FOR VDPS2.XPS_VLIID005_V02 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPS2.XPS_VNTP001
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","S100447" ;
--
CREATE VIEW VDPS2.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 VDPS2.VTINSTRFLATDATA FD INNER JOIN VDPS2. 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 VDPS2.VTINSTITUTION Z ON FD. ISSUER = Z.INSTITUTIONID INNER
JOIN VDPS2.VTINSTITUTION H ON FD. MAINDEPOSITARY = H.INSTITUTIONID INNER
JOIN VDPS2.VTINSTRFLATSYMBOLS FS ON FD.INSTRUMENTID = FS.INSTRUMENTID
AND FS.ROWSTATUS = 1 INNER JOIN VDPS2.CTINSTRB42STOCK I ON I.INSTRUMENT
ID = FD.INSTRUMENTID AND I. HOLDINGSTOTAL = 999999 AND I.MANDATOR = 1 IN
NER JOIN VDPS2.VTLISTING M ON M.INSTRUMENTID = FD.INSTRUMENTID AND M.LI
STINGSTATUSTYPE <> 9 AND M. LISTINGSTATUSTYPE <> 18 LEFT OUTER JOIN VDPS
2.CTLISTING P ON P. INSTRUMENTID = M.INSTRUMENTID AND M.LISTINGNO = P.LI
STINGNO AND P. MANDATOR = 1 LEFT OUTER JOIN VDPS2.VTTRUSTDETAIL L ON L.I
NSTRUMENTID = FD.INSTRUMENTID ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.XPS_VNTP001 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VNTP001 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VNTP001 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VNTP001 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VNTP001 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VNTP001 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VNTP001 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VNTP001 TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.XPS_VNTP001 FOR VDPS2.XPS_VNTP001 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPS2.XPS_VRISI000
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","F281992" ;
--
CREATE VIEW VDPS2.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 VDPS2.VTINSTITUTION T1
LEFT OUTER JOIN
VDPS2.VTINSTIIDENT T2
ON T2.INSTITUTIONID = T1.INSTITUTIONID AND T2.SCHEMESYMBOL
= 'BCN' AND T2.ROWSTATUS = 1
LEFT OUTER JOIN
VDPS2.VTINSTIIDENT T3
ON T3.INSTITUTIONID = T1.INSTITUTIONID AND T3.SCHEMESYMBOL
= 'BCA' AND T3.ROWSTATUS = 1
LEFT OUTER JOIN
VDPS2.VTINSTIIDENT T4
ON T4.INSTITUTIONID = T1.INSTITUTIONID AND T4.SCHEMESYMBOL
= 'CS-WS80-BPL' AND T4.ROWSTATUS = 1
LEFT OUTER JOIN
VDPS2.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) ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.XPS_VRISI000 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VRISI000 TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.XPS_VRISI000 FOR VDPS2.XPS_VRISI000 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPS2.XPS_VROPP000
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
CREATE VIEW VDPS2.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 VDPS2.VTINSTIIDENT T1
INNER JOIN
VDPS2.VTINSTITUTION T2
ON T2.INSTITUTIONID = T1.INSTITUTIONID AND T2.ROWSTATUS IS
NULL
INNER JOIN
VDPS2.VTINSTIINSTIROLE T3
ON T3.ROLEPLAYERINSTIID = T2.INSTITUTIONID
INNER JOIN
VDPS2.VTINSTIIDENT T4
ON T4.INSTITUTIONID = T3.ROLEOBJECTINSTIID AND T4.
ROWSTATUS = 1
INNER JOIN
VDPS2.VTINSTITUTION T5
ON T5.INSTITUTIONID = T4.INSTITUTIONID AND T5.ROWSTATUS IS
NULL
WHERE T1.ROWSTATUS = 1 ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.XPS_VROPP000 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VROPP000 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VROPP000 TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.XPS_VROPP000 FOR VDPS2.XPS_VROPP000 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPS2.XPS_VTRPL001
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","F616617" ;
--
CREATE VIEW VDPS2.XPS_VTRPL001 AS
SELECT VDPS2.VTINSTRIDENT.IDSYMBOL,
VDPS2.VTINSTIIDENT.IDSYMBOL IDSYMBOL_BCN,
VDPS2.VTTRADINGPLACE.HASELTRONICMATCH
FROM VDPS2.VTINSTRUMENT,
VDPS2.VTINSTRIDENT,
VDPS2.VTINSTIIDENT,
VDPS2.VTLISTING,
VDPS2.VTTRADINGPLACE
WHERE VDPS2.VTINSTRIDENT.SCHEMESYMBOL = 'CH'
AND VDPS2.VTINSTRIDENT.ROWSTATUS = 1
AND VDPS2.VTINSTRIDENT.INSTRUMENTID = VDPS2.VTINSTRUMENT.
INSTRUMENTID
AND (VDPS2.VTINSTRUMENT.ROWSTATUS IS NULL
OR VDPS2.VTINSTRUMENT.ROWSTATUS <> 2)
AND VDPS2.VTLISTING.INSTRUMENTID = VDPS2.VTINSTRUMENT.
INSTRUMENTID
AND VDPS2.VTLISTING.TRADINGPLACE = VDPS2.VTINSTIIDENT.
INSTITUTIONID
AND VDPS2.VTTRADINGPLACE.INSTITUTIONID = VDPS2.VTINSTIIDENT.
INSTITUTIONID
AND VDPS2.VTINSTIIDENT.SCHEMESYMBOL = 'BCN'
AND VDPS2.VTLISTING.LISTINGSTATUSTYPE <> 9
AND VDPS2.VTLISTING.LISTINGSTATUSTYPE <> 18 ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.XPS_VTRPL001 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VTRPL001 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VTRPL001 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VTRPL001 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VTRPL001 TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.XPS_VTRPL001 FOR VDPS2.XPS_VTRPL001 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPS2.XPS_VTRUS000_V02
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","F326930" ;
--
CREATE VIEW VDPS2.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 VDPS2.VTINSTIIDENT T1
INNER JOIN
VDPS2.VTINSTITUTION T2
ON T2.INSTITUTIONID = T1.INSTITUTIONID AND (T2.ROWSTATUS
IS NULL OR T2.ROWSTATUS <> 2)
LEFT OUTER JOIN
VDPS2.VTINSTRIDENT T4
ON T4.INSTRUMENTID = T2.ACCOUNTINGCURR AND T4.SCHEMESYMBOL
= 'I2' AND T4.ROWSTATUS = 1
LEFT OUTER JOIN
VDPS2.VTINSTRIDENT T5
ON T5.INSTRUMENTID = T2.ACCOUNTINGCURR AND T5.SCHEMESYMBOL
= 'CS-WS80-WHRG' AND T5.ROWSTATUS = 1
WHERE T1.ROWSTATUS = 1 ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.XPS_VTRUS000_V02 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VTRUS000_V02 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.XPS_VTRUS000_V02 TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.XPS_VTRUS000_V02 FOR VDPS2.XPS_VTRUS000_V02 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- ADB2GEN - End of generated DDL --
------------------------------------------------------------------------
--