Developing business objects using dynamic retrieve

The Dynamic Retrieve function module is a mapping tool and dynamic SQL statement generator. This function module uses the metadata stored in the YXR_DISPLY table to generate SQL select statements at runtime. Dynamic Retrieve takes the resulting fields of these SQL statements and fills the attributes of the WebSphere business object. When the Dynamic Retrieve function module is called, the following steps are performed:

  1. All entries are retrieved from YXR_DISPLY, where,

    object name = objectName

  2. For each new table specified in YXR_DISPLY, a SQL where clause is generated based on the fields marked as key. The corresponding Field Name in business object attributes is used to populate the value in the where clause. If a default value is specified in YXR_DISPLY, this default is used.
  3. The SQL select statement is executed. The resulting fields are copied into the corresponding Field Name in business object attributes.
Note:
Before you can generate a business object definition, you must create a WebSphere business object using the IBM WebSphere InterChange Server Connector Tools Window (YXR1).

Copyright IBM Corp. 1997, 2003