Test Data Service Dialog Box

Use

You use the Test Data Service dialog box to test the functionality of the selected data service. You enter values into the relevant field(s) for the input port(s) of the data service, and click Test to display the results retrieved from the data service.

You display the Test Data Service dialog box by right-clicking a data service icon on the Design board and choosing Test Data Service from the context menu.

The Test Data Service dialog box contains the following items:

Item

Description

Port tree

Hierarchical tree containing the input ports, record sets, and records of the data service. Each node type is identified by a different icon in the tree.

Field / Value area

List of fields in the record that is currently selected in the port tree. For each field, you can enter a value that is required by the data service to retrieve data.

Results area

Displays the data retrieved from the data service using the specified input field values.

Test

Sends the specified field values to the data service and retrieves the results from the data service.

Reset

Deletes any entered field values together with any manually added records and any displayed results.

Add

Adds a new record to the record set selected in the port tree. You can then define values for the fields of the new record.

Add Fields

Enables you to determine the contents of an output table by assigning the listed fields to the displayed output ports, overwriting any other fields that may have been assigned to those ports.

This option is only available when working with JDBC_based stored procedures.