DQL update objects limit results of subquery

Migrateduser

Hi,

I am trying to link exactly 1000 documents to a folder with a DQL update statement:

update dm_document link '/folder/path/1000-folder' where r_object_id in (select r_object from dm_document ... )

Using enable(RETURN_TOP 1000) in the subquery does not have any effect. Is there another way to accomplish the limit of 1000 documents?

Thanks,
Hartmut