zOs/SQL/VDPSMQT1
-- version 31.8 ORG.U0009.B0106.KAXV3.SQL(DCATVDPS 00000101
set current sqlid = 'A540769' ; 00000202
DELETE FROM PLAN_TABLE ; 00000302
-- EXPLAIN ALL SET QUERYNO=300 FOR 00000504
SELECT T1.INSTRUMENTID, T1.ROWSTATUS, T1.SYMBOLCSFI, T1.SYMBOLCH, 00000601
T1.SYMBOLISIN, T1.SYMBOLUS, T1.SYMBOLXS, T1.SYMBOLGB, 00000701
T1.SYMBOLLU, T1.SYMBOLDE, T1.SYMBOLAT, T1.SYMBOLFR, 00000801
T1.SYMBOLBE, T1.SYMBOLIT, T1.SYMBOLNL, T1.SYMBOLJP, 00000901
T1.SYMBOLJ2, T1.SYMBOLDK, T1.SYMBOLSE, T1.SYMBOLI2, 00001001
T1.SYMBOLI1, T1.SYMBOLT1, T1.SYMBOLT2, T1.SYMBOLCSCURR, 00001101
T1.CATEGORYVDPS, T1.CATEGORYTKT, T1.CATEGORYTKSK, 00001201
T1.CATEGORYTKZUS, T1.CATEGORYTKPRK, T1.CATEGORYTKTZ, 00001301
T1.CATEGORYMAZU, T1.CATEGORYECBTR, T1.CATEGORYCFI, 00001401
T1.CATEGORYEUZS, T1.CATEGORYCSGTA, T1.CATEGORYCSGMS, 00001501
T1.CATEGUSTAXREPORT, T1.CATEGUSIRSADDITION, 00001601
T1.CSSTATUSTYPE CSSTATUSTYPE_FLTSYMB, 00001701
T1.STATUSTYPE STATUSTYPE_FLTSYMB, T2.PAYFREQUENCY, 00001801
T2.ISCALLFORTXREONLY, T2.ISREDEEMABLE, T2.ISRETRACTABLE, 00001901
T2.ISCONVERTBYHOLDER, T2.ISCONVERTBYISSUER, 00002001
T2.HASVOTINGRIGHTNO, T2.HASREDMPINVARCURR, 00002101
T2.HASMULTIUNDERLYERS, T2.CSMAINTRADPLACE, 00002201
T2.ORIGINALISSUER, T2.ISSUER, T2.UNDERINSTRUMENT, 00002301
T2.NOMINALCURR, T2.CSRISKCURRENCY, T2.CSRISKCOUNTRY, 00002401
T2.CSRISINSTRUMENT, T2.REPAYPRICECURR, T2.ISSUEPRICECURR, 00002501
T2.EXERCISECURR, T2.MAINDEPOSITARY, T2.NOMINALAMOUNT, 00002601
T2.MINDENOMINATION, T2.EFFINTERESTRATE, 00002701
T2.REPAYPRICEAMOUNT, T2.REPAYPRICERATE, T2.POOLFACTOR, 00002801
T2.VOTINGRIGHTNO, T2.OUTSTANDINGCAPITAL, T2.ISSUEDCAPITAL, 00002901
T2.OUTSTANDCAPITALNO, T2.ISSUEDCAPITALNO, T2.ISSUEAMOUNT, 00003001
T2.ISSUEPRICE, T2.EXERCISEAMOUNT, T2.MINEXERCISEAMOUNT, 00003101
T2.HELDAMOUNT, T2.PAYAMOUNT, T2.INCOMETAXRATE, 00003201
T2.PREMIUMRATE, T2.PARTICIPATIONRATE, T2.REBATE, 00003301
T2.CSRATING, T2.CSRISKINDIDSYMBOL, T2.CSRISKINDSCHEMESYM, 00003401
T2.CSRISKINSTGRPIDSYM, T2.CSRISKINSGRPSCHSYM, T2.MDYRATING, 00003501
T2.SPRATING, T2.LISTINGSYMBOLTKH, T2.LISTINGSYMBOLRIC, 00003601
T2.LISTINGSYMBOLBBI, T210.SYMBOLI1 NOMINALCURR_I1, 00003701
T210.SYMBOLI2 NOMINALCURR_I2, 00003801
T210.SYMBOLCSCURR NOMINALCURR_WS80, 00003901
T26.SYMBOLI1 CSRISKCURRENCY_I1, 00004001
T26.SYMBOLI2 CSRISKCURRENCY_I2, 00004101
T26.SYMBOLCSCURR CSRISKCURRENCY_WS80, 00004201
T24.SYMBOLCH CSRISINSTRUMENT_CH, 00004301
T24.SYMBOLISIN CSRISINSTRUMENT_ISIN, 00004401
T24.SYMBOLCSFI CSRISINSTRUMENT_CSFI, 00004501
T25.SYMBOLISOA2 CSRISKCOUNTRY_A2, 00004601
T25.SYMBOLCSWS80DOM CSRISKCOUNTRY_WS80, 00004701
T211.SYMBOLI1 REPAYPRICECURR_I1, 00004801
T211.SYMBOLI2 REPAYPRICECURR_I2, 00004901
T211.SYMBOLCSCURR REPAYPRICECURR_WS80, 00005001
T28.SYMBOLI1 ISSUEPRICECURR_I1, 00005101
T28.SYMBOLI2 ISSUEPRICECURR_I2, 00005201
T28.SYMBOLCSCURR ISSUEPRICECURR_WS80, 00005301
T27.SYMBOLI1 EXERCISECURR_I1, T27.SYMBOLI2 EXERCISECURR_I2, 00005401
T27.SYMBOLCSCURR EXERCISECURR_WS80, 00005501
T23.SYMBOLBCN CSMAINTRADPLACE_BCN, 00005601
T23.SYMBOLCSWS80BPL CSMAINTRADPLACE_WS80, 00005701
T23.SYMBOLRTX CSMAINTRADPLACE_RTX, 00005801
T23.SYMBOLBBX CSMAINTRADPLACE_BBX, 00005901
T212.SYMBOLCH UNDERINSTRUMENT_CH, 00006001
T212.SYMBOLISIN UNDERINSTRUMENT_ISIN, 00006101
T212.SYMBOLCSFI UNDERINSTRUMENT_CSFI, T2.ORIGINALISSUER_GK, 00006201
T2.ISSUER_GK, T2.MAINDEPOSITARY_GK, T2.EXPIRATIONDATE, 00006301
T2.MATURITYDATE, T2.FIRSTPAYDATE, T2.FIRSTPYDATEPERYEAR, 00006401
T2.INTRSTDVDENFRDATE, T2.CSRATINGDATE, T2.MDYRATINGDATE, 00006501
T2.SPRATINGDATE, T2.SUBSCRBEGINDATE, T2.PAYMENTDATE, 00006601
T2.EXERCISEBEGINDATE, T2.SUBSCRPLNDENDDATE, 00006701
T2.EXERCISEENDDATE, T2.BVGTYPE, T2.CREDITWORTHINESSTP, 00006801
T2.COMMISSIONCODETYPE, T2.UNITTYPE, T2.CSUNITTYPE, 00006901
T2.EXPIRATIONTYPE, T2.STATUSTYPE, T2.REGISTRATIONTYPE, 00007001
T2.BORROWERCATTYPE, T2.CSLISTINGCODETYPE, T2.CSSTATUSTYPE, 00007101
T2.STATUSDETAILTYPE, T2.INCOMEMODETYPE, 00007201
T2.INTERESTCALCTYPE, T2.INTERESTTYPE, T2.PYFREQUNITTYPE, 00007301
T2.SUBSCRMETHODTYPE, T2.PLACEMENTTYPE, T2.PAYDIRECTIONTYPE, 00007401
T2.OPTIONTYPE, T2.SETTLESTYLETYPE, T2.CSFUNDTYPE, 00007501
T2.TRADINGSTATUSTYPE, T2.LISTINGSTATUSTYPE, 00007601
T2.EXERCISEPLACE, T2.NAME35_G, T2.NAME35_E, T2.NAME35_F, 00007701
T2.NAME35_I, T2.NAME35_N, T2.NAME45_G, T2.NAME45_E, 00007801
T2.NAME45_F, T2.NAME45_I, T2.NAME45_N, T2.SHORTNAME_G, 00007901
T2.SHORTNAME_E, T2.SHORTNAME_F, T2.SHORTNAME_I, 00008001
T2.SHORTNAME_N, T2.PREPARTICLE_G, T2.PREPARTICLE_E, 00008101
T2.PREPARTICLE_F, T2.PREPARTICLE_I, T2.PREPARTICLE_N, 00008201
T2.POSTPARTICLE_G, T2.POSTPARTICLE_E, T2.POSTPARTICLE_F, 00008301
T2.POSTPARTICLE_I, T2.POSTPARTICLE_N, T2.ISINTERNAL, 00008401
T2.ISOTC, T2.HASWITHHOLDINGTAX, T2.HASFEDERALSTAMPDUTY, 00008501
T2.ISCSMIFIDCOMPLEX, T2.MOSTLIQUIDMARKETLOCATION, 00008601
T29.SYMBOLISOA2 MOSTLIQUIDMARKETLOCATION_A2, 00008701
T29.SYMBOLISOA3 MOSTLIQUIDMARKETLOCATION_A3, 00008801
T29.SYMBOLCSWS80DOM MOSTLIQUIDMARKETLOCATION_WS80, 00008901
T2.MDYWATCHLISTSTATUSTYPE, T2.SPWATCHLISTSTATUSTYPE, 00009001
T2.OPTIONSTYLETYPE, T2.CSMAINTRADINGCURR, 00009101
T22.SYMBOLI1 CSMAINTRADINGCURR_I1, 00009201
T22.SYMBOLI2 CSMAINTRADINGCURR_I2, 00009301
T22.SYMBOLCSCURR CSMAINTRADINGCURR_WS80, 00009401
T25.SYMBOLISOA3 CSRISKCOUNTRY_A3, T2.LIQUIDATIONRIGHTTYPE, 00009501
T2.CSMAINPARENTTRADINGPLACE, 00009601
T21.SYMBOLBCN CSMAINPARENTTRADINGPLACE_BCN, 00009701
T21.SYMBOLRTX CSMAINPARENTTRADINGPLACE_RTX, 00009801
T21.SYMBOLMIC CSMAINPARENTTRADINGPLACE_MIC, 00009901
T21.SYMBOLBBX CSMAINPARENTTRADINGPLACE_BBX, 00010001
T21.SYMBOLCSWS80BPL CSMAINPARENTTRADINGPLACE_WS80, 00010101
T3.PAYFREQUENCY UND_PAYFREQUENCY, 00010201
T3.ISCALLFORTXREONLY UND_ISCALLFORTXREONLY, 00010301
T3.ISREDEEMABLE UND_ISREDEEMABLE, 00010401
T3.ISRETRACTABLE UND_ISRETRACTABLE, 00010501
T3.ISCONVERTBYHOLDER UND_ISCONVERTBYHOLDER, 00010601
T3.ISCONVERTBYISSUER UND_ISCONVERTBYISSUER, 00010701
T3.HASVOTINGRIGHTNO UND_HASVOTINGRIGHTNO, 00010801
T3.HASREDMPINVARCURR UND_HASREDMPINVARCURR, 00010901
T3.HASMULTIUNDERLYERS UND_HASMULTIUNDERLYERS, 00011001
T3.CSMAINTRADPLACE UND_CSMAINTRADPLACE, 00011101
T3.ORIGINALISSUER UND_ORIGINALISSUER, T3.ISSUER UND_ISSUER, 00011201
T3.UNDERINSTRUMENT UND_UNDERINSTRUMENT, 00011301
T3.NOMINALCURR UND_NOMINALCURR, 00011401
T3.CSRISKCURRENCY UND_CSRISKCURRENCY, 00011501
T3.CSRISKCOUNTRY UND_CSRISKCOUNTRY, 00011601
T3.CSRISINSTRUMENT UND_CSRISINSTRUMENT, 00011701
T3.REPAYPRICECURR UND_REPAYPRICECURR, 00011801
T3.ISSUEPRICECURR UND_ISSUEPRICECURR, 00011901
T3.EXERCISECURR UND_EXERCISECURR, 00012001
T3.MAINDEPOSITARY UND_MAINDEPOSITARY, 00012101
T3.NOMINALAMOUNT UND_NOMINALAMOUNT, 00012201
T3.MINDENOMINATION UND_MINDENOMINATION, 00012301
T3.EFFINTERESTRATE UND_EFFINTERESTRATE, 00012401
T3.REPAYPRICEAMOUNT UND_REPAYPRICEAMOUNT, 00012501
T3.REPAYPRICERATE UND_REPAYPRICERATE, 00012601
T3.POOLFACTOR UND_POOLFACTOR, 00012701
T3.VOTINGRIGHTNO UND_VOTINGRIGHTNO, 00012801
T3.OUTSTANDINGCAPITAL UND_OUTSTANDINGCAPITAL, 00012901
T3.ISSUEDCAPITAL UND_ISSUEDCAPITAL, 00013001
T3.OUTSTANDCAPITALNO UND_OUTSTANDCAPITALNO, 00013101
T3.ISSUEDCAPITALNO UND_ISSUEDCAPITALNO, 00013201
T3.ISSUEAMOUNT UND_ISSUEAMOUNT, 00013301
T3.ISSUEPRICE UND_ISSUEPRICE, 00013401
T3.EXERCISEAMOUNT UND_EXERCISEAMOUNT, 00013501
T3.MINEXERCISEAMOUNT UND_MINEXERCISEAMOUNT, 00013601
T3.HELDAMOUNT UND_HELDAMOUNT, T3.PAYAMOUNT UND_PAYAMOUNT, 00013701
T3.INCOMETAXRATE UND_INCOMETAXRATE, 00013801
T3.PREMIUMRATE UND_PREMIUMRATE, 00013901
T3.PARTICIPATIONRATE UND_PARTICIPATIONRATE, 00014001
T3.REBATE UND_REBATE, T3.CSRATING UND_CSRATING, 00014101
T3.CSRISKINDIDSYMBOL UND_CSRISKINDIDSYMBOL, 00014201
T3.CSRISKINDSCHEMESYM UND_CSRISKINDSCHEMESYM, 00014301
T3.CSRISKINSTGRPIDSYM UND_CSRISKINSTGRPIDSYM, 00014401
T3.CSRISKINSGRPSCHSYM UND_CSRISKINSGRPSCHSYM, 00014501
T3.MDYRATING UND_MDYRATING, T3.SPRATING UND_SPRATING, 00014601
T3.FITCHRATING UND_FITCHRATING, 00014701
T3.LISTINGSYMBOLTKH UND_LISTINGSYMBOLTKH, 00014801
T3.LISTINGSYMBOLRIC UND_LISTINGSYMBOLRIC, 00014901
T3.LISTINGSYMBOLBBI UND_LISTINGSYMBOLBBI, 00015001
T310.SYMBOLI1 UND_NOMINALCURR_I1, 00015101
T310.SYMBOLI2 UND_NOMINALCURR_I2, 00015201
T310.SYMBOLCSCURR UND_NOMINALCURR_WS80, 00015301
T36.SYMBOLI1 UND_CSRISKCURRENCY_I1, 00015401
T36.SYMBOLI2 UND_CSRISKCURRENCY_I2, 00015501
T36.SYMBOLCSCURR UND_CSRISKCURRENCY_WS80, 00015601
T34.SYMBOLCH UND_CSRISINSTRUMENT_CH, 00015701
T34.SYMBOLISIN UND_CSRISINSTRUMENT_ISIN, 00015801
T34.SYMBOLCSFI UND_CSRISINSTRUMENT_CSFI, 00015901
T35.SYMBOLISOA2 UND_CSRISKCOUNTRY_A2, 00016001
T35.SYMBOLCSWS80DOM UND_CSRISKCOUNTRY_WS80, 00016101
T311.SYMBOLI1 UND_REPAYPRICECURR_I1, 00016201
T311.SYMBOLI2 UND_REPAYPRICECURR_I2, 00016301
T311.SYMBOLCSCURR UND_REPAYPRICECURR_WS80, 00016401
T38.SYMBOLI1 UND_ISSUEPRICECURR_I1, 00016501
T38.SYMBOLI2 UND_ISSUEPRICECURR_I2, 00016601
T38.SYMBOLCSCURR UND_ISSUEPRICECURR_WS80, 00016701
T37.SYMBOLI1 UND_EXERCISECURR_I1, 00016801
T37.SYMBOLI2 UND_EXERCISECURR_I2, 00016901
T37.SYMBOLCSCURR UND_EXERCISECURR_WS80, 00017001
T33.SYMBOLBCN UND_CSMAINTRADPLACE_BCN, 00017101
T33.SYMBOLCSWS80BPL UND_CSMAINTRADPLACE_WS80, 00017201
T33.SYMBOLRTX UND_CSMAINTRADPLACE_RTX, 00017301
T33.SYMBOLBBX UND_CSMAINTRADPLACE_BBX, 00017401
T312.SYMBOLCH UND_UNDERINSTRUMENT_CH, 00017501
T312.SYMBOLISIN UND_UNDERINSTRUMENT_ISIN, 00017601
T312.SYMBOLCSFI UND_UNDERINSTRUMENT_CSFI, 00017701
T3.ORIGINALISSUER_GK UND_ORIGINALISSUER_GK, 00017801
T3.ISSUER_GK UND_ISSUER_GK, 00017901
T3.MAINDEPOSITARY_GK UND_MAINDEPOSITARY_GK, 00018001
T3.EXPIRATIONDATE UND_EXPIRATIONDATE, 00018101
T3.MATURITYDATE UND_MATURITYDATE, 00018201
T3.FIRSTPAYDATE UND_FIRSTPAYDATE, 00018301
T3.FIRSTPYDATEPERYEAR UND_FIRSTPYDATEPERYEAR, 00018401
T3.INTRSTDVDENFRDATE UND_INTRSTDVDENFRDATE, 00018501
T3.CSRATINGDATE UND_CSRATINGDATE, 00018601
T3.MDYRATINGDATE UND_MDYRATINGDATE, 00018701
T3.SPRATINGDATE UND_SPRATINGDATE, 00018801
T3.FITCHRATINGDATE UND_FITCHRATINGDATE, 00018901
T3.SUBSCRBEGINDATE UND_SUBSCRBEGINDATE, 00019001
T3.PAYMENTDATE UND_PAYMENTDATE, 00019101
T3.EXERCISEBEGINDATE UND_EXERCISEBEGINDATE, 00019201
T3.SUBSCRPLNDENDDATE UND_SUBSCRPLNDENDDATE, 00019301
T3.EXERCISEENDDATE UND_EXERCISEENDDATE, 00019401
T3.BVGTYPE UND_BVGTYPE, 00019501
T3.CREDITWORTHINESSTP UND_CREDITWORTHINESSTP, 00019601
T3.COMMISSIONCODETYPE UND_COMMISSIONCODETYPE, 00019701
T3.UNITTYPE UND_UNITTYPE, T3.CSUNITTYPE UND_CSUNITTYPE, 00019801
T3.EXPIRATIONTYPE UND_EXPIRATIONTYPE, 00019901
T3.STATUSTYPE UND_STATUSTYPE, 00020001
T3.REGISTRATIONTYPE UND_REGISTRATIONTYPE, 00020101
T3.BORROWERCATTYPE UND_BORROWERCATTYPE, 00020201
T3.CSLISTINGCODETYPE UND_CSLISTINGCODETYPE, 00020301
T3.CSSTATUSTYPE UND_CSSTATUSTYPE, 00020401
T3.STATUSDETAILTYPE UND_STATUSDETAILTYPE, 00020501
T3.INCOMEMODETYPE UND_INCOMEMODETYPE, 00020601
T3.INTERESTCALCTYPE UND_INTERESTCALCTYPE, 00020701
T3.INTERESTTYPE UND_INTERESTTYPE, 00020801
T3.PYFREQUNITTYPE UND_PYFREQUNITTYPE, 00020901
T3.SUBSCRMETHODTYPE UND_SUBSCRMETHODTYPE, 00021001
T3.PLACEMENTTYPE UND_PLACEMENTTYPE, 00021101
T3.PAYDIRECTIONTYPE UND_PAYDIRECTIONTYPE, 00021201
T3.OPTIONTYPE UND_OPTIONTYPE, 00021301
T3.SETTLESTYLETYPE UND_SETTLESTYLETYPE, 00021401
T3.CSFUNDTYPE UND_CSFUNDTYPE, 00021501
T3.TRADINGSTATUSTYPE UND_TRADINGSTATUSTYPE, 00021601
T3.LISTINGSTATUSTYPE UND_LISTINGSTATUSTYPE, 00021701
T3.EXERCISEPLACE UND_EXERCISEPLACE, 00021801
T3.NAME35_G UND_NAME35_G, T3.NAME35_E UND_NAME35_E, 00021901
T3.NAME35_F UND_NAME35_F, T3.NAME35_I UND_NAME35_I, 00022001
T3.NAME35_N UND_NAME35_N, T3.NAME45_G UND_NAME45_G, 00022101
T3.NAME45_E UND_NAME45_E, T3.NAME45_F UND_NAME45_F, 00022201
T3.NAME45_I UND_NAME45_I, T3.NAME45_N UND_NAME45_N, 00022301
T3.SHORTNAME_G UND_SHORTNAME_G, 00022401
T3.SHORTNAME_E UND_SHORTNAME_E, 00022501
T3.SHORTNAME_F UND_SHORTNAME_F, 00022601
T3.SHORTNAME_I UND_SHORTNAME_I, 00022701
T3.SHORTNAME_N UND_SHORTNAME_N, 00022801
T3.PREPARTICLE_G UND_PREPARTICLE_G, 00022901
T3.PREPARTICLE_E UND_PREPARTICLE_E, 00023001
T3.PREPARTICLE_F UND_PREPARTICLE_F, 00023101
T3.PREPARTICLE_I UND_PREPARTICLE_I, 00023201
T3.PREPARTICLE_N UND_PREPARTICLE_N, 00023301
T3.POSTPARTICLE_G UND_POSTPARTICLE_G, 00023401
T3.POSTPARTICLE_E UND_POSTPARTICLE_E, 00023501
T3.POSTPARTICLE_F UND_POSTPARTICLE_F, 00023601
T3.POSTPARTICLE_I UND_POSTPARTICLE_I, 00023701
T3.POSTPARTICLE_N UND_POSTPARTICLE_N, 00023801
T3.ISINTERNAL UND_ISINTERNAL, T3.ISOTC UND_ISOTC, 00023901
T3.HASWITHHOLDINGTAX UND_UND_HASWITHHOLDINGTAX, 00024001
T3.HASFEDERALSTAMPDUTY UND_HASFEDERALSTAMPDUTY, 00024101
T3.ISCSMIFIDCOMPLEX UND_ISCSMIFIDCOMPLEX, 00024201
T3.MOSTLIQUIDMARKETLOCATION UND_MOSTLQDMARKETLOCATION, 00024301
T39.SYMBOLISOA2 UND_MOSTLQDMARKETLOCATION_A2, 00024401
T39.SYMBOLISOA3 UND_MOSTLQDMARKETLOCATION_A3, 00024501
T39.SYMBOLCSWS80DOM UND_MOSTLQDMARKETLOCATION_WS80, 00024601
T3.MDYWATCHLISTSTATUSTYPE UND_MDYWATCHLISTSTATUSTYPE, 00024701
T3.SPWATCHLISTSTATUSTYPE UND_SPWATCHLISTSTATUSTYPE, 00024801
T3.FITCHWATCHLISTSTATUSTYPE UND_FITCHWATCHLISTSTATUSTYPE, 00024901
T3.OPTIONSTYLETYPE UND_OPTIONSTYLETYPE, 00025001
T3.CSMAINTRADINGCURR UND_CSMAINTRADINGCURR, 00025101
T32.SYMBOLI1 UND_CSMAINTRADINGCURR_I1, 00025201
T32.SYMBOLI2 UND_CSMAINTRADINGCURR_I2, 00025301
T32.SYMBOLCSCURR UND_CSMAINTRADINGCURR_WS80, 00025401
T35.SYMBOLISOA3 UND_CSRISKCOUNTRY_A3, 00025501
T3.LIQUIDATIONRIGHTTYPE UND_LIQUIDATIONRIGHTTYPE, 00025601
T3.CSMAINPARENTTRADINGPLACE UND_CSMAINPTRADINGPLACE, 00025701
T31.SYMBOLBCN UND_CSMAINPTRADINGPLACE_BCN, 00025801
T31.SYMBOLRTX UND_CSMAINPTRADINGPLACE_RTX, 00025901
T31.SYMBOLMIC UND_CSMAINPTRADINGPLACE_MIC, 00026001
T31.SYMBOLBBX UND_CSMAINPTRADINGPLACE_BBX, 00026101
T31.SYMBOLCSWS80BPL UND_CSMAINPTRADINGPLACE_WS80, 00026201
T4.ISSUECONDITIONNO, T4.AMOUNT, T4.PROVIDER1ID, T4.PRICE, 00026301
T4.PROVIDER2ID, T4.PRICEUNITAMOUNT, T4.PROVIDER3ID, 00026401
T4.PRICERANGEFROM, T4.ISINDIVPAYMENT, T4.PRICERANGETO, 00026501
T4.HASPREFSUBSCRRIGHT, T4.MAXAMOUNT, T4.ISTAXED, 00026601
T4.MINAMOUNT, T4.ISSUINGINSTITUTION, T4.TAXAMOUNT, 00026701
T4.SUBSCRLOCATION, T4.MINSUBSCRAMOUNT, T4.ACCRINTERESTCURR, 00026801
T4.MINSUBSCRINCREMENT, T4.PRICECURR, T4.PLACEMENTPRICE, 00026901
T4.ROUNDOFFAMOUNT, T4.ACCRINTERESTAMOUNT, 00027001
T4.NOOFSECURITIES, T4.ROUNDOFFRULETYPE, T4.TAXVALUE, 00027101
T4.STATUSTYPE ISSUE_STATUSTYPE, T4.YIELD, T4.PRICETYPE, 00027201
T4.ACCRUEDINTEREST, T4.PRICEUNITTYPE, T4.INCOMESTARTDATE, 00027301
T4.QUOTATIONTYPE, T4.ACCRINTRSTFROMDATE, T4.PAYMENTTYPE, 00027401
T4.PAYMENTFROMDATE, T4.PAYMENTUNTILDATE, 00027501
T4.PRICEFIXINGDATE, T4.TAXTYPE, T4.SUBSCREFFENDDATE, 00027601
T4.ISSUEAMOUNTTYPE, T4.ISSUETYPE, T4.PUBLICATION_I, 00027701
T4.OVERSUBSCRRIGHTTP, T4.DESCRIPTION_N, T4.PROVISIONTYPE, 00027801
T4.PUBLICATION_N, T4.SUBSCRPERIODTYPE, T4.TAXCURRENCY, 00027901
T4.SUBSCRIPTIONPLACE, T4.TAXQUOTETYPE, T4.DESCRIPTION_G, 00028001
T4.TAXUNITTYPE, T4.PUBLICATION_G, T4.SYNTHETICPRICECURR, 00028101
T4.DESCRIPTION_E, T4.SYNTHETICPRICEAMOUNT, 00028201
T4.PUBLICATION_E, T4.SYNTHETICPRICERATE, T4.DESCRIPTION_F, 00028301
T4.IPOTIMINGTYPE, T4.PUBLICATION_F, T4.IPOFILINGDATE, 00028401
T4.DESCRIPTION_I, T4.IPODATE, T4.CSIPODESCRIPTION, 00028501
T4.CSIPOCOMPANYDESCRIPTION, 00028601
T4.CSSUBSCRIPTIONPLANNEDENDDATE, T4.FIRSTTRADINGDATE, 00028701
T4.EXPECTEDALLOCATIONDATE, T4.ISISSUEINCREASABLE, 00028801
T4.INITIALPRICINGBEGINDATE, T4.INITIALPRICINGENDDATE, 00028901
T4.INITIALPRICINGFUNCTIONTYPE, T4.FINALPRICINGBEGINDATE, 00029001
T4.FINALPRICINGENDDATE, T4.FINALPRICINGFUNCTIONTYPE, 00029101
T4.SUBSCRPLNDENDDATE ISSUE_SUBSCRPLNDENDDATE, 00029201
T4.INTERESTCALCTYPE ISSUE_INTERESTCALCTYPE, 00029301
T4.SUBSCRMETHODTYPE ISSUE_SUBSCRMETHODTYPE, 00029401
T4.PAYMENTDATE ISSUE_PAYMENTDATE, 00029501
T4.SUBSCRBEGINDATE ISSUE_SUBSCRBEGINDATE, 00029601
T4.PLACEMENTTYPE ISSUE_PLACEMENTTYPE, T4.CSISSUEDESK 00029701
FROM VDPS2.VTINSTRFLATSYMBOLS T1 00029801
INNER JOIN 00029901
VDPS2.VTINSTRFLATDATA T2 00030001
ON T2.INSTRUMENTID = T1.INSTRUMENTID 00030101
LEFT OUTER JOIN 00030201
VDPS2.VTINSTIFLATSYMBOLS T21 00030301
ON (T2.CSMAINPARENTTRADINGPLACE = T21.INSTITUTIONID 00030401
AND T21.CATEGORYVDPS = '104') 00030501
LEFT OUTER JOIN 00030601
VDPS2.VTINSTRFLATSYMBOLS T22 00030701
ON (T2.CSMAINTRADINGCURR = T22.INSTRUMENTID 00030801
AND T22.CATEGORYVDPS = '104') 00030901
LEFT OUTER JOIN 00031001
VDPS2.VTINSTIFLATSYMBOLS T23 00031101
ON (T2.CSMAINTRADPLACE = T23.INSTITUTIONID 00031201
AND T23.CATEGORYVDPS = '104') 00031301
LEFT OUTER JOIN 00031401
VDPS2.VTINSTRFLATSYMBOLS T24 00031501
ON T2.CSRISINSTRUMENT = T24.INSTRUMENTID 00031601
LEFT OUTER JOIN 00031701
OA1A.TVV_VTGEOUNITFLATSYMBOLS T25 00031801
ON T2.CSRISKCOUNTRY = T25.GEOUNITID 00031901
LEFT OUTER JOIN 00032001
VDPS2.VTINSTRFLATSYMBOLS T26 00032101
ON (T2.CSRISKCURRENCY = T26.INSTRUMENTID 00032201
AND T26.CATEGORYVDPS = '10') 00032301
LEFT OUTER JOIN 00032401
VDPS2.VTINSTRFLATSYMBOLS T27 00032501
ON (T2.EXERCISECURR = T27.INSTRUMENTID 00032601
AND T27.CATEGORYVDPS = '10') 00032701
LEFT OUTER JOIN 00032801
VDPS2.VTINSTRFLATSYMBOLS T28 00032901
ON (T2.ISSUEPRICECURR = T28.INSTRUMENTID 00033001
AND T28.CATEGORYVDPS = '10') 00033101
LEFT OUTER JOIN 00033201
OA1A.TVV_VTGEOUNITFLATSYMBOLS T29 00033301
ON T2.MOSTLIQUIDMARKETLOCATION = T29.GEOUNITID 00033401
LEFT OUTER JOIN 00033501
VDPS2.VTINSTRFLATSYMBOLS T210 00033601
ON (T2.NOMINALCURR = T210.INSTRUMENTID 00033701
AND T210.CATEGORYVDPS = '10') 00033801
LEFT OUTER JOIN 00033901
VDPS2.VTINSTRFLATSYMBOLS T212 00034001
ON T2.UNDERINSTRUMENT = T212.INSTRUMENTID 00034101
LEFT OUTER JOIN 00034201
VDPS2.VTINSTRFLATSYMBOLS T211 00034301
ON (T2.REPAYPRICECURR = T211.INSTRUMENTID 00034401
AND T211.CATEGORYVDPS = '10') 00034501
LEFT OUTER JOIN 00034601
VDPS2.VTINSTRFLATDATA T3 00034701
ON T3.INSTRUMENTID = T2.UNDERINSTRUMENT 00034801
LEFT OUTER JOIN 00034901
VDPS2.VTINSTIFLATSYMBOLS T31 00035001
ON (T3.CSMAINPARENTTRADINGPLACE = T31.INSTITUTIONID 00035101
AND T31.CATEGORYVDPS = '104') 00035201
LEFT OUTER JOIN 00035301
VDPS2.VTINSTRFLATSYMBOLS T32 00035401
ON (T3.CSMAINTRADINGCURR = T32.INSTRUMENTID 00035501
AND T32.CATEGORYVDPS = '10') 00035601
LEFT OUTER JOIN 00035701
VDPS2.VTINSTIFLATSYMBOLS T33 00035801
ON (T3.CSMAINTRADPLACE = T33.INSTITUTIONID 00035901
AND T32.CATEGORYVDPS = '104') 00036001
LEFT OUTER JOIN 00036101
VDPS2.VTINSTRFLATSYMBOLS T34 00036201
ON T3.CSRISINSTRUMENT = T34.INSTRUMENTID 00036301
LEFT OUTER JOIN 00036401
OA1A.TVV_VTGEOUNITFLATSYMBOLS T35 00036501
ON T3.CSRISKCOUNTRY = T35.GEOUNITID 00036601
LEFT OUTER JOIN 00036701
VDPS2.VTINSTRFLATSYMBOLS T36 00036801
ON (T3.CSRISKCURRENCY = T36.INSTRUMENTID 00036901
AND T36.CATEGORYVDPS = '10') 00037001
LEFT OUTER JOIN 00037101
VDPS2.VTINSTRFLATSYMBOLS T37 00037201
ON (T3.EXERCISECURR = T37.INSTRUMENTID 00037301
AND T37.CATEGORYVDPS = '10') 00037401
LEFT OUTER JOIN 00037501
VDPS2.VTINSTRFLATSYMBOLS T38 00037601
ON (T3.ISSUEPRICECURR = T38.INSTRUMENTID 00037701
AND T38.CATEGORYVDPS = '10') 00037801
LEFT OUTER JOIN 00037901
OA1A.TVV_VTGEOUNITFLATSYMBOLS T39 00038001
ON T3.MOSTLIQUIDMARKETLOCATION = T39.GEOUNITID 00038101
LEFT OUTER JOIN 00038201
VDPS2.VTINSTRFLATSYMBOLS T310 00038301
ON (T3.NOMINALCURR = T310.INSTRUMENTID 00038401
AND T310.CATEGORYVDPS = '10') 00038501
LEFT OUTER JOIN 00038601
VDPS2.VTINSTRFLATSYMBOLS T311 00038701
ON (T3.REPAYPRICECURR = T311.INSTRUMENTID 00038801
AND T311.CATEGORYVDPS = '10') 00038901
LEFT OUTER JOIN 00039001
VDPS2.VTINSTRFLATSYMBOLS T312 00039101
ON T3.UNDERINSTRUMENT = T312.INSTRUMENTID 00039201
LEFT OUTER JOIN 00039301
VDPS2.VTISSUECONDITION T4 00039401
ON T4.INSTRUMENTID = T1.INSTRUMENTID AND T4.PROVIDER1ID = 00039501
'1' 00039601
WHERE T1.ROWSTATUS = 1 00039701
-- AND T1.SYMBOLCH = '1213853' 00039805
fetch first 1000 rows only 00039905
; 00040001
select * from plan_view2 00040101
order by applname, progname, queryNo, qblockno, planno 00040201
; 00040301
rollback 00040401
;x; 00040501
-- dynmaic sql without mqt, nidhi 26.8 00040600
-- EXPLAIN ALL SET QUERYNO=300 FOR 00040700
SELECT T1.INSTRUMENTID, T1.ROWSTATUS, T1.SYMBOLCSFI, T1.SYMBOLCH, 00041000
T1.SYMBOLISIN, T1.SYMBOLUS, T1.SYMBOLXS, T1.SYMBOLGB, 00050000
T1.SYMBOLLU, T1.SYMBOLDE, T1.SYMBOLAT, T1.SYMBOLFR, 00060000
T1.SYMBOLBE, T1.SYMBOLIT, T1.SYMBOLNL, T1.SYMBOLJP, 00070000
T1.SYMBOLJ2, T1.SYMBOLDK, T1.SYMBOLSE, T1.SYMBOLI2, 00080000
T1.SYMBOLI1, T1.SYMBOLT1, T1.SYMBOLT2, T1.SYMBOLCSCURR, 00090000
T1.CATEGORYVDPS, T1.CATEGORYTKT, T1.CATEGORYTKSK, 00100000
T1.CATEGORYTKZUS, T1.CATEGORYTKPRK, T1.CATEGORYTKTZ, 00110000
T1.CATEGORYMAZU, T1.CATEGORYECBTR, T1.CATEGORYCFI, 00120000
T1.CATEGORYEUZS, T1.CATEGORYCSGTA, T1.CATEGORYCSGMS, 00130000
T1.CATEGUSTAXREPORT, T1.CATEGUSIRSADDITION, 00140000
T1.CSSTATUSTYPE CSSTATUSTYPE_FLTSYMB, 00150000
T1.STATUSTYPE STATUSTYPE_FLTSYMB, T2.PAYFREQUENCY, 00160000
T2.ISCALLFORTXREONLY, T2.ISREDEEMABLE, T2.ISRETRACTABLE, 00170000
T2.ISCONVERTBYHOLDER, T2.ISCONVERTBYISSUER, 00180000
T2.HASVOTINGRIGHTNO, T2.HASREDMPINVARCURR, 00190000
T2.HASMULTIUNDERLYERS, T2.CSMAINTRADPLACE, 00200000
T2.ORIGINALISSUER, T2.ISSUER, T2.UNDERINSTRUMENT, 00210000
T2.NOMINALCURR, T2.CSRISKCURRENCY, T2.CSRISKCOUNTRY, 00220000
T2.CSRISINSTRUMENT, T2.REPAYPRICECURR, T2.ISSUEPRICECURR, 00230000
T2.EXERCISECURR, T2.MAINDEPOSITARY, T2.NOMINALAMOUNT, 00240000
T2.MINDENOMINATION, T2.EFFINTERESTRATE, 00250000
T2.REPAYPRICEAMOUNT, T2.REPAYPRICERATE, T2.POOLFACTOR, 00260000
T2.VOTINGRIGHTNO, T2.OUTSTANDINGCAPITAL, T2.ISSUEDCAPITAL, 00270000
T2.OUTSTANDCAPITALNO, T2.ISSUEDCAPITALNO, T2.ISSUEAMOUNT, 00280000
T2.ISSUEPRICE, T2.EXERCISEAMOUNT, T2.MINEXERCISEAMOUNT, 00290000
T2.HELDAMOUNT, T2.PAYAMOUNT, T2.INCOMETAXRATE, 00300000
T2.PREMIUMRATE, T2.PARTICIPATIONRATE, T2.REBATE, 00310000
T2.CSRATING, T2.CSRISKINDIDSYMBOL, T2.CSRISKINDSCHEMESYM, 00320000
T2.CSRISKINSTGRPIDSYM, T2.CSRISKINSGRPSCHSYM, T2.MDYRATING, 00330000
T2.SPRATING, T2.LISTINGSYMBOLTKH, T2.LISTINGSYMBOLRIC, 00340000
T2.LISTINGSYMBOLBBI, T210.SYMBOLI1 NOMINALCURR_I1, 00350000
T210.SYMBOLI2 NOMINALCURR_I2, 00360000
T210.SYMBOLCSCURR NOMINALCURR_WS80, 00370000
T26.SYMBOLI1 CSRISKCURRENCY_I1, 00380000
T26.SYMBOLI2 CSRISKCURRENCY_I2, 00390000
T26.SYMBOLCSCURR CSRISKCURRENCY_WS80, 00400000
T24.SYMBOLCH CSRISINSTRUMENT_CH, 00410000
T24.SYMBOLISIN CSRISINSTRUMENT_ISIN, 00420000
T24.SYMBOLCSFI CSRISINSTRUMENT_CSFI, 00430000
T25.SYMBOLISOA2 CSRISKCOUNTRY_A2, 00440000
T25.SYMBOLCSWS80DOM CSRISKCOUNTRY_WS80, 00450000
T211.SYMBOLI1 REPAYPRICECURR_I1, 00460000
T211.SYMBOLI2 REPAYPRICECURR_I2, 00470000
T211.SYMBOLCSCURR REPAYPRICECURR_WS80, 00480000
T28.SYMBOLI1 ISSUEPRICECURR_I1, 00490000
T28.SYMBOLI2 ISSUEPRICECURR_I2, 00500000
T28.SYMBOLCSCURR ISSUEPRICECURR_WS80, 00510000
T27.SYMBOLI1 EXERCISECURR_I1, T27.SYMBOLI2 EXERCISECURR_I2, 00520000
T27.SYMBOLCSCURR EXERCISECURR_WS80, 00530000
T23.SYMBOLBCN CSMAINTRADPLACE_BCN, 00540000
T23.SYMBOLCSWS80BPL CSMAINTRADPLACE_WS80, 00550000
T23.SYMBOLRTX CSMAINTRADPLACE_RTX, 00560000
T23.SYMBOLBBX CSMAINTRADPLACE_BBX, 00570000
T212.SYMBOLCH UNDERINSTRUMENT_CH, 00580000
T212.SYMBOLISIN UNDERINSTRUMENT_ISIN, 00590000
T212.SYMBOLCSFI UNDERINSTRUMENT_CSFI, T2.ORIGINALISSUER_GK, 00600000
T2.ISSUER_GK, T2.MAINDEPOSITARY_GK, T2.EXPIRATIONDATE, 00610000
T2.MATURITYDATE, T2.FIRSTPAYDATE, T2.FIRSTPYDATEPERYEAR, 00620000
T2.INTRSTDVDENFRDATE, T2.CSRATINGDATE, T2.MDYRATINGDATE, 00630000
T2.SPRATINGDATE, T2.SUBSCRBEGINDATE, T2.PAYMENTDATE, 00640000
T2.EXERCISEBEGINDATE, T2.SUBSCRPLNDENDDATE, 00650000
T2.EXERCISEENDDATE, T2.BVGTYPE, T2.CREDITWORTHINESSTP, 00660000
T2.COMMISSIONCODETYPE, T2.UNITTYPE, T2.CSUNITTYPE, 00670000
T2.EXPIRATIONTYPE, T2.STATUSTYPE, T2.REGISTRATIONTYPE, 00680000
T2.BORROWERCATTYPE, T2.CSLISTINGCODETYPE, T2.CSSTATUSTYPE, 00690000
T2.STATUSDETAILTYPE, T2.INCOMEMODETYPE, 00700000
T2.INTERESTCALCTYPE, T2.INTERESTTYPE, T2.PYFREQUNITTYPE, 00710000
T2.SUBSCRMETHODTYPE, T2.PLACEMENTTYPE, T2.PAYDIRECTIONTYPE, 00720000
T2.OPTIONTYPE, T2.SETTLESTYLETYPE, T2.CSFUNDTYPE, 00730000
T2.TRADINGSTATUSTYPE, T2.LISTINGSTATUSTYPE, 00740000
T2.EXERCISEPLACE, T2.NAME35_G, T2.NAME35_E, T2.NAME35_F, 00750000
T2.NAME35_I, T2.NAME35_N, T2.NAME45_G, T2.NAME45_E, 00760000
T2.NAME45_F, T2.NAME45_I, T2.NAME45_N, T2.SHORTNAME_G, 00770000
T2.SHORTNAME_E, T2.SHORTNAME_F, T2.SHORTNAME_I, 00780000
T2.SHORTNAME_N, T2.PREPARTICLE_G, T2.PREPARTICLE_E, 00790000
T2.PREPARTICLE_F, T2.PREPARTICLE_I, T2.PREPARTICLE_N, 00800000
T2.POSTPARTICLE_G, T2.POSTPARTICLE_E, T2.POSTPARTICLE_F, 00810000
T2.POSTPARTICLE_I, T2.POSTPARTICLE_N, T2.ISINTERNAL, 00820000
T2.ISOTC, T2.HASWITHHOLDINGTAX, T2.HASFEDERALSTAMPDUTY, 00830000
T2.ISCSMIFIDCOMPLEX, T2.MOSTLIQUIDMARKETLOCATION, 00840000
T29.SYMBOLISOA2 MOSTLIQUIDMARKETLOCATION_A2, 00850000
T29.SYMBOLISOA3 MOSTLIQUIDMARKETLOCATION_A3, 00860000
T29.SYMBOLCSWS80DOM MOSTLIQUIDMARKETLOCATION_WS80, 00870000
T2.MDYWATCHLISTSTATUSTYPE, T2.SPWATCHLISTSTATUSTYPE, 00880000
T2.OPTIONSTYLETYPE, T2.CSMAINTRADINGCURR, 00890000
T22.SYMBOLI1 CSMAINTRADINGCURR_I1, 00900000
T22.SYMBOLI2 CSMAINTRADINGCURR_I2, 00910000
T22.SYMBOLCSCURR CSMAINTRADINGCURR_WS80, 00920000
T25.SYMBOLISOA3 CSRISKCOUNTRY_A3, T2.LIQUIDATIONRIGHTTYPE, 00930000
T2.CSMAINPARENTTRADINGPLACE, 00940000
T21.SYMBOLBCN CSMAINPARENTTRADINGPLACE_BCN, 00950000
T21.SYMBOLRTX CSMAINPARENTTRADINGPLACE_RTX, 00960000
T21.SYMBOLMIC CSMAINPARENTTRADINGPLACE_MIC, 00970000
T21.SYMBOLBBX CSMAINPARENTTRADINGPLACE_BBX, 00980000
T21.SYMBOLCSWS80BPL CSMAINPARENTTRADINGPLACE_WS80, 00990000
T3.PAYFREQUENCY UND_PAYFREQUENCY, 01000000
T3.ISCALLFORTXREONLY UND_ISCALLFORTXREONLY, 01010000
T3.ISREDEEMABLE UND_ISREDEEMABLE, 01020000
T3.ISRETRACTABLE UND_ISRETRACTABLE, 01030000
T3.ISCONVERTBYHOLDER UND_ISCONVERTBYHOLDER, 01040000
T3.ISCONVERTBYISSUER UND_ISCONVERTBYISSUER, 01050000
T3.HASVOTINGRIGHTNO UND_HASVOTINGRIGHTNO, 01060000
T3.HASREDMPINVARCURR UND_HASREDMPINVARCURR, 01070000
T3.HASMULTIUNDERLYERS UND_HASMULTIUNDERLYERS, 01080000
T3.CSMAINTRADPLACE UND_CSMAINTRADPLACE, 01090000
T3.ORIGINALISSUER UND_ORIGINALISSUER, T3.ISSUER UND_ISSUER, 01100000
T3.UNDERINSTRUMENT UND_UNDERINSTRUMENT, 01110000
T3.NOMINALCURR UND_NOMINALCURR, 01120000
T3.CSRISKCURRENCY UND_CSRISKCURRENCY, 01130000
T3.CSRISKCOUNTRY UND_CSRISKCOUNTRY, 01140000
T3.CSRISINSTRUMENT UND_CSRISINSTRUMENT, 01150000
T3.REPAYPRICECURR UND_REPAYPRICECURR, 01160000
T3.ISSUEPRICECURR UND_ISSUEPRICECURR, 01170000
T3.EXERCISECURR UND_EXERCISECURR, 01180000
T3.MAINDEPOSITARY UND_MAINDEPOSITARY, 01190000
T3.NOMINALAMOUNT UND_NOMINALAMOUNT, 01200000
T3.MINDENOMINATION UND_MINDENOMINATION, 01210000
T3.EFFINTERESTRATE UND_EFFINTERESTRATE, 01220000
T3.REPAYPRICEAMOUNT UND_REPAYPRICEAMOUNT, 01230000
T3.REPAYPRICERATE UND_REPAYPRICERATE, 01240000
T3.POOLFACTOR UND_POOLFACTOR, 01250000
T3.VOTINGRIGHTNO UND_VOTINGRIGHTNO, 01260000
T3.OUTSTANDINGCAPITAL UND_OUTSTANDINGCAPITAL, 01270000
T3.ISSUEDCAPITAL UND_ISSUEDCAPITAL, 01280000
T3.OUTSTANDCAPITALNO UND_OUTSTANDCAPITALNO, 01290000
T3.ISSUEDCAPITALNO UND_ISSUEDCAPITALNO, 01300000
T3.ISSUEAMOUNT UND_ISSUEAMOUNT, 01310000
T3.ISSUEPRICE UND_ISSUEPRICE, 01320000
T3.EXERCISEAMOUNT UND_EXERCISEAMOUNT, 01330000
T3.MINEXERCISEAMOUNT UND_MINEXERCISEAMOUNT, 01340000
T3.HELDAMOUNT UND_HELDAMOUNT, T3.PAYAMOUNT UND_PAYAMOUNT, 01350000
T3.INCOMETAXRATE UND_INCOMETAXRATE, 01360000
T3.PREMIUMRATE UND_PREMIUMRATE, 01370000
T3.PARTICIPATIONRATE UND_PARTICIPATIONRATE, 01380000
T3.REBATE UND_REBATE, T3.CSRATING UND_CSRATING, 01390000
T3.CSRISKINDIDSYMBOL UND_CSRISKINDIDSYMBOL, 01400000
T3.CSRISKINDSCHEMESYM UND_CSRISKINDSCHEMESYM, 01410000
T3.CSRISKINSTGRPIDSYM UND_CSRISKINSTGRPIDSYM, 01420000
T3.CSRISKINSGRPSCHSYM UND_CSRISKINSGRPSCHSYM, 01430000
T3.MDYRATING UND_MDYRATING, T3.SPRATING UND_SPRATING, 01440000
T3.FITCHRATING UND_FITCHRATING, 01450000
T3.LISTINGSYMBOLTKH UND_LISTINGSYMBOLTKH, 01460000
T3.LISTINGSYMBOLRIC UND_LISTINGSYMBOLRIC, 01470000
T3.LISTINGSYMBOLBBI UND_LISTINGSYMBOLBBI, 01480000
T310.SYMBOLI1 UND_NOMINALCURR_I1, 01490000
T310.SYMBOLI2 UND_NOMINALCURR_I2, 01500000
T310.SYMBOLCSCURR UND_NOMINALCURR_WS80, 01510000
T36.SYMBOLI1 UND_CSRISKCURRENCY_I1, 01520000
T36.SYMBOLI2 UND_CSRISKCURRENCY_I2, 01530000
T36.SYMBOLCSCURR UND_CSRISKCURRENCY_WS80, 01540000
T34.SYMBOLCH UND_CSRISINSTRUMENT_CH, 01550000
T34.SYMBOLISIN UND_CSRISINSTRUMENT_ISIN, 01560000
T34.SYMBOLCSFI UND_CSRISINSTRUMENT_CSFI, 01570000
T35.SYMBOLISOA2 UND_CSRISKCOUNTRY_A2, 01580000
T35.SYMBOLCSWS80DOM UND_CSRISKCOUNTRY_WS80, 01590000
T311.SYMBOLI1 UND_REPAYPRICECURR_I1, 01600000
T311.SYMBOLI2 UND_REPAYPRICECURR_I2, 01610000
T311.SYMBOLCSCURR UND_REPAYPRICECURR_WS80, 01620000
T38.SYMBOLI1 UND_ISSUEPRICECURR_I1, 01630000
T38.SYMBOLI2 UND_ISSUEPRICECURR_I2, 01640000
T38.SYMBOLCSCURR UND_ISSUEPRICECURR_WS80, 01650000
T37.SYMBOLI1 UND_EXERCISECURR_I1, 01660000
T37.SYMBOLI2 UND_EXERCISECURR_I2, 01670000
T37.SYMBOLCSCURR UND_EXERCISECURR_WS80, 01680000
T33.SYMBOLBCN UND_CSMAINTRADPLACE_BCN, 01690000
T33.SYMBOLCSWS80BPL UND_CSMAINTRADPLACE_WS80, 01700000
T33.SYMBOLRTX UND_CSMAINTRADPLACE_RTX, 01710000
T33.SYMBOLBBX UND_CSMAINTRADPLACE_BBX, 01720000
T312.SYMBOLCH UND_UNDERINSTRUMENT_CH, 01730000
T312.SYMBOLISIN UND_UNDERINSTRUMENT_ISIN, 01740000
T312.SYMBOLCSFI UND_UNDERINSTRUMENT_CSFI, 01750000
T3.ORIGINALISSUER_GK UND_ORIGINALISSUER_GK, 01760000
T3.ISSUER_GK UND_ISSUER_GK, 01770000
T3.MAINDEPOSITARY_GK UND_MAINDEPOSITARY_GK, 01780000
T3.EXPIRATIONDATE UND_EXPIRATIONDATE, 01790000
T3.MATURITYDATE UND_MATURITYDATE, 01800000
T3.FIRSTPAYDATE UND_FIRSTPAYDATE, 01810000
T3.FIRSTPYDATEPERYEAR UND_FIRSTPYDATEPERYEAR, 01820000
T3.INTRSTDVDENFRDATE UND_INTRSTDVDENFRDATE, 01830000
T3.CSRATINGDATE UND_CSRATINGDATE, 01840000
T3.MDYRATINGDATE UND_MDYRATINGDATE, 01850000
T3.SPRATINGDATE UND_SPRATINGDATE, 01860000
T3.FITCHRATINGDATE UND_FITCHRATINGDATE, 01870000
T3.SUBSCRBEGINDATE UND_SUBSCRBEGINDATE, 01880000
T3.PAYMENTDATE UND_PAYMENTDATE, 01890000
T3.EXERCISEBEGINDATE UND_EXERCISEBEGINDATE, 01900000
T3.SUBSCRPLNDENDDATE UND_SUBSCRPLNDENDDATE, 01910000
T3.EXERCISEENDDATE UND_EXERCISEENDDATE, 01920000
T3.BVGTYPE UND_BVGTYPE, 01930000
T3.CREDITWORTHINESSTP UND_CREDITWORTHINESSTP, 01940000
T3.COMMISSIONCODETYPE UND_COMMISSIONCODETYPE, 01950000
T3.UNITTYPE UND_UNITTYPE, T3.CSUNITTYPE UND_CSUNITTYPE, 01960000
T3.EXPIRATIONTYPE UND_EXPIRATIONTYPE, 01970000
T3.STATUSTYPE UND_STATUSTYPE, 01980000
T3.REGISTRATIONTYPE UND_REGISTRATIONTYPE, 01990000
T3.BORROWERCATTYPE UND_BORROWERCATTYPE, 02000000
T3.CSLISTINGCODETYPE UND_CSLISTINGCODETYPE, 02010000
T3.CSSTATUSTYPE UND_CSSTATUSTYPE, 02020000
T3.STATUSDETAILTYPE UND_STATUSDETAILTYPE, 02030000
T3.INCOMEMODETYPE UND_INCOMEMODETYPE, 02040000
T3.INTERESTCALCTYPE UND_INTERESTCALCTYPE, 02050000
T3.INTERESTTYPE UND_INTERESTTYPE, 02060000
T3.PYFREQUNITTYPE UND_PYFREQUNITTYPE, 02070000
T3.SUBSCRMETHODTYPE UND_SUBSCRMETHODTYPE, 02080000
T3.PLACEMENTTYPE UND_PLACEMENTTYPE, 02090000
T3.PAYDIRECTIONTYPE UND_PAYDIRECTIONTYPE, 02100000
T3.OPTIONTYPE UND_OPTIONTYPE, 02110000
T3.SETTLESTYLETYPE UND_SETTLESTYLETYPE, 02120000
T3.CSFUNDTYPE UND_CSFUNDTYPE, 02130000
T3.TRADINGSTATUSTYPE UND_TRADINGSTATUSTYPE, 02140000
T3.LISTINGSTATUSTYPE UND_LISTINGSTATUSTYPE, 02150000
T3.EXERCISEPLACE UND_EXERCISEPLACE, 02160000
T3.NAME35_G UND_NAME35_G, T3.NAME35_E UND_NAME35_E, 02170000
T3.NAME35_F UND_NAME35_F, T3.NAME35_I UND_NAME35_I, 02180000
T3.NAME35_N UND_NAME35_N, T3.NAME45_G UND_NAME45_G, 02190000
T3.NAME45_E UND_NAME45_E, T3.NAME45_F UND_NAME45_F, 02200000
T3.NAME45_I UND_NAME45_I, T3.NAME45_N UND_NAME45_N, 02210000
T3.SHORTNAME_G UND_SHORTNAME_G, 02220000
T3.SHORTNAME_E UND_SHORTNAME_E, 02230000
T3.SHORTNAME_F UND_SHORTNAME_F, 02240000
T3.SHORTNAME_I UND_SHORTNAME_I, 02250000
T3.SHORTNAME_N UND_SHORTNAME_N, 02260000
T3.PREPARTICLE_G UND_PREPARTICLE_G, 02270000
T3.PREPARTICLE_E UND_PREPARTICLE_E, 02280000
T3.PREPARTICLE_F UND_PREPARTICLE_F, 02290000
T3.PREPARTICLE_I UND_PREPARTICLE_I, 02300000
T3.PREPARTICLE_N UND_PREPARTICLE_N, 02310000
T3.POSTPARTICLE_G UND_POSTPARTICLE_G, 02320000
T3.POSTPARTICLE_E UND_POSTPARTICLE_E, 02330000
T3.POSTPARTICLE_F UND_POSTPARTICLE_F, 02340000
T3.POSTPARTICLE_I UND_POSTPARTICLE_I, 02350000
T3.POSTPARTICLE_N UND_POSTPARTICLE_N, 02360000
T3.ISINTERNAL UND_ISINTERNAL, T3.ISOTC UND_ISOTC, 02370000
T3.HASWITHHOLDINGTAX UND_UND_HASWITHHOLDINGTAX, 02380000
T3.HASFEDERALSTAMPDUTY UND_HASFEDERALSTAMPDUTY, 02390000
T3.ISCSMIFIDCOMPLEX UND_ISCSMIFIDCOMPLEX, 02400000
T3.MOSTLIQUIDMARKETLOCATION UND_MOSTLQDMARKETLOCATION, 02410000
T39.SYMBOLISOA2 UND_MOSTLQDMARKETLOCATION_A2, 02420000
T39.SYMBOLISOA3 UND_MOSTLQDMARKETLOCATION_A3, 02430000
T39.SYMBOLCSWS80DOM UND_MOSTLQDMARKETLOCATION_WS80, 02440000
T3.MDYWATCHLISTSTATUSTYPE UND_MDYWATCHLISTSTATUSTYPE, 02450000
T3.SPWATCHLISTSTATUSTYPE UND_SPWATCHLISTSTATUSTYPE, 02460000
T3.FITCHWATCHLISTSTATUSTYPE UND_FITCHWATCHLISTSTATUSTYPE, 02470000
T3.OPTIONSTYLETYPE UND_OPTIONSTYLETYPE, 02480000
T3.CSMAINTRADINGCURR UND_CSMAINTRADINGCURR, 02490000
T32.SYMBOLI1 UND_CSMAINTRADINGCURR_I1, 02500000
T32.SYMBOLI2 UND_CSMAINTRADINGCURR_I2, 02510000
T32.SYMBOLCSCURR UND_CSMAINTRADINGCURR_WS80, 02520000
T35.SYMBOLISOA3 UND_CSRISKCOUNTRY_A3, 02530000
T3.LIQUIDATIONRIGHTTYPE UND_LIQUIDATIONRIGHTTYPE, 02540000
T3.CSMAINPARENTTRADINGPLACE UND_CSMAINPTRADINGPLACE, 02550000
T31.SYMBOLBCN UND_CSMAINPTRADINGPLACE_BCN, 02560000
T31.SYMBOLRTX UND_CSMAINPTRADINGPLACE_RTX, 02570000
T31.SYMBOLMIC UND_CSMAINPTRADINGPLACE_MIC, 02580000
T31.SYMBOLBBX UND_CSMAINPTRADINGPLACE_BBX, 02590000
T31.SYMBOLCSWS80BPL UND_CSMAINPTRADINGPLACE_WS80, 02600000
T4.ISSUECONDITIONNO, T4.AMOUNT, T4.PROVIDER1ID, T4.PRICE, 02610000
T4.PROVIDER2ID, T4.PRICEUNITAMOUNT, T4.PROVIDER3ID, 02620000
T4.PRICERANGEFROM, T4.ISINDIVPAYMENT, T4.PRICERANGETO, 02630000
T4.HASPREFSUBSCRRIGHT, T4.MAXAMOUNT, T4.ISTAXED, 02640000
T4.MINAMOUNT, T4.ISSUINGINSTITUTION, T4.TAXAMOUNT, 02650000
T4.SUBSCRLOCATION, T4.MINSUBSCRAMOUNT, T4.ACCRINTERESTCURR, 02660000
T4.MINSUBSCRINCREMENT, T4.PRICECURR, T4.PLACEMENTPRICE, 02670000
T4.ROUNDOFFAMOUNT, T4.ACCRINTERESTAMOUNT, 02680000
T4.NOOFSECURITIES, T4.ROUNDOFFRULETYPE, T4.TAXVALUE, 02690000
T4.STATUSTYPE ISSUE_STATUSTYPE, T4.YIELD, T4.PRICETYPE, 02700000
T4.ACCRUEDINTEREST, T4.PRICEUNITTYPE, T4.INCOMESTARTDATE, 02710000
T4.QUOTATIONTYPE, T4.ACCRINTRSTFROMDATE, T4.PAYMENTTYPE, 02720000
T4.PAYMENTFROMDATE, T4.PAYMENTUNTILDATE, 02730000
T4.PRICEFIXINGDATE, T4.TAXTYPE, T4.SUBSCREFFENDDATE, 02740000
T4.ISSUEAMOUNTTYPE, T4.ISSUETYPE, T4.PUBLICATION_I, 02750000
T4.OVERSUBSCRRIGHTTP, T4.DESCRIPTION_N, T4.PROVISIONTYPE, 02760000
T4.PUBLICATION_N, T4.SUBSCRPERIODTYPE, T4.TAXCURRENCY, 02770000
T4.SUBSCRIPTIONPLACE, T4.TAXQUOTETYPE, T4.DESCRIPTION_G, 02780000
T4.TAXUNITTYPE, T4.PUBLICATION_G, T4.SYNTHETICPRICECURR, 02790000
T4.DESCRIPTION_E, T4.SYNTHETICPRICEAMOUNT, 02800000
T4.PUBLICATION_E, T4.SYNTHETICPRICERATE, T4.DESCRIPTION_F, 02810000
T4.IPOTIMINGTYPE, T4.PUBLICATION_F, T4.IPOFILINGDATE, 02820000
T4.DESCRIPTION_I, T4.IPODATE, T4.CSIPODESCRIPTION, 02830000
T4.CSIPOCOMPANYDESCRIPTION, 02840000
T4.CSSUBSCRIPTIONPLANNEDENDDATE, T4.FIRSTTRADINGDATE, 02850000
T4.EXPECTEDALLOCATIONDATE, T4.ISISSUEINCREASABLE, 02860000
T4.INITIALPRICINGBEGINDATE, T4.INITIALPRICINGENDDATE, 02870000
T4.INITIALPRICINGFUNCTIONTYPE, T4.FINALPRICINGBEGINDATE, 02880000
T4.FINALPRICINGENDDATE, T4.FINALPRICINGFUNCTIONTYPE, 02890000
T4.SUBSCRPLNDENDDATE ISSUE_SUBSCRPLNDENDDATE, 02900000
T4.INTERESTCALCTYPE ISSUE_INTERESTCALCTYPE, 02910000
T4.SUBSCRMETHODTYPE ISSUE_SUBSCRMETHODTYPE, 02920000
T4.PAYMENTDATE ISSUE_PAYMENTDATE, 02930000
T4.SUBSCRBEGINDATE ISSUE_SUBSCRBEGINDATE, 02940000
T4.PLACEMENTTYPE ISSUE_PLACEMENTTYPE, T4.CSISSUEDESK 02950000
FROM VDPS2.VTINSTRFLATSYMBOLS T1 02960000
INNER JOIN 02970000
VDPS2.VTINSTRFLATDATA T2 02980000
ON T2.INSTRUMENTID = T1.INSTRUMENTID 02990000
LEFT OUTER JOIN 03000000
VDPS2.VTINSTIFLATSYMBOLS T21 03010000
ON T2.CSMAINPARENTTRADINGPLACE = T21.INSTITUTIONID 03020000
LEFT OUTER JOIN 03030000
VDPS2.VTINSTRFLATSYMBOLS T22 03040000
ON T2.CSMAINTRADINGCURR = T22.INSTRUMENTID 03050000
LEFT OUTER JOIN 03060000
VDPS2.VTINSTIFLATSYMBOLS T23 03070000
ON T2.CSMAINTRADPLACE = T23.INSTITUTIONID 03080000
LEFT OUTER JOIN 03090000
VDPS2.VTINSTRFLATSYMBOLS T24 03100000
ON T2.CSRISINSTRUMENT = T24.INSTRUMENTID 03110000
LEFT OUTER JOIN 03120000
OA1A.TVV_VTGEOUNITFLATSYMBOLS T25 03130000
ON T2.CSRISKCOUNTRY = T25.GEOUNITID 03140000
LEFT OUTER JOIN 03150000
VDPS2.VTINSTRFLATSYMBOLS T26 03160000
ON T2.CSRISKCURRENCY = T26.INSTRUMENTID 03170000
LEFT OUTER JOIN 03180000
VDPS2.VTINSTRFLATSYMBOLS T27 03190000
ON T2.EXERCISECURR = T27.INSTRUMENTID 03200000
LEFT OUTER JOIN 03210000
VDPS2.VTINSTRFLATSYMBOLS T28 03220000
ON T2.ISSUEPRICECURR = T28.INSTRUMENTID 03230000
LEFT OUTER JOIN 03240000
OA1A.TVV_VTGEOUNITFLATSYMBOLS T29 03250000
ON T2.MOSTLIQUIDMARKETLOCATION = T29.GEOUNITID 03260000
LEFT OUTER JOIN 03270000
VDPS2.VTINSTRFLATSYMBOLS T210 03280000
ON T2.NOMINALCURR = T210.INSTRUMENTID 03290000
LEFT OUTER JOIN 03300000
VDPS2.VTINSTRFLATSYMBOLS T212 03310000
ON T2.UNDERINSTRUMENT = T212.INSTRUMENTID 03320000
LEFT OUTER JOIN 03330000
VDPS2.VTINSTRFLATSYMBOLS T211 03340000
ON T2.REPAYPRICECURR = T211.INSTRUMENTID 03350000
LEFT OUTER JOIN 03360000
VDPS2.VTINSTRFLATDATA T3 03370000
ON T3.INSTRUMENTID = T2.UNDERINSTRUMENT 03380000
LEFT OUTER JOIN 03390000
VDPS2.VTINSTIFLATSYMBOLS T31 03400000
ON T3.CSMAINPARENTTRADINGPLACE = T31.INSTITUTIONID 03410000
LEFT OUTER JOIN 03420000
VDPS2.VTINSTRFLATSYMBOLS T32 03430000
ON T3.CSMAINTRADINGCURR = T32.INSTRUMENTID 03440000
LEFT OUTER JOIN 03450000
VDPS2.VTINSTIFLATSYMBOLS T33 03460000
ON T3.CSMAINTRADPLACE = T33.INSTITUTIONID 03470000
LEFT OUTER JOIN 03480000
VDPS2.VTINSTRFLATSYMBOLS T34 03490000
ON T3.CSRISINSTRUMENT = T34.INSTRUMENTID 03500000
LEFT OUTER JOIN 03510000
OA1A.TVV_VTGEOUNITFLATSYMBOLS T35 03520000
ON T3.CSRISKCOUNTRY = T35.GEOUNITID 03530000
LEFT OUTER JOIN 03540000
VDPS2.VTINSTRFLATSYMBOLS T36 03550000
ON T3.CSRISKCURRENCY = T36.INSTRUMENTID 03560000
LEFT OUTER JOIN 03570000
VDPS2.VTINSTRFLATSYMBOLS T37 03580000
ON T3.EXERCISECURR = T37.INSTRUMENTID 03590000
LEFT OUTER JOIN 03600000
VDPS2.VTINSTRFLATSYMBOLS T38 03610000
ON T3.ISSUEPRICECURR = T38.INSTRUMENTID 03620000
LEFT OUTER JOIN 03630000
OA1A.TVV_VTGEOUNITFLATSYMBOLS T39 03640000
ON T3.MOSTLIQUIDMARKETLOCATION = T39.GEOUNITID 03650000
LEFT OUTER JOIN 03660000
VDPS2.VTINSTRFLATSYMBOLS T310 03670000
ON T3.NOMINALCURR = T310.INSTRUMENTID 03680000
LEFT OUTER JOIN 03690000
VDPS2.VTINSTRFLATSYMBOLS T311 03700000
ON T3.REPAYPRICECURR = T311.INSTRUMENTID 03710000
LEFT OUTER JOIN 03720000
VDPS2.VTINSTRFLATSYMBOLS T312 03730000
ON T3.UNDERINSTRUMENT = T312.INSTRUMENTID 03740000
LEFT OUTER JOIN 03750000
VDPS2.VTISSUECONDITION T4 03760000
ON T4.INSTRUMENTID = T1.INSTRUMENTID AND T4.PROVIDER1ID = 03770000
'1' 03780000
WHERE T1.ROWSTATUS = 1 03790000
AND T1.SYMBOLCH = '1213853' 03800000
WITH UR 03810000
; 03820001
select * from plan_view2 03830001
order by applname, progname, queryNo, qblockno, planno 03840001
; 03850001
rollback 03860001
;x; 03870001