Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
Getting this error that I cannot figure out when a tas400input step runs into a tmap:
"select fiinst,fddgrp,fdtype,fitype,fiigrp,fdstcd,fdarea,fdbank,fddate,fdmnst,fdmnar,fdmnbk
from data.fpf fpf
left join data.bankinst bi on fpf.fdmnst = bi.qistcd and fpf.fdmnar= bi.qiarea and fpf.fdmnbk = bi.qibank and fpf.fddgrp = bi.qiigrp
join data.instrmst inm on inm.fitype = fpf.fdtype and inm.FIIGRP = fpf.FDDGRP and inm.fiinst = bi.qiinst
where fdstcd = '"+((String)globalMap.get("X.State"))+"'
and fdarea = '"+((Integer)globalMap.get("X.Area"))+"'
and fdbank = '"+((Integer)globalMap.get("X.Bank"))+"'
and fddgrp = '"+((String)globalMap.get"(X.Group"))+"'
and fiinst = '"+((String)globalMap.get("X.ProductCode"))+"'
and fddate = (
Select Max(fddate) from data.fpf fpf
left join data.bankinst bi on fpf.fdmnst = bi.qistcd and fpf.fdmnar= bi.qiarea and fpf.fdmnbk = bi.qibank and fpf.fddgrp = bi.qiigrp
join data.instrmst inm on inm.fitype = fpf.fdtype and inm.FIIGRP = fpf.FDDGRP and inm.fiinst = bi.qiinst
where fdstcd = '"+((String)globalMap.get("X.State"))+"'
and fdarea = '"+((Integer)globalMap.get("X.Area"))+"'
and fdbank = '"+((Integer)globalMap.get("X.Bank"))+"'
and fddgrp = '"+((String)globalMap.get("X.Group"))+"'
and fiinst = '"+((String)globalMap.get("X.ProductCode"))+"'
)
group by fiinst,fddgrp,fdtype,fitype,fiigrp,fdstcd,fdarea,fdbank,fddate,fdmnst,fdmnar,fdmnbk"
Any suggestions please?
Letting community know I figured this out.
There were non compliant characters coming through in the query. I copied and pasted the code from an email and in turn, it brought in odd and invisible characters. I placed the query in notepad++ and stepped through the query and edited it.
Letting community know I figured this out.
There were non compliant characters coming through in the query. I copied and pasted the code from an email and in turn, it brought in odd and invisible characters. I placed the query in notepad++ and stepped through the query and edited it.