How can I change single-valued attribute to repeating keeping the value in place
Comments
-
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.
ashok0 -
Hi Jeff,
Documentum 7.2
CS 7.2I 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.
Ashok0 -
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?0 -
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
Warning No formatter is installed for the format ipb0
Categories
- All Categories
- 108 Developer Announcements
- 53 Articles
- 106 General Questions
- 145 IM Services
- 43 OpenText Hackathon
- 32 Developer Tools
- 20.6K Analytics
- 4.1K AppWorks
- 8.9K Extended ECM
- 899 Cloud Fax and Notifications
- 77 Digital Asset Management
- 9.3K Documentum
- 29 eDOCS
- 120 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management