Hi I am using DB2 with IBatis and I need to have a where clause which looks like
But UCASE(#prodCode orName#) is giving an error.
Can anyone tell me how do I use DB2 functions with Ibatis inline parameters.
Thank you.
Code:
WHERE UCASE(ps.DIAN_DESC) like UCASE(#prodCodeorName#)
Can anyone tell me how do I use DB2 functions with Ibatis inline parameters.
Thank you.