- 浏览: 53119 次
- 性别:
- 来自: 上海
文章分类
最新评论
From:http://ajithprabhakar.wordpress.com/2008/01/24/registered-tables-in-documentum/
Registered tables are the tables that are present database which are registered in Documentum, so that it can be accessed using DQL. Basically Registered tables are used when the application needs to access data from the RDBMS within the Documentum. This can be either a Table or a View. The Scenarios where I mostly used registered tables are for providing value assistance for Object attributes. I am not getting into too much of details about Value Assistance here, Value assistance is a list of values that a client program (such as Webtop or a Custom WDK Application) displays at runtime for an object attribute. A user can select a value from this list (or, if allowed, add a new one to it). You can set the Value assistance for an Attribute using DAB (Documentum Application Builder).
As I mentioned above uou can register a Table or a view as a Registered Table, The Registered tables are stored as dm_registered objects in repositories. This extends dm_sysobject. And the r_object_id of this type always starts with 19. The following table lists the attributes of dm_registered
Name | Info | Description |
column_count | Integer - Single | Number of columns in the table. |
column_datatype | string(64) - Repeating | List of the datatypes of the columns. |
column_length. | integer R | Lengths of the columns that have a string data type |
column_name. | string(64) - Repeating | List of the names of the columns in the table |
group_table_permit | integer - Single | Defines the RDBMS table permit level assigned to the registered table’s group. |
is_key. | Boolean Repeating | Indicates if an index is built on the column |
owner_table_permit | integer - Single | Defines the RDBMS table permit level assigned to the registered table’s owner |
synonym_for | string(254) - Repeating | Name of the table in the underlying RDBMS (can be an Oracle table synonym, or an MS SQL Server or Sybase table alias) |
table_name | string(64) Single | Name of the table. |
table_owner | string(64) Single | Name of the owner of the RDBMS table (the person who created the RDBMS table). |
world_table_permit | integer - Single | Defines the RDBMS table permit level assigned to the world |
You should either own the table or have super user privileges to register a table. And since this object is linked with /system cabinet you should have write permission on /system cabinet. This is applicable only if the folder security is enabled in Repository
You cannot version a dm_registered object. And also the changes made to the table are not automatically updated in dm_registered object. So if any changes has been made to the structure of the table or view you should unregister it first and register the table again with changes.
How to Register a Table?
Use the following DQL to register a table. REGISTER TABLE [owner_name.]table_name (column_def {,column_def}) [[WITH] KEY (column_list)][SYNONYM [FOR] ‘table_identification‘] This DQL will return the r_object_id of the newly created dm_registered object. In this owner_name is the name of the table owner. table_name is the name of the RDBMS table. column_def defines the columns in the registered table.
column_def arguments should have following syntax column_name datatype [(length)] the valid values for types are float, double, integer, int, char, character, string, date, time.
Length should be specified for character, char, or string data type.
column_list Identifies the columns in the table on which indexes have been built. column_list is usually separated with commas. table_ identification is the name of the table in the Database Example:
REGISTER TABLE “hr.users” (”first_name” CHAR(30), last_name (char 40), “emp_id” INT)KEY (”emp_id”)
Granting Rights
You need to give the permission to the users to access the registered tables. The values for various permission levels are as follows 0 (None): No access 1 (Select): The user can retrieve data from the registered table 2 (Update): The user can update existing data in the registered table4 (Insert): The user can insert new data into the registered table8 (Delete): The user can delete rows from the registered table If a user wants update and insert permissions the value should be 2+4 = 6 , The repository owner also should have the same level of permission in the underlying database to grand those permission to those users. Granting Rights full permission to users in the above example
update dm_registered object set world_table_permit = 15 where object_name = ‘users’;
update dm_registered object set owner_table_permit = 15 where object_name = ‘users’;
update dm_registered object set group_table_permit = 15 where object_name = ‘users’;
How to Unregister a Table?
Use the following DQL to Unregister a Table.
UNREGISTER [TABLE] [owner_name.]table_name In this owner_name is the name of the table owner. table_name is the name of the RDBMS table. You should be the owner of table or super user to do this
Accessing Data from Registered Table
Just like in RDBMS you can access registered table using the following syntax
Select [ATTRIBUTES] from dm_dbo.[REGISTERED_TABLE_NAME] where [CLAUSE]
The Operations such as update/ delete also has the same RDBMS syntax that’s used for a ordinary SQL, Only difference is prefixing dm_dbo to the table name
Example:
Select first_name, last_name, emp_id from dm_dbo.users ;
Updating Data in a Registered Table
Example
Update dm_dbo.users set first_name=’John’ where first_name=’Smith’
Deleting from a Registered Table
Example
Delete from dm_dbo.users where first_name=’Smith’
发表评论
-
修改Content Server管理员密码
2012-07-16 14:59 792修改documentum content server 管理员 ... -
Documentum-修改特定Type的显示图标
2012-07-16 14:57 727背景: 根据客户要求,希望能够在Webtop中对自定义的文档 ... -
Documentum-为客户化Type类型Import时添加自定义属性
2012-07-16 14:46 742默认情况下,当我们导入一个自定义Type类型的文档时,系统并不 ... -
Documentum-系统默认文件柜权限要求
2012-07-16 14:41 805在系统实施时,由于客户需求,要求屏蔽掉系统默认文件夹在界面 ... -
How to enable combined dmcl and dfc trace?
2012-04-16 16:17 626http://vsrr2020.blogspot.com/ ... -
解决Workflow Report查询慢的问题
2012-04-16 15:24 761idql: execute make_index with ... -
Documentum解密
2012-04-12 11:24 750System.out.println(com.document ... -
Method
2012-04-12 09:05 797import com.documentum.fc.cli ... -
解决DM_SESSION_E_CLIENT_AUTHENTICATION_FAILURE ---Documentum 6.0/6.5
2012-04-16 10:26 1318Instructions to fix this error: ... -
How to enable combined dmcl and dfc trace?
2012-03-29 20:29 734http://vsrr2020.blogspot.com/ ... -
ContentServer迁移的步骤
2012-03-29 20:25 8231.备份还原数据库,有时候用UI操作不成功的时候可以用命令 ... -
验证contentserver关于发送email的配置
2012-03-29 20:24 665从dm_event_sender.ebs中可以看出,con ... -
查看某个类型的某个字段的key,value
2012-03-23 09:10 709select map_display_string, map_ ... -
Documentum查看某个类型属性页将要显示的属性
2012-03-23 08:58 667select r_object_id, attribute_n ... -
DQL汇总
2012-03-06 22:21 12991. DQL to create user create “ ... -
How to enable combined dmcl and dfc trace?
2012-03-06 22:22 650http://vsrr2020.blogspot.com/20 ... -
怎样取得DQL所对应的Sql
2012-03-06 22:23 636首先先执行DQL,执行完毕后可以调用下边的方法。 pri ... -
调用本地Office应用
2012-03-06 22:23 1247As the title suggests, my last ... -
DFS开发
2012-03-29 13:21 847先送上一段视频 https://community.em ... -
Getting Started with DFC and DQL
2012-03-29 13:22 901http://www.bluefishgroup.com/li ...
相关推荐
data dictionary in documentum
Documentum
documentum composer用户手册,介绍如何使用
Documentum 6.5 Architecture Overview
Documentum V6安装手册,有截图
Documentum的介绍.部分应用的实例.
Documentum 产品,学习Documentum 很好的资料
Documentum的DQL的使用手册,非常完整的参考手册。 适合从事Documentum的开发人员使用。
Documentum系统管理员必备 本文是英文版本,详细介绍了DOCUMENTUM系统管理方面的知识.
documentum xplore
不错的DOCUMENTUM资料
documentum之DFC开发概览 资料不好找,供有需要的朋友下载
最新Documentum DFC API,用于Documentum的底层接口开发
关于Documentum V6.5 安装的一些细节
documentum6.X 安装指南 DA安装指南 Webtop安装指南
documentum,ECM,官方文档。documentum开发文档,api等