MDAC 2.5 SDK - OLE DB Providers
Data Shaping Service for OLE DB

New Features of the Data Shaping Service

See Also                    Related Topics

New features of the Data Shaping Service included in version 2.1 of the Microsoft® Data Access Components include the following:

• Hierarchy Reshaping—Reshaping a hierarchy reuses cursors created by the Data Shaping Service to create new hierarchies. These component cursors are simply tied together in whatever relationship you specify to create an entirely new relationship, much like reconfiguring a given set of building blocks. Hierarchy reshaping allows you to reuse data—an existing rowset—as a child rowset of a newly created rowset.

  For more information about hierarchy reshaping and examples using this feature, see Reshaping in this guide.

• Grandchild Grouping—The Data Shaping Service for OLE DB provides a means to perform aggregate functions at each level or at specified levels. A new feature with the release of MDAC 2.1 is the ability to build a hierarchy structure that can aggregate specified grandchild rows, skip the parent rows, and roll the totals into a higher aggregation level. This can be beneficial, for instance, when you want to find the average of all child rowsets instead of the average of the parent rowsets.

  For more information about grouping grandchild rowsets and to view examples using this feature, see Grandchild Aggregations in this guide.

• Parameterized Computed Child Rowsets—The Data Shaping Service for OLE DB supports Shape language syntax that allows you to insert one or more levels of computed rowsets between the parent and its parameterized child rowset. This allows you to build a hierarchical structure where the children are built from parameterized commands that are passed through their "inserted" parents but that do not affect those parents.

  For more information about using parameterized computed child rowsets and to view examples using this feature, see Parameterized Computed Child Rowsets in this guide.