zOs/TX/WK922DDT
------------------------------------------------------------------------
-- --
-- Database 2 Administration Tool (DB2 Admin) , program 5697-L90 --
-- --
-- ADB2GEN - Extract object definitions from the DB2 Catalog tables --
-- --
-- Title : TRG VDPS441C 3 --
-- --
-- Input prepared on : DBAF (915) Extract time : 2009-09-07 14:01 --
-- --
-- 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 --
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- View=VDPS2.IDS_SMDS1501
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","OA1A" ;
--
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_VRSTR114
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
CREATE VIEW VDPS2.IDS_VRSTR114 AS
SELECT T1.INSTRUMENTID, T1.SYMBOLCH, T1.SYMBOLISIN, T1.SYMBOLUS,
T1.SYMBOLXS, T1.SYMBOLGB, T1.SYMBOLLU, T1.SYMBOLDE,
T1.SYMBOLI2, T1.SYMBOLI1, T1.SYMBOLT1, T1.SYMBOLT2,
T1.SYMBOLCSFI, T1.SYMBOLCSCURR, T1.CATEGORYVDPS,
T1.CATEGORYTKT, T1.CATEGORYEUZS,
T1.INSTRUMENTUPDATETIMESTAMP, T1.INSTRUMENTCREATETIMESTAMP,
T3.INSTRRESTRICTIONNO, T3.RESTRICTIONPERIOD,
T3.PROVIDER1ID, T3.PROVIDER2ID, T3.PROVIDER3ID,
T3.ISRESIDENTLOCATION, T3.ISCITIZENLOCATION,
T3.ISRESTRICTCOUNTRY, T3.ISINSTIRESTRICTION,
T3.ISRESTRICTBYISSUER, T3.RESTRICTLOCATION,
T3.PERIODBEGINDATE, T3.PERIODENDDATE, T3.RESTRMARKETTYPE,
T3.RESTRICTIONTYPE, T3.INSTIRESTRICTTYPE,
T3.RESTRICTPERIUNTP, T3.DESCRIPTION_G, T3.DESCRIPTION_E,
T3.DESCRIPTION_F, T3.DESCRIPTION_I, T3.DESCRIPTION_N,
T3.ISOVERRIDEALLOWED, T3.P42RESTRICTIONTYPE,
T3.REGISTRATIONLIMIT, T3.CREATETIMESTAMP,
T3.UPDATETIMESTAMP, T4.RESTRSUSPENSIONNO,
T4.INSTRRESTRICTIONNO RESTRICTIONNO_SUSP,
T4.PROVIDER1ID PROVIDER1ID_SUSP,
T4.PROVIDER2ID PROVIDER2ID_SUSP,
T4.PROVIDER3ID PROVIDER3ID_SUSP, T4.LOCATION,
T4.PERIODBEGINDATE PERIODBEGINDATE_SUSP,
T4.PERIODENDDATE PERIODENDDATE_SUSP, T4.RESTRICTSUSPENTP,
T4.DESCRIPTION_G DESCRIPTION_G_SUSP,
T4.DESCRIPTION_E DESCRIPTION_E_SUSP,
T4.DESCRIPTION_F DESCRIPTION_F_SUSP,
T4.DESCRIPTION_I DESCRIPTION_I_SUSP,
T4.DESCRIPTION_N DESCRIPTION_N_SUSP, T4.LOCATION_A2,
T4.LOCATION_A3, T4.LOCATION_WS80,
T5.IDSYMBOL RESTRICTLOCATIONISOA2,
T5.VALIDFROMDATE VALIDFROMDATE_ISOA2,
T5.VALIDUNTILDATE VALIDUNTILDATE_ISOA2,
T6.IDSYMBOL RESTRICTLOCATIONISOA3,
T6.VALIDFROMDATE VALIDFROMDATE_ISOA3,
T6.VALIDUNTILDATE VALIDUNTILDATE_ISOA3,
T7.IDSYMBOL RESTRICTLOCATIONISON,
T7.VALIDFROMDATE VALIDFROMDATE_ISON,
T7.VALIDUNTILDATE VALIDUNTILDATE_ISON,
T8.IDSYMBOL RESTRICTLOCATIONTKN,
T8.VALIDFROMDATE VALIDFROMDATE_TKN,
T8.VALIDUNTILDATE VALIDUNTILDATE_TKN,
T9.IDSYMBOL RESTRICTLOCATIONCS,
T9.VALIDFROMDATE VALIDFROMDATE_CS,
T9.VALIDUNTILDATE VALIDUNTILDATE_CS
FROM VDPS2.VTINSTRFLATSYMBOLS T1
INNER JOIN
VDPS2.VTINSTRFLATDATA T2
ON T2.INSTRUMENTID = T1.INSTRUMENTID
INNER JOIN
VDPS2.VTINSTRRESTRICTION T3
ON T3.INSTRUMENTID = T2.INSTRUMENTID
LEFT OUTER JOIN
VDPS2.VTRESTRICTIONSUSP T4
ON T4.INSTRUMENTID = T3.INSTRUMENTID AND T4.
INSTRRESTRICTIONNO = T3.INSTRRESTRICTIONNO
LEFT OUTER JOIN
VDPS2.VTGEOUNITIDENT T5
ON T5.GEOUNITID = T3.RESTRICTLOCATION AND T5.SCHEMESYMBOL
= 'ISOA2' AND T5.ROWSTATUS = 1
LEFT OUTER JOIN
VDPS2.VTGEOUNITIDENT T6
ON T6.GEOUNITID = T3.RESTRICTLOCATION AND T6.SCHEMESYMBOL
= 'ISOA3' AND T6.ROWSTATUS = 1
LEFT OUTER JOIN
VDPS2.VTGEOUNITIDENT T7
ON T7.GEOUNITID = T3.RESTRICTLOCATION AND T7.SCHEMESYMBOL
= 'ISON' AND T7.ROWSTATUS = 1
LEFT OUTER JOIN
VDPS2.VTGEOUNITIDENT T8
ON T8.GEOUNITID = T3.RESTRICTLOCATION AND T8.SCHEMESYMBOL
= 'TKN' AND T8.ROWSTATUS = 1
LEFT OUTER JOIN
VDPS2.VTGEOUNITIDENT T9
ON T9.GEOUNITID = T3.RESTRICTLOCATION AND T9.SCHEMESYMBOL
= 'CS-WS80-DOM' AND T9.ROWSTATUS = 1 ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.IDS_VRSTR114 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_VRSTR114 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_VRSTR114 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_VRSTR114 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.IDS_VRSTR114 TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.IDS_VRSTR114 FOR VDPS2.IDS_VRSTR114 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPS2.VVV_IDS_VCFTU106
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
CREATE VIEW VDPS2.VVV_IDS_VCFTU106 AS
SELECT T1.INSTRUMENTID, T1.SYMBOLCH, T1.SYMBOLISIN, T1.SYMBOLUS,
T1.SYMBOLXS, T1.SYMBOLGB, T1.SYMBOLLU, T1.SYMBOLDE,
T1.SYMBOLI2, T1.SYMBOLI1, T1.SYMBOLT1, T1.SYMBOLT2,
T1.SYMBOLCSFI, T1.SYMBOLCSCURR, T1.CATEGORYVDPS,
T1.CATEGORYTKT, T1.CATEGORYEUZS,
T1.INSTRUMENTUPDATETIMESTAMP, T1.INSTRUMENTCREATETIMESTAMP,
T2.INSTRUMENTEVENTNO, T3.EXDATE, T4.CFAMOUNTTYPE,
T4.PAYAMOUNT, T5.RELEVANTDATE, T6.SYMBOLI2 PAYINSTRUMENT
FROM VDPS2.VTINSTRFLATSYMBOLS T1
INNER JOIN
VDPS2.VTINSTRUMENTEVENT T2
ON T2.INSTRUMENTID = T1.INSTRUMENTID AND T2.PROVIDERTYPE =
2
INNER JOIN
VDPS2.VTINSTREVENTEXDATE T3
ON T2.INSTRUMENTID = T3.INSTRUMENTID AND T2.
INSTRUMENTEVENTNO = T3.INSTRUMENTEVENTNO
INNER JOIN
VDPS2.VTCASHFLOWAMOUNT T4
ON T4.INSTRUMENTID = T3.INSTRUMENTID AND T4.
INSTRUMENTEVENTNO = T3.INSTRUMENTEVENTNO AND T4.
CFAMOUNTTYPE IN(10064, 10072)
INNER JOIN
VDPS2.VTCASHFLOWTAXAMT T5
ON T2.INSTRUMENTID = T5.INSTRUMENTID AND T2.
INSTRUMENTEVENTNO = T5.INSTRUMENTEVENTNO AND T5.
RELEVANTDATE >= '20090101'
LEFT OUTER JOIN
VDPS2.VTINSTRFLATSYMBOLS T6
ON T6.INSTRUMENTID = T4.PAYINSTRUMENT
WHERE T2.INSTRUMENTEVENTNO IN(SELECT T7.INSTRUMENTEVENTNO
FROM VDPS2.VTCASHFLOWTAXAMT T7
WHERE
T7.RELEVANTDATE >= '20090101'
AND T7.INSTRUMENTID = T2.
INSTRUMENTID) ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.VVV_IDS_VCFTU106 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.VVV_IDS_VCFTU106 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.VVV_IDS_VCFTU106 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.VVV_IDS_VCFTU106 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.VVV_IDS_VCFTU106 TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.VVV_IDS_VCFTU106 FOR VDPS2.VVV_IDS_VCFTU106 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=VDPS2.VVV_IDS_VINGP108
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
CREATE VIEW VDPS2.VVV_IDS_VINGP108 AS
SELECT T1.INSTRUMENTID, T1.ROWSTATUS ROWSTATUS_FLTSYMB,
T1.CSSTATUSTYPE, T1.STATUSTYPE, T1.SYMBOLCH, T1.SYMBOLISIN,
T1.SYMBOLUS, T1.SYMBOLXS, T1.SYMBOLGB, T1.SYMBOLLU,
T1.SYMBOLDE, T1.SYMBOLI2, T1.SYMBOLI1, T1.SYMBOLT1,
T1.SYMBOLT2, T1.SYMBOLCSFI, T1.SYMBOLCSCURR,
T1.CATEGORYVDPS, T1.CATEGORYTKT, T1.CATEGORYEUZS,
T1.INSTRUMENTUPDATETIMESTAMP, T1.INSTRUMENTCREATETIMESTAMP,
T2.PAYFREQUENCY, T2.EXERCISEAMOUNT, T2.PAYAMOUNT,
T2.ISCONVERTBYISSUER, T2.HASVOTINGRIGHTNO,
T2.HASMULTIUNDERLYERS, T2.CSMAINTRADPLACE,
T2.ORIGINALISSUER, T2.ISSUER, T2.UNDERINSTRUMENT,
T2.NOMINALCURR, T2.NOMINALCURR_I1, T2.NOMINALCURR_I2,
T2.NOMINALCURR_WS80, T2.CSRISKCURRENCY, T2.EXERCISECURR,
T2.POOLFACTOR, T2.VOTINGRIGHTNO, T2.OUTSTANDINGCAPITAL,
T2.CSRISKINDIDSYMBOL, T2.CSRISKINDSCHEMESYM, T2.MDYRATING,
T2.SPRATING, T2.PAYMENTDATE, T2.UNITTYPE, T2.CSUNITTYPE,
T2.CSFUNDTYPE, T2.HASWITHHOLDINGTAX, T2.OPTIONSTYLETYPE,
T2.NAME35_G, T2.NAME45_G, T2.SHORTNAME_G, T2.PREPARTICLE_G,
T2.POSTPARTICLE_G, T2.EFFECTIVEDATE, T2.BORROWINGLIMITTYPE,
T3.INSTRINGROUPNO, T3.IDSYMBOL IDSYMBOL_IGK,
T3.SCHEMESYMBOL SCHEMESYMBOL_IGK, T3.QUALITYTYPE,
T3.PROVIDER1ID, T3.PROVIDER2ID, T3.PROVIDER3ID,
T4.INSTRGROUPID, T4.HISTORYID, T4.INSTRGROUPTYPE,
T4.ROWSTATUS, T4.VSTQUALITY, T4.REVISIONNO,
T4.VSTREQUIREDQUALITY, T4.VSTMAXIMUMQUALITY,
T4.HASPENDINGACTVTY, T4.ISRELEVANT, T4.HASFUTUREMESSAGES,
T4.FOTWIZISDISABLED, T4.ISONDB, T4.IDSYMBOL IDSYMBOL_IG,
T4.SCHEMESYMBOL SCHEMESYMBOL_IG, T4.NAME_G, T4.NAME_E,
T4.NAME_F, T4.NAME_I, T4.NAME_N, T4.VSTNAME, T4.VSTVERSION,
T4.CREATEUSERID, T4.UPDATEUSERID, T4.PROVIDER1SYMBOL,
T4.PROVIDER2SYMBOL, T4.PROVIDER3SYMBOL, T4.VALIDUNTILDATE,
T4.VALIDFROMDATE, T4.FOTYPE FOTYPE_IG, T4.DATASTATUSTYPE,
T4.BLOCKINGCODETYPE, T4.LOGICDELETIONTYPE,
T4.MODIFICATIONREASON, T4.REMARKS, T4.DESCRIPTION_G,
T4.DESCRIPTION_E, T4.DESCRIPTION_F, T4.DESCRIPTION_I,
T4.DESCRIPTION_N, T4.DOWRITETOSHADOWTABLES
FROM VDPS2.VTINSTRFLATSYMBOLS T1
INNER JOIN
VDPS2.VTINSTRFLATDATA T2
ON T2.INSTRUMENTID = T1.INSTRUMENTID
INNER JOIN
VDPS2.VTINSTRINGROUP T3
ON T3.INSTRUMENTID = T2.INSTRUMENTID
INNER JOIN
VDPS2.VTINSTRGROUP T4
ON T4.IDSYMBOL = T3.IDSYMBOL AND T4.SCHEMESYMBOL = T3.
SCHEMESYMBOL ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.VVV_IDS_VINGP108 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.VVV_IDS_VINGP108 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.VVV_IDS_VINGP108 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.VVV_IDS_VINGP108 TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.VVV_IDS_VINGP108 FOR VDPS2.VVV_IDS_VINGP108 ;
--
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_VINDE007_V01
------------------------------------------------------------------------
--
SET CURRENT SQLID='VDPS2';
--
--
CREATE VIEW VDPS2.VVV_XPS_VINDE007_V01 AS
SELECT T1.IDSYMBOL, T1.SCHEMESYMBOL, T1.INSTRUMENTID,
T3.CREATETIMESTAMP, T3.UPDATETIMESTAMP,
T3.ISCSMIFIDCOMPLEX, T3.CSPRODUCTCATEGORY
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.CTINSTRDETAILS T3
ON T3.INSTRUMENTID = T1.INSTRUMENTID
WHERE T1.ROWSTATUS = 1 ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE VDPS2.VVV_XPS_VINDE007_V01 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.VVV_XPS_VINDE007_V01 TO VDPS2;
--
GRANT SELECT ON TABLE VDPS2.VVV_XPS_VINDE007_V01 TO VDPS2;
--
SET CURRENT SQLID='VDPS';
--
CREATE ALIAS VDPS.VVV_XPS_VINDE007_V01 FOR VDPS2.VVV_XPS_VINDE007_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;
--
------------------------------------------------------------------------
-- ADB2GEN - End of generated DDL --
------------------------------------------------------------------------
--