How can I change single-valued attribute to repeating keeping the value in place

[email protected]

Hi,

We are required to change a single-valued attribute to repeating keeping the value in place. Is there a way that I can do by DQL or API?
If you have a solution, please post it here.

Thank you.
Ashok

[email protected]

I got partial solution, but can any one help to make it complete?

Please help.

Alter type my_type add c_new_name char(20) repeating publish;

** would need the code to copy the c_name values into the c_new_name[0] **

Alter type my_type drop c_name publish;

Update my_type object set c_new_name = c_name;

Thank you.
ashok

jfranken

Which product and version are you running?

[email protected]

Hi Jeff,

Documentum 7.2
CS 7.2

I think I got a solution:
1) Creating a new repeating attribute:
Alter type my_type add new_repeating_attr char(20) repeating publish;
2) To move the old_single_attr value to new_repeating_attr for each object
UPDATE OBJECT APPEND new_repeating_attr = old_single_attr
3) drop or hide the old_single_attr.

Thank you.
Ashok

[email protected]

But this solution is not 'in place'.
Do you think it can be done with 'in place' meaning without moving the attribute values from one attribute to another?

jfranken

I suspected you were asking in the wrong forum. I think this is the link you need:

https://communities.opentext.com/forums/categories/documentum_developer