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…
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 Fundamentals
Documentum Foundation Classes (DFC) is an object oriented application programming interface (API) and framework for accessing, customizing, and extending Documentum functionality. Documentum has implemented DFC as a set of Java interfaces and implementation classes. DFC also provides the Documentum Java-COM bridge (DJCB) to make the interfaces available in Microsoft’s Component…
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…
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”…
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…
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:…
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…
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 *…
DocApps
Display the object IDs of all objects contained in a specific DocApp: SELECT application_object_id FROM dm_application WHERE object_name = ‘' What is the version label of a specific DocApp: SELECT app_version FROM dm_application WHERE object_name = ''