Hi, I am using the below query in SQLRPGLE
Select count(data) into :cntrec from sample where data like '%' "+:tpnumber+" '%'. I am getting an error "Token "+:tpnmber+" was not valid" .
The tpnumber is a character field(10a). Sample file is a flat file
I even tried '%' +:tpnumber+" '%' and '%' '+:tpnumber+' '%'
What should be the correct format?