Location For DFC
DFC Runs On : A Java virtual machine (JVM) The machine that runs Content Server. For example, to be called from a Docbasic method as part of a workflow or document lifecycle. A middle-tier system. For example, on an application server to support WDK or to execute server methods….
DFC Installation
There are two modes of installation of DFC: Standalone – Installed as a part of client application. Configured information in dfc.properties. DFC.jar placed in WEB-INF/lib dfc.properties and log4j.properties files placed in WEB-INF/classes Applications can be configured with different dfc installation. Embedded – Deployed with web application Added to WAR or…
Object Types
List all attributes of a specific type, indicating which are repeating-valued (1=repeating): SELECT attr_name, attr_repeating FROM dm_type WHERE name = 'type' Identify the supertype of a specific type: SELECT super_name FROM dm_type WHERE name = 'type' List all subtypes of a specific type: SELECT name FROM dm_type WHERE super_name = 'type' List…
Object Manipulation
Create a new object, setting attribute values, folder location, and associating a content file: CREATE type OBJECT SET title = '', SET authors[0] = '', INSERT authors[0] = '',APPEND authors = '', LINK '/a/b' SETFILE 'C:testpathabc.doc' WITH CONTENT_FORMAT 'test_format' Modify a specific existing object, changing attribute values and folder location:…
Content Server
How many concurrent connections are allowed by the Content Server: SELECT concurrent_sessions FROM dm_server_config What is the default location for server log files: SELECT log_location FROM dm_server_config List the machine names where connection brokers reside: SELECT projection_targets FROM dm_server_config What is the oldest client version from which the repository will…
Registered tables
Create Table in database: EXECUTE EXEC_SQL WITH QUERY='CREATE TABLE abc(a VARCHAR2(20),b INTEGER,c FLOAT)' Register specific columns from an external table and create indexes on some of the columns: REGISTER TABLE “abc” (“a” CHAR(20), “b” INT, “c” FLOAT,) WITH KEY “a”, “b” Return information from a registered table: SELECT “a”, “b”…
Other Syntax
AVG: Return only the average value from all that qualify: SELECT AVG(“b” + “c”) FROM “abc” WHERE “a” = '10' COUNT: Return a count of a specific type objects in the repository owned by a particular user: SELECT COUNT(*) FROM type WHERE owner_name = 'tyler' COUNT(DISTINCT): Return a count of…
Searching
List all searchable attributes: SELECT attr_name, type_name FROM dmi_dd_attr_info WHERE is_searchable = 1 ORDER BY type_name List all searchable dm_document attributes: SELECT attr_name FROM dmi_dd_attr_info WHERE is_searchable = 1 and type_name = 'dm_document' Display information about the full-text index: SELECT * FROM dm_fulltext_index List all the documents which contain the set of words: SELECT *…
Creating DFS Service Using Documentum Composer
Introduction To DFS Project When you create a Documentum Project in Composer, it has DFS Service enabled build path which makes it DFS project as well. If you right click one of your Documentum projects and bring up its properties, then select the Java Build Path, and under the Libraries…
Creating a DFS Consumer
Just as a quick aside if you do need to create a consumer, select the “DFS Services Library” entry and then select Edit, you should see something like this:- As you can see there are in fact 4 flavours of DFS services library. The first, and the default, is concerned…