saikrishna80
Programmer
Hi,
1
/ 2 3
/ \ \
4 5 6
This the hierarchy i have maintained in a table.
that is more specifically 1 is the parent and its child are
2 and 3 and the total number of levels is 2. 2 will have 4 and 5 as child and 3 will have 6 as the child.
Now i want a Stored procedure or SQL in Informix so that
if i give the input like below.
Input = 1 (parent) it should list out the hierarchy from 1
i.e parent.
The output should be 2 levels.
Please consider it as urgent and reply soon.
Thanks and warm regards
Sai krishna.
1
/ 2 3
/ \ \
4 5 6
This the hierarchy i have maintained in a table.
that is more specifically 1 is the parent and its child are
2 and 3 and the total number of levels is 2. 2 will have 4 and 5 as child and 3 will have 6 as the child.
Now i want a Stored procedure or SQL in Informix so that
if i give the input like below.
Input = 1 (parent) it should list out the hierarchy from 1
i.e parent.
The output should be 2 levels.
Please consider it as urgent and reply soon.
Thanks and warm regards
Sai krishna.