By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,004 Members | 1,253 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,004 IT Pros & Developers. It's quick & easy.

informix/db2

P: 8
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
Aug 21 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.