Skip to Content
Former Member
Oct 19, 2007 at 08:41 AM

Unsupported Relational Operator Types and DB2e 9.1



we are using MAM3.0SR3 and adapt this application. So during SP20 installtion we had to swtich to DB2e 9.1 (Prerequisit). However, know it seams the relational operator type LIKE doesn't work anymore. I also tested similar relational operator types which also don't work anymore:

  • RelationalOperatorType.LIKE_INSENSITIVE (wildcard "*")

  • RelationalOperatorType.LIKE (wildcard "*")

  • RelationalOperatorType.SQL_LIKE (wildcard "*")

  • RelationalOperatorType.IN

All the mentioned operator types producing NullPointerExceptions. I used DB2e 8.2.4 before and there LIKE was working fine (the others I didn't test with DB2e 8.x.x). Now I use CONTAINS.

There exists STARTS_WITH too, but for "ENDS_WITH" is now replacement available (which could realized with LIKE before).

Know anybody of you a SAP note or document, where these restriction are described? And what about ENDS_WITH?

Thanks in advance

Andreas Dommes