Adding retrieve set

Add retrieve set to load data referenced by a source set reference of type tSetReference into a target business object of type tSet.

You need to add a retrieve set information service activity if your business process needs to access the data referenced by a set reference, for example, in cases where a partner does not understand or work with set references, or if your business process is not permitted to access the system that stores the business data that is needed in the process.

You can use the JDBC Adapter to load data from a database table into target business object if you know which database table will be used. However, if tables need to be created dynamically during processing, you must use retrieve set.

To add a retrieve set information service activity:

  1. Click the top icon in the palette and choose Information Service from the submenu. Drop the activity from the palette on the canvas. Optional: Enter name and description of the activity.
  2. Click the Details tab in the properties area and select retrieve set.
  3. Select which source set reference to load into which target business object.

    The source set reference you select must either refer to a result set reference from a previous SQL snippet activity, or you must have assigned initial values to it by clicking the Initial Value tab in the properties area and entering the table name, table schema, and JNDI name of the data source.

    If no target variables are listed, click New Variable to add a variable of type tSet.

  4. Optional: Click Query to include an SQL SELECT query to narrow the scope of the data retrieved from the table that is referenced by the set reference variable.
You can identify a retrieve set in your business process flow by its icon Retrieve set icon.

(C) Copyright IBM Corporation 2006. All Rights Reserved.