select p.PARPARROLLEID_PARTNER as PARID, pn.NAME as PNAME, num.monnum as N, SUBSTR(pn.NAME,num.monnum,1) as CHAR_N, ASCII(SUBSTR(pn.NAME,num.monnum,1)) as CODE_N, DUMP(pn.NAME,16,num.monnum,1) as DUMP_N

 from BEPARTNER p

   left outer join BS_PNAME pn on pn.PARID=p.PARPARROLLEID_PARTNER

     left outer join (select cal.MONAT as monnum from CCCAL cal where cal.JAHR=2013) num on 1=1

 where PARPARROLLEID_PARTNER=11497380