Some result sets for stored procedures are auto-generated. However, if the stored procedure returns a result set that incorrectly displays all columns as false, then you must rediscover this result set to set the columns correctly.
Additionally, if a JDBC driver returns insufficient information to automatically generate a result set for a stored procedure or SQL statement operation, you must manually discover the result sets.
During this process, you can provide input parameter data used to execute the procedure, get metadata, roll back transactions, and then add the discovered result sets back to the database service operation.
This procedure describes how to discover result sets using a dialog; however, you also have the option of discovering result sets through the use of a wizard. If you wish to change discovery preferences, see Setting Database Service Editor Preferences.
To discover result sets using the dialog:
Connect to the database.
Open the database service that you want to discover result sets for.
Select the Service Interface tab.
Expand the Operation Parameters section, and select the Result Sets tab.
Select the operation that you want to discover result sets for.
Click Discover to open the Discover Result Sets dialog.
When discovering result sets for a stored procedure for Adaptive Server Enterprise (ASE), if the chained mode is set to false, a message appears prompting you to enable Autocommit to complete the Result Set Discovery action. Click OK to set Autocommit to true. This action is temporary and is used for the discovery phase only.
Specify values for the listed input parameters. Click the Value column, define the value, and then click OK when all parameter values have been defined.
If the dialog does not appear, no input parameters exist for this operation. Return to the Operation Parameters section in the service editor and define the operation input parameters.
If there are no input parameters needing values or if the values are already specified, click OK and WorkSpace will generate result sets based on the stored procedure.
The discovered result sets are added to the Operation Parameters section of the service editor.
Click Finish to add the result sets to the operation.
Send your feedback on this help topic to Sybase Tech Pubs: pubs@sybase.com