DSXchange

Hi Ernie, Thanks for spending some thought on this. I've tried a few approaches that create nested nodes separately and reunite them based on the impression that XML output satge will do it naturally, but everytime it has proven wrong. Yes, I've not tried the way you have suggested to take a feedbac...

Hi ray, Thanks for being so forthcoming. Yes it looks plausible to go for use of "WITHIN" in the Hash lookup to grab all the children of a particular node and recursively generate the path from it till the leaf is reached. But, the whole problem lies in the fact that except for the root wh...

Thanks Craig for your warm Response. Well, precisely the need is like this: We are to develop an XML file depicting the organisation tree structure. For this we have an XSD that has one element "Orgnsnstructure"of type "Organisation hierarchy" which comprises some relevant elemen...

Is it possible to develop a variable length recursively hierarchical XML file using DataStage? For example the hirarchy of manager and employee, or that of organisation structure.