Archive for October 24, 2010

Setup Gmail with MSOutlook 2007

October 24, 2010 Comments off

To configure Outlook 2007 for your Gmail address , follow the below mentioned Steps:

  1. Enable POP in your email account. Don’t forget to click Save Changes when you’re done.
  2. Open Outlook.
  3. Click the Tools menu, and select Account Settings…
  4. On the E-mail tab, click New…
  5. If you are prompted to Choose E-mail Service, select Microsoft Exchange, POP3, IMAP, or HTTP, and click Next.
  6. Fill in all necessary fields to include the following information:
      Server Information 

      Account Type: POP3

      Incoming mail server: (Google Apps users, enter the server names provided, don’t add your domain name in these steps)

      Outgoing mail server (SMTP):

      Logon Information

      User Name: Enter your Gmail username (including Google Apps users, enter your full address in the format

      Password: Enter your email password.

      Require logon using Secure Password Authentication (SPA): Leave this option unchecked.

      10. Click the More Settings… button, and select the Outgoing Server tab.

      11. Check the box next to My outgoing server (SMTP) requires authentication and select Use same settings as my incoming mail server.

      12. Click the Advanced tab, and check the box next to This server requires an encrypted connection (SSL) under Incoming Server (POP3).

      13. In the Outgoing server (SMTP) box, enter 587, and select TLS from the drop-down menu next to Use the following type of encrypted connection:.

      14. Click OK.

      15. Click Test Account Settings… After receiving ‘Congratulations! All tests completed successfully’, click Close.

      16. Click Next, and then click Finish.

      Congratulations! You’re done configuring your client to send and retrieve Gmail messages.

  7. Your Name: Enter your name as you would like it to appear in the From: field of outgoing messages.
    Email Address: Enter your full Gmail email address ( Google Apps users, enter your full address in the format
    Password: Enter your email password.

    Manually configure server settings or additional server types: Leave this option unchecked if you want to automatically configure Outlook 2007. If you want to manually configure Outlook 2007, check this box now. Google Apps users should configure manually as follows.

    7. Click Next. If you are configuring Outlook 2007 automatically, you’re done! Just click Finish.

    8. If you are configuring Outlook 2007 manually, select Internet E-mail and click Next.

    9. Verify your User Information, and enter the following additional information:


October 24, 2010 Comments off

DQL is used by administrators, developers, and applications to retrieve  information from the Content Server .DQL statements operate on objects and sometimes on tables/rows while SQL statements only operate on tables/rows.

Building blocks of a DQL statement  includes,

Ø  Literals, which describes the literal formats for the Documentum datatypes

Literals are values that are interpreted by the server exactly as they are entered. Content Server recognizes .Five types of literals:

§  Integer literals

§  Floating point literals

§  Character string literals

§  ID literals

§  Date literals

Ø  Special keywords which describes the special keywords that can be used in DQL

Special keywords have special meanings for Content Server when used in a DQL query. (They cannot be used in API methods.) Some  keywords are:

§  USER, which identifies the current user

§  TRUE and FALSE, which represent the Boolean true and false.

§  DM_SESSION_DD_LOCALE, which represents the data dictionary locale.

Ø  Functions which describes the functions that can be used in DQL queries

Functions are operations on values. DQL recognizes three groups of functions and two unique functions:

  • Scalar functions: Scalar functions operate on one value and return one value.
  • Aggregate functions: Aggregate functions operate on a set of values and return  one value.
  • Date functions:Date functions operate on date values.
  • The ID function:The ID function, a unique function recognized by DQL, is used in   the FOLDER and CABINET predicates and in the IN DOCUMENT and IN ASSEMBLY clauses.
  • The MFILE_URL function:The MFILE_URL function returns URLs to content files and   renditions in particular format

Ø  Predicates  which describes the predicates that can be used in expressions in queries

Predicates are used in WHERE clauses to restrict the objects returned by a query. The WHERE clause          defines criteria that each object must meet. Predicates are the verbs within the expression that define the        criteria.

DQL recognizes these predicates:

Arithmetic operators

Comparison operators

Column and attribute predicates

SysObject predicates

Ø  Logical operators describes the logical operators supported by DQL

Logical operators are used in WHERE clauses. DQL recognizes three logical operators:

  • AND
  • OR
  • NOT

Any number of expressions can be joined together with logical operators. Content Server imposes no limit. (Underlying RDBMS may impose a limit.) The  resulting complex expression is evaluated from left to right in the order of precedence of the operators. This order, from highest to lowest, is: NOT,AND,OR

Ø  DQL reserved words which is a  list of the words reserved in DQL

DQL reserved words should be enclosed in double quotes when using in a DQL query. some keywords are

  • ALL
Categories: DOCUMENTUM Tags: , ,


October 24, 2010 Comments off

DQL is the acronym for Document Query Language, the SQL-like language that you use to query the Docbase. Using DQL, you can retrieve, update, and delete objects and create new objects. You can also use DQL to access registered tables—tables in the underlying RDBMS that are known to eContent Server but that are not part of the Docbase.
Some special key words of DQL :
• User
• True
• False
• Any
• Type
• Folder
• Cabinet
• All
• Id
• Append
• Truncate
• Insert………….

Eg 1
Select * from dm_document where owner_name = User — User here refers to user of the session
Eg 2
SELECT “r_object_id” FROM “dm_sysobject”
WHERE ANY “authors” = ’suresh’
Here, authors is repeating valued field and the query returns all the rows which have “suresh” as one of the “authors”
Eg 3
Update DQLs
UPDATE “dm_document” OBJECTS
APPEND authors=”Prem”
WHERE “title” = ’ACS’
This adds a new author to the end of the list. Ie already if 3 authors are there, this becomes the 4th.
Eg 4
To delete a value in a repeating attribute, use the remove option as the update clause and specify the index value associated with the value.UPDATE “nm_document’ OBJECT
REMOVE authors[4]
WHERE “title” = ’OLD FILE’
Eg 5
Consider three types of document – doctype1, doctype2 and doctype3. To get documents of type doctype1 or doctype3 we use the “Type” key word.
Select * from dm_document WHERE Type (doctype1) OR Type (doctype3)
Eg 6
To query from specific folders we use the folder key word.
Everything in documentum is out in folders which are there in Cabinet.
Select * from dm_document
WHERE Folder(‘/cabinet/folder1’);
Select * from dm_document
WHERE Folder(‘/cabinet/folder1’, descend);
If the Descend key word is NOT used, it queries only the folder specified but not subfolders underneath the folder
CREATE —- used to create object types
CREATE…OBJECT — used to create instances
CREATE dm_document Object
SETFILE=”D:\docs” with
Content_format = “MSW8”;

Categories: DOCUMENTUM Tags: , , ,
%d bloggers like this: