What is the exact Differences between the DQL and IDQL

DocumentumHunting

hi,

Anybody Please Help to me,What is the exact difference between DQL and IDQL

Thanks&Regards,

venkat.

Find more posts tagged with

Comments

Imran_Yusubov

DQL is a query language.IDQL is a tool for executing DQL queries.There is also IAPI similar to IDQL and it used for making dmbasic method calls.

DocumentumHunting

Thanks for immediate reply,Actually my doubt is we are always using DQL to access the data and Register the tables also but where exactly we are using IDQL , Please give the Detail Explanation.

tejrajs

As Imran mentioned in previous post,IDQL (and IAPI) are tools. You can use IDQL tool to execute DQL queries also (like other tools SAMSON, RepoInt, DQLMon) .

IDQL (and IAPI) is available on machine where Content Server is installed under 'bin' directory(<$DOCUMENTUM>/product/<version>/bin OR <$DM_HOME>/bin directory).

Usage Example: If you need to run dump and load script you need to use IAPI tool as these scripts needs to be executed on content server.

For more info, refer Content Server Administrator Guide (Appendix B - IDQL & IAPI)

DCTM_Guru

Another way to think about this is DQL is like SQL, and IDQL is like SQL Plus (if you are familiar with Oracle).