sql prepare in db2 9.7 does not work on db2 9.5

[amidpatil]

We have license db2 9.7 and production is on 9.5 . so when we create sql queries on 9.7 database the code is sucessful but this does not work on 9.5 database and gives error
SQL0401N The data types of the operands for the operation "=" are not
compatible. SQLSTATE=42818


Please help

[Rabbit]

We can't help without seeing the code and knowing the design of the tables. But just from the error message alone, it sounds like you're trying to compare two data types that can't be compared. If it's working on one server but not the other, that probably means the two servers have different table designs.

[Anas Mosaad]

9.7 introduced something called implicit casting which was not supported in prior releases. That's why your code may not backward compatible. You should develop on the same version of your production system.