Operation Fails with NULL Values Not Supported Error

Problem: The operation fails, and NULL <datatype> values are not currently supported in the Sybase Message Client appears in the WorkflowClient log.

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.

Note: This problem occurs in older applications that have not been migrated to Sybase Unwired Platform version 2.0 or later.

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.