Discovering Result Sets Using the Wizard

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.

  1. Connect to the database.
  2. Open the database service that you want to discover result sets for.
  3. Select the Service Interface tab.
  4. Expand the Operation Parameters section and select the Result Sets tab.
  5. Select the operation that you want to discover result sets for.
  6. Click Discover.

    The Discover Result Sets wizard opens.

    Note: 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.
  7. If not already done, specify the service endpoint. Click New, select from the available JDBC connection profiles, and click Next.
  8. To specify values for the listed input parameters, click the Value column, define the value, and click Next when all parameter values are 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 generates result sets based on the stored procedure.
  9. To modify the discovered result sets before adding them to the service operation, choose from the following, then click Next:
    Option Description
    Discover Select this to redefine the values for the input parameters and regenerate result sets.
    Edit Select this to modify the result set.
    Remove Select this to delete a result set.
    Move Up or Move Down Select this to reorder the result sets.
  10. On the Summary page, click Finish to add the result sets to the operation.
Related tasks
Adding a Result Set Manually
Discovering Result Sets Using the Dialog

Send your feedback on this help topic to Sybase Technical Publications: pubs@sybase.com

Your comments will be sent to the technical publications staff at Sybase, Inc. For product-related issues or technical support, contact Sybase Technical Support at 1-800-8SYBASE.