Setting Adaptive Server Enterprise Stored Procedures to Chained or Anymode

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.

  1. Set the stored procedure using either of these methods:
    Option Description
    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' 
GO
    or
    exec sp_procxmode ' < sp name > ', 'CHAINED' 
GO
  2. You can now bind the stored procedure to a mobile business object.
Parent topic: Binding a Database Data Source to a Mobile Business Object