EAServer methods can return tabular data to the calling client. This feature can be useful for:
Use with data-aware controls Some front-end tools provide objects that can automatically display a result set. For example, if you are using PowerBuilder, you can return results in a DataStore object from component methods and display the results using a DataWindow® control in the client. PowerBuilder DataWindow technology, available in both Web and PowerBuilder clients, allows you to display result sets and synchronize updates with a minimum of coding.
Efficiency For tasks that require returning tabular data, using an EAServer result set is the most efficient alternative. Common uses of result sets include menu and picklist population. For example, in an online clothing catalog, you must list in-stock sizes for each item.
The EAServer result set allows data to be sent all at once (rather than requiring a get-next-row method and one client-server round trip per method). A large EAServer result set can be sent with less overhead than is required to encapsulate tabular data as an object and send a serialized version of the object to the client.
Each component model provides an interface that allows you to define result sets from scratch or to forward results from a remote database query directly to the client. See the EAServer CORBA Components Guide.
For information on using the PowerBuilder DataWindow, see the PowerBuilder Application Techniques manual.
