How to Loop in 7th Level of Hierarchy in the XSD?

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
skhan2@gmx.us
Participant
Posts: 12
Joined: Wed Oct 07, 2015 4:14 am
Location: BANGALORE

How to Loop in 7th Level of Hierarchy in the XSD?

Post by skhan2@gmx.us »

I'm unable to loop in the 7th level Hierarchy in the XSD for Hierarchical stage in DataStage 11.5 Because Hierarchical stage not allowing to map the fields itself for that special Level into the output fields.
like----

<xs:element name="VCHR_DIST_STG" type="ns1:VCHR_DIST_STG" minOccurs="0" maxOccurs="unbounded"/>
<xs:element name="QBE_AP_STG_DTL" type="ns1:QBE_AP_STG_DTL" minOccurs="0" maxOccurs="unbounded"/>

Could you please any body help here ASAP.
eostic
Premium Member
Premium Member
Posts: 3838
Joined: Mon Oct 17, 2005 9:34 am

Post by eostic »

Its very difficult to appreciate what issue you are having, but this looks like these two elements will appear in your imported schema as independent "lists" (blue icon).

..this means that they would be independent lists coming in, very likely connected in some manner by a higher level node (and often, yet again a higher level "list").

Most common in such situations is that you have multiple input links coming in....one link with VCHR information and rows...and another for the QBE set of rows....and then they are joined up above before using REGROUP steps to narrow down your hierarchy and apply the repeating rows at this particular level.

It helps to build these piece-by-piece...seeing how to construct the nodes independently as you work thru the hierarchy.

Ernie
Ernie Ostic

blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
Post Reply