Appendix A Executing Methods As Stored Procedures

Configuring the return status

The stored procedure return status of the MASP call reflects the status of the call. By default, the following status values are returned:

• A value of 1 indicates the method was invoked
• A value of 0 indicates that Jaguar was not able to invoke the method. This error can occur for a variety of reasons, such as:
  
  • The syntax was incorrect
  • The specified method, component, or package that did not exist
  • The specified package was not installed on the server, or the user lacked permission to invoke the method
  When a MASP call fails, see the server's log file for more information on the cause.
  

You can configure your server to reverse the meanings of the status value by setting the server property com.sybase.jaguar.server.masp.zero-success . A value of false , the default, indicates the status values have the meanings described above. A value of true indicates that the meanings of 0 and 1 are reversed.

Set the property in Jaguar Manager as follows:

1. Display the properties for the server by right-clicking on the icon and selecting Server Properties from the popup menu.
2. Click on the All Properties tab
3. If com.sybase.jaguar.server.masp.zero-success is displayed, highlight it and click Modify. Edit the displayed value and click Ok.
4. If com.sybase.jaguar.server.masp.zero-success is not displayed, click Add. Enter the property name and the value, then click Ok.

Copyright © 2000 Sybase, Inc. All rights reserved.