Usage of external DB objects- table/query (not Documentum object)

External DB objects - table/query (not Documentum object) is accessable only for Super User permission user. In general you get it, when query to DB by docbase owner alias dm_dbo (select * from  dm_dmo.table_name).

For using an object in external DB - this object should be registered.

1) Execute query "register"

REGISTER TABLE DOCUM.OBJECT_NAME (ANYFIELD CHAR(8))

/* where DOCUM - docbase owner
              OBJECT_NAME - table/query
*/

2) Grant permission for users. Execute query "update"

update dm_registered object 

set owner_table_permit=15
set group_table_permit=15
set world_table_permit=15

where object_name ='OBJECT_NAME '

A great artice about Registered Tables you may find by the link
http://www.bluefishgroup.com/1999/documentum-registered-tables/

The most disappointing things in DCTM 6.7 in my way (Some point may be my fault due to incomplete experience)

FormsBuilder -

-  Child forms (like Query Simulation, adaptor designer) are not expandable. It is very unconvenient to design long query in small window.

-  I can't populate valeus from one control to another. F.e. from some tables to summary table
-  I can't calculate cells data of table - like sum, avg.

(100% bug) - adaptor stop executes (data source for Tables) from time to time - have to set to another adaptor in DataSource field and then turn back to hanged one

Useful DQL / API

How to define a names of TaskSpace main and child applications

select * from dmc_taskspace_app

Clear repository cache

flush,c,querycache
flush,c,persistentcache
flush,c,persistentobjcache
flush,c,ddcache,<PARTICULAR_OBJECT_TYPE>
flushcache,c