When defining an MBO from an Adaptive Server Enterprise datasource, an error message displays if you pass an empty string or empty byte[] into a required binary column in ASE results in an ASE non-nullable column exception.
Error executing on back-end server: java.lang.RuntimeException: java.lang.RuntimeException: com.sybase.jdbc3.jdbc.SybSQLException: The column binary1 in table pubs3.dbo.AllDataTypes does not allow null values.
Execution failed: The column binary1 in table pubs3.dbo.AllDataTypes does not allow null values
Solution: use "IA==" as the default value for the binary(1) argument. Create a new Create operation, and select Test Execute to verify it works correctly.