Persisted Hierarchical Data
Hierarchical rowsets are handled differently by the OLE DB Persistence Provider. Foremost, the client must be able to support hierarchical rowsets.
In ADTG format, the Persistence Provider's hierarchy is stored rowset by rowset, not row by row. Therefore, the child rows are not visible. To pass it in correct hierarchical format to the consumer, the hierarchy should be read back into the provider that created it. XML-formatted files expose rows.
In the persisted file, for columns of type HCHAPTER, the Persistence Provider stores two additional pieces of information with the column metadata: relational information and calculated information. Data is retrieved from each rowset completely, without using the HCHAPTER value from the parent rows.
Parameterized hierarchies are not supported because the Persistence Provider does not support the command object.