Concatenate strings in DQL

mrgou
mrgou Member
edited February 17, 2012 in Documentum #1

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

Tagged:

Best Answer

  • tejrajs
    tejrajs Member
    edited February 16, 2012 #2 Answer ✓

    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

Answers

  • tejrajs
    tejrajs Member
    edited February 16, 2012 #3 Answer ✓

    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

  • mrgou
    mrgou Member
    edited February 16, 2012 #4

    OK, that's what I thought. Thanks!

  • Hartmut_Clausen
    Hartmut_Clausen Member
    edited February 16, 2012 #5

    I am working with Documentum for more than 10 years and this feature is on my wishlist since day one.

  • matt-medicis
    matt-medicis Member
    edited February 16, 2012 #6

    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

  • mrgou
    mrgou Member
    edited February 16, 2012 #7

    That syntax doesn't seem to be supported by my underlying RDBMS. It complains about an invalid number.

  • matt-medicis
    matt-medicis Member
    edited February 16, 2012 #8

    It works in MS SQL Server 2005 SP2. What is your RDBMS? (just curious)

  • mrgou
    mrgou Member
    edited February 17, 2012 #9

    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.

  • DCTM_Guru
    DCTM_Guru Member
    edited February 17, 2012 #10

    So what's the issue with just executing the SQL?

  • mrgou
    mrgou Member
    edited February 17, 2012 #11

    None, that's actually what I'm testing. ;-)

Categories