In this post, you’ll learn about the error message -309 a predicate is invalid because a referenced host variable has the null value in the IBM DB2 database , the reason why it occurs along with the solution to fix it
IBM DB2 Error Message
-309 a predicate is invalid because a referenced host variable has the null value
Reason for the Error
The statement could not be processed because a host variable appearing in a predicate such as��� column-name = host-variable� had the NULL value.� Such a predicate is not permitted in the case in which the host variable contains the NULL value–even though the object column may in fact contain nulls.
Solution
Rebind the plan or package containing the statement. The condition described is not an error in DB2 Version 2 Release 3 and later.
