zOs/SQL/VDPSMQT2
-- STATIC NO MQTNIDHI 31.8 00010013
-- from ORG.U0009.B0106.KAXV3.SQL(SCATVDPS) 00020013
set current sqlid = 'A540769'; 00030013
DELETE FROM PLAN_TABLE; 00040013
-- EXPLAIN ALL SET QUERYNO=300 FOR 00050016
SELECT count(*), fs.symbolch, 00060019
FD.INSTRUMENTID, FD.PAYFREQUENCY, 00061017
FD.CREATETIMESTAMP CREATETIMESTAMP_FD, 00070013
FD.UPDATETIMESTAMP UPDATETIMESTAMP_FD, 00080013
FD.ISCALLFORTXREONLY, FD.ISREDEEMABLE, FD.ISRETRACTABLE, 00090013
FD.ISCONVERTBYHOLDER, FD.ISCONVERTBYISSUER, 00100013
FD.HASVOTINGRIGHTNO, FD.HASREDMPINVARCURR, 00110013
FD.HASMULTIUNDERLYERS, FD.CSMAINTRADPLACE, 00120013
FD.ORIGINALISSUER, FD.ISSUER, FD.UNDERINSTRUMENT, 00130013
FD.NOMINALCURR, FD.CSRISKCURRENCY, FD.CSRISKCOUNTRY, 00140013
FD.CSRISINSTRUMENT, FD.REPAYPRICECURR, FD.ISSUEPRICECURR, 00150013
FD.EXERCISECURR, FD.MAINDEPOSITARY, FD.NOMINALAMOUNT, 00160013
FD.MINDENOMINATION, FD.EFFINTERESTRATE, 00170013
FD.REPAYPRICEAMOUNT, FD.REPAYPRICERATE, FD.POOLFACTOR, 00180013
FD.VOTINGRIGHTNO, FD.OUTSTANDINGCAPITAL, FD.ISSUEDCAPITAL, 00190013
FD.OUTSTANDCAPITALNO, FD.ISSUEDCAPITALNO, FD.ISSUEAMOUNT, 00200013
FD.ISSUEPRICE, FD.EXERCISEAMOUNT, FD.MINEXERCISEAMOUNT, 00210013
FD.HELDAMOUNT, FD.PAYAMOUNT, FD.INCOMETAXRATE, 00220013
FD.PREMIUMRATE, FD.PARTICIPATIONRATE, FD.REBATE, 00230013
FD.CSRATING, FD.CSRISKINDIDSYMBOL, FD.CSRISKINDSCHEMESYM, 00240013
FD.CSRISKINSTGRPIDSYM, FD.CSRISKINSGRPSCHSYM, FD.MDYRATING, 00250013
FD.SPRATING, FD.LISTINGSYMBOLTKH, FD.LISTINGSYMBOLRIC, 00260013
FD.LISTINGSYMBOLBBI, NCUR.SYMBOLI1 NOMINALCURR_I1, 00270013
NCUR.SYMBOLI2 NOMINALCURR_I2, 00280013
NCUR.SYMBOLCSCURR NOMINALCURR_WS80, 00290013
RCUR.SYMBOLI1 CSRISKCURRENCY_I1, 00300013
RCUR.SYMBOLI2 CSRISKCURRENCY_I2, 00310013
RCUR.SYMBOLCSCURR CSRISKCURRENCY_WS80, 00320013
RINS.SYMBOLCH CSRISINSTRUMENT_CH, 00330013
RINS.SYMBOLISIN CSRISINSTRUMENT_ISIN, 00340013
RINS.SYMBOLCSFI CSRISINSTRUMENT_CSFI, 00350013
RCTY.SYMBOLISOA2 CSRISKCOUNTRY_A2, 00360013
RCTY.SYMBOLCSWS80DOM CSRISKCOUNTRY_WS80, 00370013
PCUR.SYMBOLI1 REPAYPRICECURR_I1, 00380013
PCUR.SYMBOLI2 REPAYPRICECURR_I2, 00390013
PCUR.SYMBOLCSCURR REPAYPRICECURR_WS80, 00400013
ICUR.SYMBOLI1 ISSUEPRICECURR_I1, 00410013
ICUR.SYMBOLI2 ISSUEPRICECURR_I2, 00420013
ICUR.SYMBOLCSCURR ISSUEPRICECURR_WS80, 00430013
ECUR.SYMBOLI1 EXERCISECURR_I1, 00440013
ECUR.SYMBOLI2 EXERCISECURR_I2, 00450013
ECUR.SYMBOLCSCURR EXERCISECURR_WS80, 00460013
MBPL.SYMBOLBCN CSMAINTRADPLACE_BCN, 00470013
MBPL.SYMBOLCSWS80BPL CSMAINTRADPLACE_WS80, 00480013
MBPL.SYMBOLRTX CSMAINTRADPLACE_RTX, 00490013
MBPL.SYMBOLBBX CSMAINTRADPLACE_BBX, 00500013
UINS.SYMBOLCH UNDERINSTRUMENT_CH, 00510013
UINS.SYMBOLISIN UNDERINSTRUMENT_ISIN, 00520013
UINS.SYMBOLCSFI UNDERINSTRUMENT_CSFI, FD.ORIGINALISSUER_GK, 00530013
FD.ISSUER_GK, FD.MAINDEPOSITARY_GK, FD.EXPIRATIONDATE, 00540013
FD.MATURITYDATE, FD.FIRSTPAYDATE, FD.FIRSTPYDATEPERYEAR, 00550013
FD.INTRSTDVDENFRDATE, FD.CSRATINGDATE, FD.MDYRATINGDATE, 00560013
FD.SPRATINGDATE, FD.SUBSCRBEGINDATE, FD.PAYMENTDATE, 00570013
FD.EXERCISEBEGINDATE, FD.SUBSCRPLNDENDDATE, 00580013
FD.EXERCISEENDDATE, FD.BVGTYPE, FD.CREDITWORTHINESSTP, 00590013
FD.COMMISSIONCODETYPE, FD.UNITTYPE, FD.CSUNITTYPE, 00600013
FD.EXPIRATIONTYPE, FD.STATUSTYPE STATUSTYPE_FD, 00610013
FD.REGISTRATIONTYPE, FD.BORROWERCATTYPE, 00620013
FD.CSLISTINGCODETYPE, FD.CSSTATUSTYPE CSSTATUSTYPE_FD, 00630013
FD.STATUSDETAILTYPE, FD.INCOMEMODETYPE, 00640013
FD.INTERESTCALCTYPE, FD.INTERESTTYPE, FD.PYFREQUNITTYPE, 00650013
FD.SUBSCRMETHODTYPE, FD.PLACEMENTTYPE, FD.PAYDIRECTIONTYPE, 00660013
FD.OPTIONTYPE, FD.SETTLESTYLETYPE, FD.CSFUNDTYPE, 00670013
FD.TRADINGSTATUSTYPE, FD.LISTINGSTATUSTYPE, 00680013
FD.EXERCISEPLACE, FD.NAME35_G, FD.NAME35_E, FD.NAME35_F, 00690013
FD.NAME35_I, FD.NAME35_N, FD.NAME45_G, FD.NAME45_E, 00700013
FD.NAME45_F, FD.NAME45_I, FD.NAME45_N, FD.SHORTNAME_G, 00710013
FD.SHORTNAME_E, FD.SHORTNAME_F, FD.SHORTNAME_I, 00720013
FD.SHORTNAME_N, FD.PREPARTICLE_G, FD.PREPARTICLE_E, 00730013
FD.PREPARTICLE_F, FD.PREPARTICLE_I, FD.PREPARTICLE_N, 00740013
FD.POSTPARTICLE_G, FD.POSTPARTICLE_E, FD.POSTPARTICLE_F, 00750013
FD.POSTPARTICLE_I, FD.POSTPARTICLE_N, FD.ISINTERNAL, 00760013
FD.ISOTC, FD.HASWITHHOLDINGTAX, FD.HASFEDERALSTAMPDUTY, 00770013
FD.ISCSMIFIDCOMPLEX, FD.MOSTLIQUIDMARKETLOCATION, 00780013
MLOC.SYMBOLISOA2 MOSTLIQUIDMARKETLOCATION_A2, 00790013
MLOC.SYMBOLISOA3 MOSTLIQUIDMARKETLOCATION_A3, 00800013
MLOC.SYMBOLCSWS80DOM MOSTLIQUIDMARKETLOCATION_WS80, 00810013
FD.MDYWATCHLISTSTATUSTYPE, FD.SPWATCHLISTSTATUSTYPE, 00820013
FD.OPTIONSTYLETYPE, FD.CSMAINTRADINGCURR, 00830013
TCUR.SYMBOLI1 CSMAINTRADINGCURR_I1, 00840013
TCUR.SYMBOLI2 CSMAINTRADINGCURR_I2, 00850013
TCUR.SYMBOLCSCURR CSMAINTRADINGCURR_WS80, 00860013
RCTY.SYMBOLISOA3 CSRISKCOUNTRY_A3, FD.LIQUIDATIONRIGHTTYPE, 00870013
FD.CSMAINPARENTTRADINGPLACE, 00880013
IFS.SYMBOLBCN CSMAINPARENTTRADINGPLACE_BCN, 00890013
IFS.SYMBOLRTX CSMAINPARENTTRADINGPLACE_RTX, 00900013
IFS.SYMBOLMIC CSMAINPARENTTRADINGPLACE_MIC, 00910013
IFS.SYMBOLBBX CSMAINPARENTTRADINGPLACE_BBX, 00920013
IFS.SYMBOLCSWS80BPL CSMAINPARENTTRADINGPLACE_WS80, 00930013
FD.ISMANAGEDBYCS, FD.EVENTFUNCTIONTYPE, 00940013
FD.MAINLANGUAGETYPE, FD.EFFECTIVEDATE, 00950013
FS.CREATETIMESTAMP CREATETIMESTAMP_FS, 00960013
FS.UPDATETIMESTAMP UPDATETIMESTAMP_FS, FS.ROWSTATUS, 00970013
FS.SYMBOLCSFI, FS.SYMBOLCH, FS.SYMBOLISIN, FS.SYMBOLUS, 00980013
FS.SYMBOLXS, FS.SYMBOLGB, FS.SYMBOLLU, FS.SYMBOLDE, 00990013
FS.SYMBOLAT, FS.SYMBOLFR, FS.SYMBOLBE, FS.SYMBOLIT, 01000013
FS.SYMBOLNL, FS.SYMBOLJP, FS.SYMBOLJ2, FS.SYMBOLDK, 01010013
FS.SYMBOLSE, FS.SYMBOLI2, FS.SYMBOLI1, FS.SYMBOLT1, 01020013
FS.SYMBOLT2, FS.SYMBOLCSCURR, FS.CATEGORYVDPS, 01030013
FS.CATEGORYTKT, FS.CATEGORYTKSK, FS.CATEGORYTKZUS, 01040013
FS.CATEGORYTKPRK, FS.CATEGORYTKTZ, FS.CATEGORYMAZU, 01050013
FS.CATEGORYECBTR, FS.CATEGORYCFI, FS.CATEGORYEUZS, 01060013
FS.CATEGORYCSGTA, FS.CATEGORYCSGMS, FS.CATEGUSTAXREPORT, 01070013
FS.CATEGUSIRSADDITION, FS.CSSTATUSTYPE CSSTATUSTYPE_FS, 01080013
FS.STATUSTYPE STATUSTYPE_FS, FS.SYMBOLSPIRIT, 01090013
INS.CREATETIMESTAMP CREATETIMESTAMP_INSTR, 01100013
INS.UPDATETIMESTAMP UPDATETIMESTAMP_INSTR 01110013
FROM VDPS2.VTINSTRFLATDATA FD 01120013
INNER JOIN 01130013
VDPS2.VTINSTRFLATSYMBOLS FS 01140013
ON FS.INSTRUMENTID = FD.INSTRUMENTID 01150013
INNER JOIN 01160013
VDPS2.VTINSTRUMENT INS 01170013
ON INS.INSTRUMENTID = FD.INSTRUMENTID 01180013
LEFT OUTER JOIN 01190013
VDPS2.VTINSTIFLATSYMBOLS IFS 01200013
ON (IFS.INSTITUTIONID = FD.CSMAINPARENTTRADINGPLACE 01210013
AND IFS.CATEGORYVDPS = '104') 01220013
LEFT OUTER JOIN 01230013
VDPS2.VTINSTRFLATSYMBOLS TCUR 01240013
ON (TCUR.INSTRUMENTID = FD.CSMAINTRADINGCURR 01250013
AND TCUR.CATEGORYVDPS = '10') 01260013
LEFT OUTER JOIN 01270013
VDPS2.VTINSTIFLATSYMBOLS MBPL 01280013
ON (MBPL.INSTITUTIONID = FD.CSMAINTRADPLACE 01290013
AND MBPL.CATEGORYVDPS = '104') 01300013
LEFT OUTER JOIN 01310013
VDPS2.VTINSTRFLATSYMBOLS RINS 01320013
ON RINS.INSTRUMENTID = FD.CSRISINSTRUMENT 01330013
LEFT OUTER JOIN 01340013
OA1A.TVV_VTGEOUNITFLATSYMBOLS RCTY 01350013
ON RCTY.GEOUNITID = FD.CSRISKCOUNTRY 01360013
LEFT OUTER JOIN 01370013
VDPS2.VTINSTRFLATSYMBOLS RCUR 01380013
ON (RCUR.INSTRUMENTID = FD.CSRISKCURRENCY 01390013
AND RCUR.CATEGORYVDPS = '10') 01400013
LEFT OUTER JOIN 01410013
VDPS2.VTINSTRFLATSYMBOLS ECUR 01420013
ON (ECUR.INSTRUMENTID = FD.EXERCISECURR 01430013
AND ECUR.CATEGORYVDPS = '10') 01440013
LEFT OUTER JOIN 01450013
VDPS2.VTINSTRFLATSYMBOLS ICUR 01460013
ON (ICUR.INSTRUMENTID = FD.ISSUEPRICECURR 01470013
AND ICUR.CATEGORYVDPS = '10') 01480013
LEFT OUTER JOIN 01490013
OA1A.TVV_VTGEOUNITFLATSYMBOLS MLOC 01500013
ON MLOC.GEOUNITID = FD.MOSTLIQUIDMARKETLOCATION 01510013
LEFT OUTER JOIN 01520013
VDPS2.VTINSTRFLATSYMBOLS NCUR 01530013
ON (NCUR.INSTRUMENTID = FD.NOMINALCURR 01540013
AND NCUR.CATEGORYVDPS = '10') 01550013
LEFT OUTER JOIN 01560013
VDPS2.VTINSTRFLATSYMBOLS PCUR 01570013
ON (PCUR.INSTRUMENTID = FD.REPAYPRICECURR 01580013
AND PCUR.CATEGORYVDPS = '10') 01590013
LEFT OUTER JOIN 01600013
VDPS2.VTINSTRFLATSYMBOLS UINS 01610013
ON UINS.INSTRUMENTID = FD.UNDERINSTRUMENT 01620013
WHERE FS.ROWSTATUS = 1 01630013
-- AND FS.SYMBOLCH = '1213853'; 01640017
fetch first 1000 rows only ; 01641017
select * from plan_view2 01650013
order by applname, progname, queryNo, qblockno, planno 01660013
; 01670013
rollback 01680013
;x; 01690013
******************* 01700013
-- STATIC NO MQTNIDHI 26.8 01710001
-- ORG.U0009.B0106.KAXV3.SQL(DYNNOMQT) -WITHOUT MQT 01720001
-- OMEGAMON OBJECT ANALYSIS 01730001
-- MQT TRADINGPLACE VTINSTIFLATSYMBOLS, CATEGORY 104 --> VDPS029 01740001
-- MQT CURRENCY VTINSTIFLATSYMBOLS, CATEGORY 10 --> VDPS029 01750001
--- DATABASE SPACENAM DSN VOLUME GETPAGE READ SEQ L01760001
--- -------- -------- --- ------ ------- ------- ------- ---01770001
--- VV21A1A VDPS004 001 B11272 2117 33 0 01780001
--- VV21A1A VDPS026 001 B1N239 10605 9 0 01790001
--- VV21A1A VDPS026 002 B12780 29 3 0 01800001
--- VV21A1A VDPS029 001 B11548 2199 6 0 01810001
--- VV21A1A VTXINSTI 001 B12748 2420 6 0 01820001
--- VV21A1A VTXINSTR 001 B11097 897 0 0 01830001
--- VV21A1A VTXI1GZ2 001 B11303 1000 18 0 01840001
--- VV22A1A VDPS051 001 144 0 0 01850001
--- VV24A1A VDPS168 001 B10450 3066 8 0 01860001
--- VV24A1A VDPS168 003 B11277 5 5 0 01870001
--- VV24A1A VDPS168 004 B1N826 1 1 0 01880001
--- VV24A1A VDPS168 010 B12922 20 6 0 01890001
--- VV24A1A VTXI19IG 001 B10459 897 0 0 01900001
--- WKDBDAF3 DSN32K08 001 B11469 14630 1 0 01910001
--- WKDBDAF3 DSN4K01 001 518 0 0 01920001
--- WKDBDAF3 DSN4K07 001 199 0 0 01930001
set current sqlid = 'A540769'; 01940002
delete from plan_table; 01950002
explain plan set queryno = 2 for 01960011
SELECT FD.INSTRUMENTID, FD.PAYFREQUENCY, 01970002
FD.CREATETIMESTAMP CREATETIMESTAMP_FD, 01980002
FD.UPDATETIMESTAMP UPDATETIMESTAMP_FD, 01990002
FD.ISCALLFORTXREONLY, FD.ISREDEEMABLE, FD.ISRETRACTABLE, 02000002
FD.ISCONVERTBYHOLDER, FD.ISCONVERTBYISSUER, 02010002
FD.HASVOTINGRIGHTNO, FD.HASREDMPINVARCURR, 02020002
FD.HASMULTIUNDERLYERS, FD.CSMAINTRADPLACE, 02030002
FD.ORIGINALISSUER, FD.ISSUER, FD.UNDERINSTRUMENT, 02040002
FD.NOMINALCURR, FD.CSRISKCURRENCY, FD.CSRISKCOUNTRY, 02050002
FD.CSRISINSTRUMENT, FD.REPAYPRICECURR, FD.ISSUEPRICECURR, 02060002
FD.EXERCISECURR, FD.MAINDEPOSITARY, FD.NOMINALAMOUNT, 02070002
FD.MINDENOMINATION, FD.EFFINTERESTRATE, 02080002
FD.REPAYPRICEAMOUNT, FD.REPAYPRICERATE, FD.POOLFACTOR, 02090002
FD.VOTINGRIGHTNO, FD.OUTSTANDINGCAPITAL, FD.ISSUEDCAPITAL, 02100002
FD.OUTSTANDCAPITALNO, FD.ISSUEDCAPITALNO, FD.ISSUEAMOUNT, 02110002
FD.ISSUEPRICE, FD.EXERCISEAMOUNT, FD.MINEXERCISEAMOUNT, 02120002
FD.HELDAMOUNT, FD.PAYAMOUNT, FD.INCOMETAXRATE, 02130002
FD.PREMIUMRATE, FD.PARTICIPATIONRATE, FD.REBATE, 02140002
FD.CSRATING, FD.CSRISKINDIDSYMBOL, FD.CSRISKINDSCHEMESYM, 02150002
FD.CSRISKINSTGRPIDSYM, FD.CSRISKINSGRPSCHSYM, FD.MDYRATING, 02160002
FD.SPRATING, FD.LISTINGSYMBOLTKH, FD.LISTINGSYMBOLRIC, 02170002
FD.LISTINGSYMBOLBBI, NCUR.SYMBOLI1 NOMINALCURR_I1, 02180002
NCUR.SYMBOLI2 NOMINALCURR_I2, 02190002
NCUR.SYMBOLCSCURR NOMINALCURR_WS80, 02200002
RCUR.SYMBOLI1 CSRISKCURRENCY_I1, 02210002
RCUR.SYMBOLI2 CSRISKCURRENCY_I2, 02220002
RCUR.SYMBOLCSCURR CSRISKCURRENCY_WS80, 02230002
RINS.SYMBOLCH CSRISINSTRUMENT_CH, 02240002
RINS.SYMBOLISIN CSRISINSTRUMENT_ISIN, 02250002
RINS.SYMBOLCSFI CSRISINSTRUMENT_CSFI, 02260002
RCTY.SYMBOLISOA2 CSRISKCOUNTRY_A2, 02270002
RCTY.SYMBOLCSWS80DOM CSRISKCOUNTRY_WS80, 02280002
PCUR.SYMBOLI1 REPAYPRICECURR_I1, 02290002
PCUR.SYMBOLI2 REPAYPRICECURR_I2, 02300002
PCUR.SYMBOLCSCURR REPAYPRICECURR_WS80, 02310002
ICUR.SYMBOLI1 ISSUEPRICECURR_I1, 02320002
ICUR.SYMBOLI2 ISSUEPRICECURR_I2, 02330002
ICUR.SYMBOLCSCURR ISSUEPRICECURR_WS80, 02340002
ECUR.SYMBOLI1 EXERCISECURR_I1, 02350002
ECUR.SYMBOLI2 EXERCISECURR_I2, 02360002
ECUR.SYMBOLCSCURR EXERCISECURR_WS80, 02370002
MBPL.SYMBOLBCN CSMAINTRADPLACE_BCN, 02380002
MBPL.SYMBOLCSWS80BPL CSMAINTRADPLACE_WS80, 02390002
MBPL.SYMBOLRTX CSMAINTRADPLACE_RTX, 02400002
MBPL.SYMBOLBBX CSMAINTRADPLACE_BBX, 02410002
UINS.SYMBOLCH UNDERINSTRUMENT_CH, 02420002
UINS.SYMBOLISIN UNDERINSTRUMENT_ISIN, 02430002
UINS.SYMBOLCSFI UNDERINSTRUMENT_CSFI, FD.ORIGINALISSUER_GK, 02440002
FD.ISSUER_GK, FD.MAINDEPOSITARY_GK, FD.EXPIRATIONDATE, 02450002
FD.MATURITYDATE, FD.FIRSTPAYDATE, FD.FIRSTPYDATEPERYEAR, 02460002
FD.INTRSTDVDENFRDATE, FD.CSRATINGDATE, FD.MDYRATINGDATE, 02470002
FD.SPRATINGDATE, FD.SUBSCRBEGINDATE, FD.PAYMENTDATE, 02480002
FD.EXERCISEBEGINDATE, FD.SUBSCRPLNDENDDATE, 02490002
FD.EXERCISEENDDATE, FD.BVGTYPE, FD.CREDITWORTHINESSTP, 02500002
FD.COMMISSIONCODETYPE, FD.UNITTYPE, FD.CSUNITTYPE, 02510002
FD.EXPIRATIONTYPE, FD.STATUSTYPE STATUSTYPE_FD, 02520002
FD.REGISTRATIONTYPE, FD.BORROWERCATTYPE, 02530002
FD.CSLISTINGCODETYPE, FD.CSSTATUSTYPE CSSTATUSTYPE_FD, 02540002
FD.STATUSDETAILTYPE, FD.INCOMEMODETYPE, 02550002
FD.INTERESTCALCTYPE, FD.INTERESTTYPE, FD.PYFREQUNITTYPE, 02560002
FD.SUBSCRMETHODTYPE, FD.PLACEMENTTYPE, FD.PAYDIRECTIONTYPE, 02570002
FD.OPTIONTYPE, FD.SETTLESTYLETYPE, FD.CSFUNDTYPE, 02580002
FD.TRADINGSTATUSTYPE, FD.LISTINGSTATUSTYPE, 02590002
FD.EXERCISEPLACE, FD.NAME35_G, FD.NAME35_E, FD.NAME35_F, 02600002
FD.NAME35_I, FD.NAME35_N, FD.NAME45_G, FD.NAME45_E, 02610002
FD.NAME45_F, FD.NAME45_I, FD.NAME45_N, FD.SHORTNAME_G, 02620002
FD.SHORTNAME_E, FD.SHORTNAME_F, FD.SHORTNAME_I, 02630002
FD.SHORTNAME_N, FD.PREPARTICLE_G, FD.PREPARTICLE_E, 02640002
FD.PREPARTICLE_F, FD.PREPARTICLE_I, FD.PREPARTICLE_N, 02650002
FD.POSTPARTICLE_G, FD.POSTPARTICLE_E, FD.POSTPARTICLE_F, 02660002
FD.POSTPARTICLE_I, FD.POSTPARTICLE_N, FD.ISINTERNAL, 02670002
FD.ISOTC, FD.HASWITHHOLDINGTAX, FD.HASFEDERALSTAMPDUTY, 02680002
FD.ISCSMIFIDCOMPLEX, FD.MOSTLIQUIDMARKETLOCATION, 02690002
MLOC.SYMBOLISOA2 MOSTLIQUIDMARKETLOCATION_A2, 02700002
MLOC.SYMBOLISOA3 MOSTLIQUIDMARKETLOCATION_A3, 02710002
MLOC.SYMBOLCSWS80DOM MOSTLIQUIDMARKETLOCATION_WS80, 02720002
FD.MDYWATCHLISTSTATUSTYPE, FD.SPWATCHLISTSTATUSTYPE, 02730002
FD.OPTIONSTYLETYPE, FD.CSMAINTRADINGCURR, 02740002
TCUR.SYMBOLI1 CSMAINTRADINGCURR_I1, 02750002
TCUR.SYMBOLI2 CSMAINTRADINGCURR_I2, 02760002
TCUR.SYMBOLCSCURR CSMAINTRADINGCURR_WS80, 02770002
RCTY.SYMBOLISOA3 CSRISKCOUNTRY_A3, FD.LIQUIDATIONRIGHTTYPE, 02780002
FD.CSMAINPARENTTRADINGPLACE, 02790002
IFS.SYMBOLBCN CSMAINPARENTTRADINGPLACE_BCN, 02800002
IFS.SYMBOLRTX CSMAINPARENTTRADINGPLACE_RTX, 02810002
IFS.SYMBOLMIC CSMAINPARENTTRADINGPLACE_MIC, 02820002
IFS.SYMBOLBBX CSMAINPARENTTRADINGPLACE_BBX, 02830002
IFS.SYMBOLCSWS80BPL CSMAINPARENTTRADINGPLACE_WS80, 02840002
FD.ISMANAGEDBYCS, FD.EVENTFUNCTIONTYPE, 02850002
FD.MAINLANGUAGETYPE, FD.EFFECTIVEDATE, 02860002
FS.CREATETIMESTAMP CREATETIMESTAMP_FS, 02870002
FS.UPDATETIMESTAMP UPDATETIMESTAMP_FS, FS.ROWSTATUS, 02880002
FS.SYMBOLCSFI, FS.SYMBOLCH, FS.SYMBOLISIN, FS.SYMBOLUS, 02890002
FS.SYMBOLXS, FS.SYMBOLGB, FS.SYMBOLLU, FS.SYMBOLDE, 02900002
FS.SYMBOLAT, FS.SYMBOLFR, FS.SYMBOLBE, FS.SYMBOLIT, 02910002
FS.SYMBOLNL, FS.SYMBOLJP, FS.SYMBOLJ2, FS.SYMBOLDK, 02920002
FS.SYMBOLSE, FS.SYMBOLI2, FS.SYMBOLI1, FS.SYMBOLT1, 02930002
FS.SYMBOLT2, FS.SYMBOLCSCURR, FS.CATEGORYVDPS, 02940002
FS.CATEGORYTKT, FS.CATEGORYTKSK, FS.CATEGORYTKZUS, 02950002
FS.CATEGORYTKPRK, FS.CATEGORYTKTZ, FS.CATEGORYMAZU, 02960002
FS.CATEGORYECBTR, FS.CATEGORYCFI, FS.CATEGORYEUZS, 02970002
FS.CATEGORYCSGTA, FS.CATEGORYCSGMS, FS.CATEGUSTAXREPORT, 02980002
FS.CATEGUSIRSADDITION, FS.CSSTATUSTYPE CSSTATUSTYPE_FS, 02990002
FS.STATUSTYPE STATUSTYPE_FS, FS.SYMBOLSPIRIT, 03000002
INS.CREATETIMESTAMP CREATETIMESTAMP_INSTR, 03010002
INS.UPDATETIMESTAMP UPDATETIMESTAMP_INSTR 03020002
FROM VDPS2.VTINSTRFLATDATA FD 03030002
INNER JOIN 03040002
VDPS2.VTINSTRFLATSYMBOLS FS 03050002
ON FS.INSTRUMENTID = FD.INSTRUMENTID 03060002
INNER JOIN 03070002
VDPS2.VTINSTRUMENT INS 03080002
ON INS.INSTRUMENTID = FD.INSTRUMENTID 03090002
LEFT OUTER JOIN 03100002
VDPS2.VTINSTIFLATSYMBOLS IFS 03110002
ON IFS.INSTITUTIONID = FD.CSMAINPARENTTRADINGPLACE 03120002
and ifs.categoryvdps = '104' --- ??? 03130002
LEFT OUTER JOIN 03140002
VDPS2.VTINSTRFLATSYMBOLS TCUR 03150002
ON TCUR.INSTRUMENTID = FD.CSMAINTRADINGCURR 03160002
LEFT OUTER JOIN 03170002
VDPS2.VTINSTIFLATSYMBOLS MBPL 03180002
ON MBPL.INSTITUTIONID = FD.CSMAINTRADPLACE 03190002
and mbpl.categoryvdps = '104' --- ??? 03200002
LEFT OUTER JOIN 03210002
VDPS2.VTINSTRFLATSYMBOLS RINS 03220002
ON RINS.INSTRUMENTID = FD.CSRISINSTRUMENT 03230002
LEFT OUTER JOIN 03240002
OA1A.TVV_VTGEOUNITFLATSYMBOLS RCTY 03250002
ON RCTY.GEOUNITID = FD.CSRISKCOUNTRY 03260002
LEFT OUTER JOIN 03270002
VDPS2.VTINSTRFLATSYMBOLS RCUR 03280002
ON RCUR.INSTRUMENTID = FD.CSRISKCURRENCY 03290002
LEFT OUTER JOIN 03300002
VDPS2.VTINSTRFLATSYMBOLS ECUR 03310002
ON ECUR.INSTRUMENTID = FD.EXERCISECURR 03320002
LEFT OUTER JOIN 03330002
VDPS2.VTINSTRFLATSYMBOLS ICUR 03340002
ON ICUR.INSTRUMENTID = FD.ISSUEPRICECURR 03350002
LEFT OUTER JOIN 03360002
OA1A.TVV_VTGEOUNITFLATSYMBOLS MLOC 03370002
ON MLOC.GEOUNITID = FD.MOSTLIQUIDMARKETLOCATION 03380002
LEFT OUTER JOIN 03390002
VDPS2.VTINSTRFLATSYMBOLS NCUR 03400002
ON NCUR.INSTRUMENTID = FD.NOMINALCURR 03410002
LEFT OUTER JOIN 03420002
VDPS2.VTINSTRFLATSYMBOLS PCUR 03430002
ON PCUR.INSTRUMENTID = FD.REPAYPRICECURR 03440002
LEFT OUTER JOIN 03450002
VDPS2.VTINSTRFLATSYMBOLS UINS 03460002
ON UINS.INSTRUMENTID = FD.UNDERINSTRUMENT 03470005
-- WHERE FS.ROWSTATUS = 1 03480012
-- AND FS.SYMBOLCH = '1213853' 03490012
-- WITH UR 03500012
; 03510002
explain plan set queryno = 1 for 03520011
SELECT FD.INSTRUMENTID, FD.PAYFREQUENCY, 03530000
FD.CREATETIMESTAMP CREATETIMESTAMP_FD, 03540000
FD.UPDATETIMESTAMP UPDATETIMESTAMP_FD, 03550000
FD.ISCALLFORTXREONLY, FD.ISREDEEMABLE, FD.ISRETRACTABLE, 03560000
FD.ISCONVERTBYHOLDER, FD.ISCONVERTBYISSUER, 03570000
FD.HASVOTINGRIGHTNO, FD.HASREDMPINVARCURR, 03580000
FD.HASMULTIUNDERLYERS, FD.CSMAINTRADPLACE, 03590000
FD.ORIGINALISSUER, FD.ISSUER, FD.UNDERINSTRUMENT, 03600000
FD.NOMINALCURR, FD.CSRISKCURRENCY, FD.CSRISKCOUNTRY, 03610000
FD.CSRISINSTRUMENT, FD.REPAYPRICECURR, FD.ISSUEPRICECURR, 03620000
FD.EXERCISECURR, FD.MAINDEPOSITARY, FD.NOMINALAMOUNT, 03630000
FD.MINDENOMINATION, FD.EFFINTERESTRATE, 03640000
FD.REPAYPRICEAMOUNT, FD.REPAYPRICERATE, FD.POOLFACTOR, 03650000
FD.VOTINGRIGHTNO, FD.OUTSTANDINGCAPITAL, FD.ISSUEDCAPITAL, 03660000
FD.OUTSTANDCAPITALNO, FD.ISSUEDCAPITALNO, FD.ISSUEAMOUNT, 03670000
FD.ISSUEPRICE, FD.EXERCISEAMOUNT, FD.MINEXERCISEAMOUNT, 03680000
FD.HELDAMOUNT, FD.PAYAMOUNT, FD.INCOMETAXRATE, 03690000
FD.PREMIUMRATE, FD.PARTICIPATIONRATE, FD.REBATE, 03700000
FD.CSRATING, FD.CSRISKINDIDSYMBOL, FD.CSRISKINDSCHEMESYM, 03710000
FD.CSRISKINSTGRPIDSYM, FD.CSRISKINSGRPSCHSYM, FD.MDYRATING, 03720000
FD.SPRATING, FD.LISTINGSYMBOLTKH, FD.LISTINGSYMBOLRIC, 03730000
FD.LISTINGSYMBOLBBI, NCUR.SYMBOLI1 NOMINALCURR_I1, 03740000
NCUR.SYMBOLI2 NOMINALCURR_I2, 03750000
NCUR.SYMBOLCSCURR NOMINALCURR_WS80, 03760000
RCUR.SYMBOLI1 CSRISKCURRENCY_I1, 03770000
RCUR.SYMBOLI2 CSRISKCURRENCY_I2, 03780000
RCUR.SYMBOLCSCURR CSRISKCURRENCY_WS80, 03790000
RINS.SYMBOLCH CSRISINSTRUMENT_CH, 03800000
RINS.SYMBOLISIN CSRISINSTRUMENT_ISIN, 03810000
RINS.SYMBOLCSFI CSRISINSTRUMENT_CSFI, 03820000
RCTY.SYMBOLISOA2 CSRISKCOUNTRY_A2, 03830000
RCTY.SYMBOLCSWS80DOM CSRISKCOUNTRY_WS80, 03840000
PCUR.SYMBOLI1 REPAYPRICECURR_I1, 03850000
PCUR.SYMBOLI2 REPAYPRICECURR_I2, 03860000
PCUR.SYMBOLCSCURR REPAYPRICECURR_WS80, 03870000
ICUR.SYMBOLI1 ISSUEPRICECURR_I1, 03880000
ICUR.SYMBOLI2 ISSUEPRICECURR_I2, 03890000
ICUR.SYMBOLCSCURR ISSUEPRICECURR_WS80, 03900000
ECUR.SYMBOLI1 EXERCISECURR_I1, 03910000
ECUR.SYMBOLI2 EXERCISECURR_I2, 03920000
ECUR.SYMBOLCSCURR EXERCISECURR_WS80, 03930000
MBPL.SYMBOLBCN CSMAINTRADPLACE_BCN, 03940000
MBPL.SYMBOLCSWS80BPL CSMAINTRADPLACE_WS80, 03950000
MBPL.SYMBOLRTX CSMAINTRADPLACE_RTX, 03960000
MBPL.SYMBOLBBX CSMAINTRADPLACE_BBX, 03970000
UINS.SYMBOLCH UNDERINSTRUMENT_CH, 03980000
UINS.SYMBOLISIN UNDERINSTRUMENT_ISIN, 03990000
UINS.SYMBOLCSFI UNDERINSTRUMENT_CSFI, FD.ORIGINALISSUER_GK, 04000000
FD.ISSUER_GK, FD.MAINDEPOSITARY_GK, FD.EXPIRATIONDATE, 04010000
FD.MATURITYDATE, FD.FIRSTPAYDATE, FD.FIRSTPYDATEPERYEAR, 04020000
FD.INTRSTDVDENFRDATE, FD.CSRATINGDATE, FD.MDYRATINGDATE, 04030000
FD.SPRATINGDATE, FD.SUBSCRBEGINDATE, FD.PAYMENTDATE, 04040000
FD.EXERCISEBEGINDATE, FD.SUBSCRPLNDENDDATE, 04050000
FD.EXERCISEENDDATE, FD.BVGTYPE, FD.CREDITWORTHINESSTP, 04060000
FD.COMMISSIONCODETYPE, FD.UNITTYPE, FD.CSUNITTYPE, 04070000
FD.EXPIRATIONTYPE, FD.STATUSTYPE STATUSTYPE_FD, 04080000
FD.REGISTRATIONTYPE, FD.BORROWERCATTYPE, 04090000
FD.CSLISTINGCODETYPE, FD.CSSTATUSTYPE CSSTATUSTYPE_FD, 04100000
FD.STATUSDETAILTYPE, FD.INCOMEMODETYPE, 04110000
FD.INTERESTCALCTYPE, FD.INTERESTTYPE, FD.PYFREQUNITTYPE, 04120000
FD.SUBSCRMETHODTYPE, FD.PLACEMENTTYPE, FD.PAYDIRECTIONTYPE, 04130000
FD.OPTIONTYPE, FD.SETTLESTYLETYPE, FD.CSFUNDTYPE, 04140000
FD.TRADINGSTATUSTYPE, FD.LISTINGSTATUSTYPE, 04150000
FD.EXERCISEPLACE, FD.NAME35_G, FD.NAME35_E, FD.NAME35_F, 04160000
FD.NAME35_I, FD.NAME35_N, FD.NAME45_G, FD.NAME45_E, 04170000
FD.NAME45_F, FD.NAME45_I, FD.NAME45_N, FD.SHORTNAME_G, 04180000
FD.SHORTNAME_E, FD.SHORTNAME_F, FD.SHORTNAME_I, 04190000
FD.SHORTNAME_N, FD.PREPARTICLE_G, FD.PREPARTICLE_E, 04200000
FD.PREPARTICLE_F, FD.PREPARTICLE_I, FD.PREPARTICLE_N, 04210000
FD.POSTPARTICLE_G, FD.POSTPARTICLE_E, FD.POSTPARTICLE_F, 04220000
FD.POSTPARTICLE_I, FD.POSTPARTICLE_N, FD.ISINTERNAL, 04230000
FD.ISOTC, FD.HASWITHHOLDINGTAX, FD.HASFEDERALSTAMPDUTY, 04240000
FD.ISCSMIFIDCOMPLEX, FD.MOSTLIQUIDMARKETLOCATION, 04250000
MLOC.SYMBOLISOA2 MOSTLIQUIDMARKETLOCATION_A2, 04260000
MLOC.SYMBOLISOA3 MOSTLIQUIDMARKETLOCATION_A3, 04270000
MLOC.SYMBOLCSWS80DOM MOSTLIQUIDMARKETLOCATION_WS80, 04280000
FD.MDYWATCHLISTSTATUSTYPE, FD.SPWATCHLISTSTATUSTYPE, 04290000
FD.OPTIONSTYLETYPE, FD.CSMAINTRADINGCURR, 04300000
TCUR.SYMBOLI1 CSMAINTRADINGCURR_I1, 04310000
TCUR.SYMBOLI2 CSMAINTRADINGCURR_I2, 04320000
TCUR.SYMBOLCSCURR CSMAINTRADINGCURR_WS80, 04330000
RCTY.SYMBOLISOA3 CSRISKCOUNTRY_A3, FD.LIQUIDATIONRIGHTTYPE, 04340000
FD.CSMAINPARENTTRADINGPLACE, 04350000
IFS.SYMBOLBCN CSMAINPARENTTRADINGPLACE_BCN, 04360000
IFS.SYMBOLRTX CSMAINPARENTTRADINGPLACE_RTX, 04370000
IFS.SYMBOLMIC CSMAINPARENTTRADINGPLACE_MIC, 04380000
IFS.SYMBOLBBX CSMAINPARENTTRADINGPLACE_BBX, 04390000
IFS.SYMBOLCSWS80BPL CSMAINPARENTTRADINGPLACE_WS80, 04400000
FD.ISMANAGEDBYCS, FD.EVENTFUNCTIONTYPE, 04410000
FD.MAINLANGUAGETYPE, FD.EFFECTIVEDATE, 04420000
FS.CREATETIMESTAMP CREATETIMESTAMP_FS, 04430000
FS.UPDATETIMESTAMP UPDATETIMESTAMP_FS, FS.ROWSTATUS, 04440000
FS.SYMBOLCSFI, FS.SYMBOLCH, FS.SYMBOLISIN, FS.SYMBOLUS, 04450000
FS.SYMBOLXS, FS.SYMBOLGB, FS.SYMBOLLU, FS.SYMBOLDE, 04460000
FS.SYMBOLAT, FS.SYMBOLFR, FS.SYMBOLBE, FS.SYMBOLIT, 04470000
FS.SYMBOLNL, FS.SYMBOLJP, FS.SYMBOLJ2, FS.SYMBOLDK, 04480000
FS.SYMBOLSE, FS.SYMBOLI2, FS.SYMBOLI1, FS.SYMBOLT1, 04490000
FS.SYMBOLT2, FS.SYMBOLCSCURR, FS.CATEGORYVDPS, 04500000
FS.CATEGORYTKT, FS.CATEGORYTKSK, FS.CATEGORYTKZUS, 04510000
FS.CATEGORYTKPRK, FS.CATEGORYTKTZ, FS.CATEGORYMAZU, 04520000
FS.CATEGORYECBTR, FS.CATEGORYCFI, FS.CATEGORYEUZS, 04530000
FS.CATEGORYCSGTA, FS.CATEGORYCSGMS, FS.CATEGUSTAXREPORT, 04540000
FS.CATEGUSIRSADDITION, FS.CSSTATUSTYPE CSSTATUSTYPE_FS, 04550000
FS.STATUSTYPE STATUSTYPE_FS, FS.SYMBOLSPIRIT, 04560000
INS.CREATETIMESTAMP CREATETIMESTAMP_INSTR, 04570000
INS.UPDATETIMESTAMP UPDATETIMESTAMP_INSTR 04580000
FROM VDPS2.VTINSTRFLATDATA FD 04590000
INNER JOIN 04600000
VDPS2.VTINSTRFLATSYMBOLS FS 04610000
ON FS.INSTRUMENTID = FD.INSTRUMENTID 04620000
INNER JOIN 04630000
VDPS2.VTINSTRUMENT INS 04640000
ON INS.INSTRUMENTID = FD.INSTRUMENTID 04650000
LEFT OUTER JOIN 04660000
VDPS2.VTINSTIFLATSYMBOLS IFS 04670000
ON IFS.INSTITUTIONID = FD.CSMAINPARENTTRADINGPLACE 04680000
LEFT OUTER JOIN 04690000
VDPS2.VTINSTRFLATSYMBOLS TCUR 04700000
ON TCUR.INSTRUMENTID = FD.CSMAINTRADINGCURR 04710000
LEFT OUTER JOIN 04720000
VDPS2.VTINSTIFLATSYMBOLS MBPL 04730000
ON MBPL.INSTITUTIONID = FD.CSMAINTRADPLACE 04740000
LEFT OUTER JOIN 04750000
VDPS2.VTINSTRFLATSYMBOLS RINS 04760000
ON RINS.INSTRUMENTID = FD.CSRISINSTRUMENT 04770000
LEFT OUTER JOIN 04780000
OA1A.TVV_VTGEOUNITFLATSYMBOLS RCTY 04790000
ON RCTY.GEOUNITID = FD.CSRISKCOUNTRY 04800000
LEFT OUTER JOIN 04810000
VDPS2.VTINSTRFLATSYMBOLS RCUR 04820000
ON RCUR.INSTRUMENTID = FD.CSRISKCURRENCY 04830000
LEFT OUTER JOIN 04840000
VDPS2.VTINSTRFLATSYMBOLS ECUR 04850000
ON ECUR.INSTRUMENTID = FD.EXERCISECURR 04860000
LEFT OUTER JOIN 04870000
VDPS2.VTINSTRFLATSYMBOLS ICUR 04880000
ON ICUR.INSTRUMENTID = FD.ISSUEPRICECURR 04890000
LEFT OUTER JOIN 04900000
OA1A.TVV_VTGEOUNITFLATSYMBOLS MLOC 04910000
ON MLOC.GEOUNITID = FD.MOSTLIQUIDMARKETLOCATION 04920000
LEFT OUTER JOIN 04930000
VDPS2.VTINSTRFLATSYMBOLS NCUR 04940000
ON NCUR.INSTRUMENTID = FD.NOMINALCURR 04950000
LEFT OUTER JOIN 04960000
VDPS2.VTINSTRFLATSYMBOLS PCUR 04970000
ON PCUR.INSTRUMENTID = FD.REPAYPRICECURR 04980000
LEFT OUTER JOIN 04990000
VDPS2.VTINSTRFLATSYMBOLS UINS 05000000
ON UINS.INSTRUMENTID = FD.UNDERINSTRUMENT 05010003
-- WHERE FS.ROWSTATUS = 1 05020012
-- AND FS.SYMBOLCH = '1213853' 05030012
-- WITH UR 05040012
; 05050002
select * from plan_view2 05060007
order by applname, progname, queryNo, qblockno, planno 05070002
; 05080002
rollback 05090002