Hi, This is being posted on behalf of my friend Chandra. He needs to load the departments in the various nodal levels under the department tree structure Into a temporary table. He is on DB2. Could any body help him. Thanks, Krishna