tree traversal queries in sapdb

[Sanjeevi Nagrajan]

Title: Message

SAPDB users,
This is a general question.
How does sapdb support tree traversal queries? Is there an equivalent for the connect by clause in Oracle?

For example - The following table holds a self referential key in the form of manager that refers to emp_id (the primary key).
create table Employee
(emp_id number, (primary key)
emp_name varchar,
salary number,
manager number references employee(emp_id)).

I could write a query in oracle that helps me to do a tree traversal of the employees and their associated manager as follows.
"select emp_id, emp_name
from employee
start with emp_id=
connect by prior manager = emp_id"

Could you please help us in making it possible to do an equivalent with sapdb please?

Thanks in advance
Sanjeevi

The information contained in this email and any attached files is confidential and 
intended solely for the addressee(s). The e-mail may be legally privileged or 
prohibited from disclosure and unauthorised use.

If you are not the named addressee you may not use, copy or disclose this information 
to any other person.  If you received this message in error please notify the sender 
immediately.

Any views or opinions presented here may be solely those of the originator and do not 
necessarily reflect those of the Company.