How do I enquote strings in DQL?

Derrick

I am trying to write a DQL statement to update a string attribute in Documentum 5.3 SP6:

UPDATE custom_type OBJECTS SET object_name = 'A string that contain's a single quote' WHERE FOLDER ('/My Cabinet/My Folder')

Of course the above statement fails, since there are 3 single quotes in the string.

However, when I tried to use double quotes (ie "), it still fails with a parser error.

How should I write that DQL?

DCTM_Guru

Have you tried placing two single quotes in the place of the original single quote:

UPDATE custom_type OBJECTS SET object_name = 'A string that contain''s a single quote' WHERE FOLDER ('/My Cabinet/My Folder')