Unsupported Relational Operator Types and DB2e 9.1

[Former Member]

Hello,

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

[Former Member]

Hi Andreas,

You have to apply note 1044790 .

Regards,

Abhijit

[Former Member]

Hello Abhijit,

thanks a lot for your hint about the SP20 client path 3. It was missing in our component list, but unfortunately dosn't solve the problem.

In the meantime I found, that our database (used is DB2e version 9.1) isn't active. Reason is (I attempt) an incomplete compontent of DB2e Everyplace download, which is first the same as for NetWeaver Mobile 7.1 - we are using Mobile Infrastructure 2.5 SP20 and second the default properties of plugin doesn't interpreted for MI2.5 only for NWM 7.1.

I opened an OSS call for it.

Thanks a lot.

Andreas Dommes

[Former Member]

Hi Andreas,

have a look here - hopefully that helps:

http://publib.boulder.ibm.com/infocenter/db2e/v9r1f1/index.jsp?topic=/com.ibm.db2e.doc/adg/dbeapr111...

Furthermore if the DB is not active - have you tried to deploy it manually?

Regards,

Oliver

Message was edited by: Oliver - sorry, first reply was just wrong.

Oliver Kaluscha

Message was edited by:

Oliver Kaluscha