Hi,
I am trying to convert informix query to db2.
Here is the informix version of query...
select
sp.src_prod_ofr_no,
k.kfs_mc,
k.group_code,
k.mail_code,
ms.sched_month,
ms.generation_num fund_status,
gi.market_region region,
gi.group_name,
k.source_code,
k.list_num,
bank,
po_cd,
letter_text[1,2],
k.product,
brand,
apr,
atm,
apr_mrg,
atm_mrg,
btr,
end_date,
k.kfs_num,
case
when asso_bank_no[1,1] = 3 then acct_type||"-"||asso_bank_no[7,9]
else acct_type||"-"||asso_bank_no[8,10]
end mbna_bank,
curr_margin_rate1 mbna_apr,
case
when index_id = "FIXED" then null
else margin_rate1
end mbna_aprmrg,
sc.group_code mbna_group_code,
pr.princ_prod mbna_brand,
pr.princ_group mbna_product,
promo_type,
promo_end,
promo_cash_rate mbna_btr,
expire_dt,
ab.member_code,
member_desc
from kfs_file k, source_codes sc, groupinfo gi, src_prod_ofr sp, assobank ab, o%
where
k.source_code = sc.source_code
and k.source_code = sp.source_code
and k.po_cd = sp.prod_ofr_cd
and gi.group_code = sc.group_code
and sp.asso_bank_no = ab.associate_bank
and ((sp.asso_bank_no[1,7] = pr.principal) or (sp.asso_bank_no[1,6] = pr.princi%
and sp.promo_id = p.promo_id
Can anybody help what is the 'o%' and what are the'ms' and 'pr' here and how to write in db2 please...........
Thanks
Sai