Discovering Result Sets Using the Dialog

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.

  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 dialog 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. To specify values for the listed input parameters, click the Value column, define the value, and click OK when all parameter values are defined.
    Option Description
    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. WorkSpace generates result sets based on the stored procedure.
  8. Click Finish to add the result sets to the operation.
Related tasks
Adding a Result Set Manually
Discovering Result Sets Using the Wizard

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.