TRANSF_1_1_1> DBG_21263 Invalid lookup override

If you use the Sql override in a lookup, e. g. you want to use mapping parameters, than make sure that the comparison and connected output ports are reflected in the aliases of the query. You do not need to have the complete list of output ports.


Connected lookup



Working sql override

select CODE_CODE as CODE_CODE
     , CODE_CODEART as CODE_CODEART
     , CODE_BESCHREIBUNG as CODE_BESCHREIBUNG
  from KDS_C_CODE_CODEREFERENCE
 where CODE_GUELTIGFLAG = 1
   and CODE_CODEART = '$$CODEART'
   and CODE_BESCHREIBUNG = '$$BESCHREIBUNG_ptsp'

A colleague of mine reported that he experienced in SQ sql overrides mal associated columns to ports when no aliasing of column names was used. I fortunately did not yet experience this behaviour.