Operation Fails with NULL Values Not Supported Error

Explanation: The Sybase messaging client cannot differentiate between a NULL value and an empty string. On the device client, there is no way for the user to enter a NULL value for a particular field, so the operation fails.

Solution 1: Modify the MBO definition so that none of its attributes have a NULL value. For example:

select emp_id, dept_id, emp_fname, emp_lname, start_date, termination_date = CASE WHEN termination_date is NULL THEN '9999-01-01' ELSE termination_date END from employee

Solution 2: Add a filter class for the MBO definition to convert the NULL value to a non-null value for attributes.