CODEWITHSUNDEEP
insertsybasemessagebrokeribm-integration-busextended-sql
WENzER
WENzER

Reputation: 305

Issue in WMB message broker insert to a Sybase Database Table

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.

Can this be a compatibility issue of ODBC drivers which are present in WMB7? Any kind of direction would be great help

Upvotes: 0

Views: 426

Answers (2)

WENzER
WENzER

Reputation: 305

Actually for resolving this issue we have changed the datatype from Image to varbinary in Database Table. And all started working in order

Upvotes: 0

Dave
Dave

Reputation: 633

It could definitely be a driver issue, in the SOE Sybase 15.7 is only listed as supported from 7.0.0.6 onwards:

http://publib.boulder.ibm.com/infocenter/prodguid/v1r0/clarity-reports/report/html/softwareReqsForProduct?deliverableId=1106652668319&osPlatform=AIX#sw-Databases

Are you running on this version?

Upvotes: 0

Related Questions