Problem: An update operation fails if set maxlength for the attribute is less than the length in the enterprise information (EIS) database column.
Explanation: If
rtrim is not used in these cases, the update operation fails with this exception:
com.sybase.vader.da.jdbc.MinCheckAffected
RowCountException.null
Solution: Use the
rtrim function in the SQL statement to update operations for
char datatype columns, such as:
SELECT dept_id,
rtrim(dept_name) as dept_name,
dept_head_id FROM sampledb.dba.department