Certain rules and guidelines apply for pushdown optimization to an IBM DB2 database.
Use the following rules and guidelines for pushdown optimization to an IBM DB2 database:
When you apply pushdown optimization to an IBM DB2 database, a session that requires type casting can fail. The session fails if the casting is from float or double to string, or if it requires a type of casting that IBM DB2 databases disallow.
To push TO_DATE() and TO_CHAR() functions to an IBM DB2 database, you must use the following formats: