Hi,
I'm trying to edit a property in bulk by making it equal to a literal string, followed by another property value (e.g. set property_a = 'string' & property_b).
I'm pretty certain in can't be done in DQL, but I wanted to make sure.
Thanks!
Raph
If there are Accepted Answers, those will be shown by default. You can switch to 'All Replies' by selecting the tab below.
DQL does not provide option to concatenate string, however you can use 'EXECUTE' DQL to execute 'EXEC_SQL' where in you can specify SQL which provides capability for string concatenation
OK, that's what I thought. Thanks!
I am working with Documentum for more than 10 years and this feature is on my wishlist since day one.
This works in 6.5 SP2...
update dm_document object set title = (select r_object_id + ' ' + object_name from dm_document where r_object_id = '09013ff5800b3536') where r_object_id = '09013ff5800b3536'
Let me know if that works for you.
Matt
That syntax doesn't seem to be supported by my underlying RDBMS. It complains about an invalid number.
It works in MS SQL Server 2005 SP2. What is your RDBMS? (just curious)
It's Oracle. I seems quite sensitive to syntax for the support of DQL queries. For instance, I never could use DATEFLOOR within a group by expression. See https://community.emc.com/message/576113.
So what's the issue with just executing the SQL?
None, that's actually what I'm testing. ;-)
