Appendix A Executing Methods As Stored Procedures

Using MASP from application builder tools

Using MASP, you can invoke Jaguar component methods that can execute Sybase stored procedures.

Some application builder tools might not be able to use MASP if they issue metadata queries against Jaguar.

PowerBuilder

You can connect to a Jaguar server, create a stored procedure DataWindow™, and get a list of available methods. You can pick one of these, create a DataWindow with it, and then when you execute the DataWindow, results from the method are displayed in the window.

Note that you must manually specify the format of the result sets and the expected parameters. As with all stored procedure DataWindows, these are read-only.

PowerDynamo™

You can execute methods on a Jaguar component as if they were stored procedures, and use the script's capabilities of dynamic table generation to display the results in an HTML table.

Other tools

You should be able to use MASP in other tool environments as well. Any tool that uses one of the following communication drivers and allows stored procedure execution should be able to use MASP:

Sybase jConnect (any version)
Sybase System 10 or System 11 ODBC driver
Sybase Open Client