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:
- All entries are retrieved from YXR_DISPLY, where,
object name =
objectName
- 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.
- 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).
