Novell Doc: ODBC Driver for eDirectory Read-Write Access

4.8 Parent Container Queries

The first SQL query results in entries from the Fred's Widgets organization as well as its subordinate organizational units. The second query illustrates the use of the NDS_Context column to get information from only the parent context.

SQL Statement

 select NDS_Context, Surname from UserNDS

Result Table

Table 4-6 Parent Container Query Result Report

NDS_Context	Surname
Sales.Fred’s Widgets	Purdy
Sales.Fred’s Widgets	Anderson
Sales.Fred’s Widgets	Desmond
Sales.Fred’s Widgets	Knight
Sales.Fred’s Widgets	Turnet
Marketing.Fred’s Widgets	Gilbert
Marketing.Fred’s Widgets	Bergman
Marketing.Fred’s Widgets	Fairbanks
Marketing.Fred’s Widgets	Metcalf
Product Develpment.Fred’s Widgets	Sanders
Product Develpment.Fred’s Widgets	Smith
Product Develpment.Fred’s Widgets	Weirsdorf
Product Develpment.Fred’s Widgets	Hancock
Operations.Fred’s Widgets	Brown
Operations.Fred’s Widgets	Jones
Operations.Fred’s Widgets	Madsen
Operations.Fred’s Widgets	Garcia
Fred’s Widgets	Johnson
Fred’s Widgets	Brady
Fred’s Widgets	Swift

SQL Statement

 select NDS_Context, Surname from UserNDS where NDS_Context = ’Fred’’s Widgets’

Result Table

Table 4-7 Result Table

NDS_Context	Surname
Fred’s Widgets	Johnson
Fred’s Widgets	Brady
Fred’s Widgets	Swift