hi,
i have parent in hierarchy having 2 childs.....this chain continues upto 25 th level..one company is on 9 th level,8th level is parent of 9th,7th to 8th....like....1st to 2nd...........now how can i track the records?what is the logic used in stage?
thanks in advance..........waiting for reply...........
subhani
Parent in hierarchy
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
PARALLEL JON
....IN PARALLEL JOBray.wurlod wrote:Using what kind of job? This is important - it's done in different way in different job types. ...
subhani
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If your source is a database table, you can use a recursive SELECT statement. Some database servers have specific syntax for this, in others you may need to script it.
There's nothing within parallel job stage types for undertaking this kind of query, unless you'd like to string together 24 Join stages all referring to the same table.
There's nothing within parallel job stage types for undertaking this kind of query, unless you'd like to string together 24 Join stages all referring to the same table.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.