O'Reilly logo

Documentum 6.5 Content Management Foundations by Pawan Kumar

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Managing types with DQL

Although types are best managed using Composer, DQL may be the only option for certain needs, such as defining key constraints for a type. Types can be manipulated with DQL using CREATE TYPE, ALTER TYPE, and DROP TYPE statements. These statements are discussed briefly in this section.

CREATE TYPE

The CREATE TYPE statement creates a new custom type. For example, the following DQL query creates a custom type named dq_loan_doc, which has dq_document as its supertype:

CREATE TYPE dq_loan_doc
(account_id STRING(10))
WITH SUPERTYPE dq_document

It is also possible to specify data dictionary information in the CREATE TYPE statement including value assistance, mapping table, default values for attributes, and type-level and attribute-level ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required