Issue in WMB message broker insert to a Sybase Database Table

See more:

database

driver

ODBC

Currently am facing an issue while inserting data in to Sybase database 15.7 with WMB code flow. Am currently using WMB7 Broker and I have written code in our message flow which is trying to insert the data in the table directly rather than using store procedure. The data types used in database table is int and Image. But insert operation is not completing anyways.

Whereas the same message flow code is inserting the data in Database table which is on Sybase 12.5. Also ASE Client is also inserting the data in database directly in to the table.

Again I have changed th DataType for the table from Image to varbinary, So its behaving correctly for small amount of data (within the limit of page size of DB which is 2K in my case), but again its failing for large amount of data.

I have also used text/unitext they all are behaving same as Image data type.

The ODBC version used in WMB7 Broker is
IBM/mqsi/7.0.0.6/ODBC64/V6.0/lib/UKase24.so

I can sense this may be compatibility issue of ODBC drivers which are present in WMB7 Broker. Any kind of direction would be great help