documentum

Documentum Registered Table object retrieval error


Environment: DA 7.3, D2 4.7, MS SQL Server 2012, Win Serv 2012 R2, Tomcat 8

SELECT * FROM dm_registered

it retrieves all registered table instances found (nearly 32 instances) --> 3 of them i created using the command:

REGISTER TABLE [ owner_name.] table_name ( column_def {,column_def}

enter image description here

D2 registered table


Solution

  • The cause is that the table was not created in the database, i don't know how i missed that critical step.

    Simply the answer is

    now i am able to query the table using the DQL query (no need for alias)

    SELECT * FROM dm_dbo.employee

    enter image description here