primary key in DTree table

Hi,Anyone know about the primary key in DTree table. All along i though it is the dataID. But when i read the livelink server 9.7.1 SDK System Schema Referance. It shows that name is the primary. Is it correst, it is possible to have 2 same name in the DTree table.

Find more posts tagged with

Comments

Alexander_Pachipala

Message from <Alexander-Vishnu.Pachipala@ubs.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

Hi,

DataID is the only Primary Key in DTree table.

It is possible to have same Name.

Regards,

Alex

From: eLink Discussion: Live Reports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: 27 May 2011 12:39
To: eLink Recipient
Subject: primary key in DTree table

primary key in DTree table

Posted by dsta001 (dsta001, dsta001) on 2011/05/27 03:03

Hi,

Anyone know about the primary key in DTree table. All along i though it is the dataID. But when i read the livelink server 9.7.1 SDK System Schema Referance. It shows that name is the primary. Is it correst, it is possible to have 2 same name in the DTree table.

dsta001_dsta001_(dsta001_-_(deleted))

thnaks Alex.Anywhere i can confirm this. Trying to find any indication of primary key in the DTree table in the oracle database. Any ideas where is it?

Kyle_Swidrovich

Have a look at the indices on the DTree table.You'll see that uniqueness is enforced via the indices.This ensures that although two files in Content Server can be named the same thing (e.g., MyDoc.doc in your Personal Workspace and MyDoc.doc in the Enterprise Workspace), they CANNOT be named the same thing if they reside in the same immediate parent container.Please keep in mind that in CS 10, DTree is not the place to retrieve the names due to multilingual technology. You will need to pull data from the appropriate language tables.