DSXchange

Many thanks, Arnd

I have searched the DataStage Book Shelf, Help topics, FAQ's and Forums, but, cannot find a pointer to Ascentials description of the 'CREATE.FILE' command. Where is it ? Thank you.

Hello Nav, No the link doesn't help! I need to find muliple rows from the hashfile lookup using same foreign key concept as the ODBC / UV lookup stage can provide with multirow lookup. Please look at my original post, all the data is there! I only have two tables which I am working with, BOM and TEM...

Hej Arnd, pid = parent part id cid = child part id plant = parent consuming plant seq = sequence in which the part is consumed All four are keys in my BOM table. However, the multiple child part produced at various plants and furthermore produced in differenct sequences at those plants must be remov...

I have updated the main post, hopefully this clarifies.

This is the first time I am posting here at DSXchange. I have read many posts and searched far and wide, but, those points I have found just haven't worked. Here we go... I have a BOM (bill of material) which needs to be cleansed for duplicate parent - child relationships. This would be easy if my D...