You must set Adaptive Server Enterprise stored procedures to either chained mode or Anymode before binding them to a mobile business object, otherwise an error is generated.
Option | Description |
---|---|
DMP stored procedure editor | Open the stored procedure by double-clicking the stored procedure in the Enterprise Explorer, and set the transaction mode in the general page. |
Manually using SQL commands | For example:exec sp_procxmode ' < sp name > ', 'ANYMODE' GOor exec sp_procxmode ' < sp name > ', 'CHAINED' GO |