Hi,
I am using source_lookup on iSeries database to fetch data from other table. However, the columns contain special characters such as #. The following is a simple source_lookup that is failing to execute:
source_lookup(10000,'SCHEMA','TABLE','COLUMN_NAME','RQMEM#=?',$EMLMEM#)
The Parse expression fails to recognize the # character as a string. I have tried the below as well:
source_lookup(10000,'SCHEMA','TABLE','COLUMN_NAME','RQMEM#=?',$EMLMEM AND CHR(35)) and get this error "no such function CHR". Qlik Replicate
Kindly advise.
