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 wizard. Using the wizard, you can also review, edit, or reorder the result sets before adding them to a database service operation.
However, you also have the option of discovering result sets through the use of a dialog. If you wish to change discovery preferences, see Setting Database Service Editor Preferences.
To discover result sets using the wizard:
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 wizard.
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.
If not already done, specify the service endpoint. Click New and select from the available JDBC connection profiles. Click Next.
Specify values for the listed input parameters. Click the Value column, define the value, and then click Next when all parameter values have been defined.
If the dialog does not appear, no input parameters exist for this operation.
If there are no input parameters needing values or if the values are already specified, click Next and WorkSpace will generate result sets based on the stored procedure.
Review the list of discovered result sets. To modify the discovered result sets before adding them to the service operation, choose from the following, then click Next:
Click Discover to redefine the values for the input parameters and regenerate result sets.
Click Edit to modify the result set.
Click Remove to delete a result set.
Click Move Up or Move Down to reorder the result sets.
In the Summary page, click Finish to add the result sets to the operation.
Send your feedback on this help topic to Sybase Tech Pubs: pubs@sybase.com