tags:

views:

228

answers:

0

hi when i try to execute the query

SELECT DISTINCT DECODE (pd.pr_l50_nm , 'ADVISORY', 'Advisory' , 'EQUITY', 'Equity' , 'DEBT', DECODE (pd.pr_cd, 'BOND-HY', 'Leveraged Finance', 'Debt') , 'LOANS', DECODE (pd.pr_cd, 'IG', 'Loan', 'Leveraged Finance')) EXCO_PRODUCT_NM FROM ibk_dw.PRODUCT_DIM pd WHERE pd.pr_hcy_nm = 'STANDARD' AND pd.pr_dl_in = 'Y' AND pd.PR_DLG_STD_LEAG_IN = 1 AND pd.pr_l50_cd =1

in formala tag of one property i am getting the error from keyword not found !! any idea