set schema jemshdp51;

select A2W5CF, a2q1tt, hcgpl.convdate(BBKNDT) from ccacidp left join ccecocp on A2W5CF=bbcrcd where A2Z9SW='Y' and BBKNDT>=1110501 and BBKNDT<=1110531