Executing SQL "select" queries from IDfQuery API

I have got complex reporting requirements for my customer.

I was just wondering if I can execute a SQL "select" query instead of DQL from the DFC IDfQuery API.

This will help me to avoid lot of post processing of the Query Collection resultset, by effectively filtering out data by using CASE statement in Where clause

Find more posts tagged with

Note:

If there are Accepted Answers, those will be shown by default. You can switch to 'All Replies' by selecting the tab below.

Accepted answers

Francois Dauberlieu

No can do, however, what you could do, if it is kind of a common query would be to define a view in your RDBMS and register it in Documentum then you could do your DQL statement

You can only run SQL from the API but there is 1 BIG limitation, it will only return a 1 line result so it would be OK for an Update statement for example, it would give you the number of records updated but not for a Select statement

All comments

Francois Dauberlieu

No can do, however, what you could do, if it is kind of a common query would be to define a view in your RDBMS and register it in Documentum then you could do your DQL statement

sijohnm

That was a good idea. Thank you Francois!!!

Francois Dauberlieu

PS: don't forget to close your IDfCollection's , it's a common mistake to forget it and after 10 times running your app. Kaboom, no more collections available