You can update the NDS Data Source using simple insert, update and delete SQL queries. To update the Data Source, you should have rights to write onto Novell eDirectory.
Note that:
While inserting an object, you need to specify the Nds_Name as an attribute (column in SQL).
The driver does not support positioned update, delete, or insertion.
If the attribute value is in decimals it will be treated as an Integer while adding to Novell eDirectory.
You cannot create or drop a table (create or delete an object class, which requires schema extension) using the ODBC driver.
For a single entry, SQL semantics does not permit using multiple values for a single column. Hence, this driver does not allow you to Insert/Update an entry with multiple values for one particular attribute. However, the driver will allow you to put in just one value for a multi-valued attribute.
The following SQL statement enables you to add an user object to the NDS Data Source:
INSERT into UserNDS (Surname, Nds_Name, UID) values (’Duke’, ’Luke’, 8)
The following SQL statement enables you to modify an user object in the NDS Data Source:
UPDATE UserNDS SET Surname = ’Kuke’, UID = UID + 20 WHERE Nds_Name LIKE ’%uke’
The following SQL statement enables you to delete an user object from the NDS Data Source:
DELETE FROM UserNDS WHERE Nds_Name = ’Luke’ OR UID > 7