Previous Topic: -292 - <nnnn> VARIABLES PROVIDED FOR <nnnn> SELECT LIST COLUMNSNext Topic: -294 - INVALID MIXED DATA IN VALUE ASSIGNED TO column_name


-293 - PREDICATE INVALID BECAUSE HOST VARIABLE <nnn> HAS THE NULL VALUE

Explanation

A host variable used in a predicate cannot have the null value. "nnn" indicates the ordinal position of the host variable.

The SQLSTATE that equates to this SQL return code is 22512.

User Response

Either remove the null indicator variable or set it to zero.