Select only one row in dql subquery
In my experience it is impossible to use DQL hints in a sub query like you suggested, because the hint is applied to the query as a whole. It is indeed possible to use, say, ENABLE(RETURN_TOP 1) on a query that contains a sub query, however that hint will then...
xCP2.2 error during application deployment [DM_QUERY2_E_ALTER_ASPECT_INVALID_ASPECT]
I were able to reproduce the same problem. As temporal workaround it is possible to install Application twice and it will work. I am not sure if everything will work fine, but from first glance I could not find any bugs. In other words: deploy application first. It will fail...
User Masquerading in Documentum
Assuming by "Java API" you mean the DFC. I think you can also do something similar in DFS (web services). You can use IDfSession.getLoginTicketForUser(string username) after authenticating with an admin session. You can use this login ticket to impersonate a user by name, and perform operations on their behalf. http://www.nathanobert.com/dfc7/com/documentum/fc/client/IDfSession.html#getLoginTicketForUser(java.lang.String)...
webtop not starting in Tomcat
Upgrading WDK applications is not straightforward process, you cannot just transfer your modifications and expect them to run. I doubt that you used recommended approach for upgrading your WDK application. Check this link. Best approach is to deploy OOTB Webtop 6.7 SP2 and add custom layer, if necessary one by...
DQL: enable (return_top 10) performance impact
enable (return_top 10) modifies the executed SQL statement, it adds a limiting clause to it, like ROWNUM <= 10 in Oracle. It depends on the underlying RDBMS, so I guess it's not ROWNUM <= 10 if you use EMC Documentum with Microsoft SQL Server. You can run DQLs on the...