Renaming UC4 System name

Document ID : KB000089296
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Renaming UC4 System name
Resolution:

Solution

 

With the following statement you are able to mark the old System names as deleted:

 

 

 

MSSQL:

 

Update oh set oh_name=(OH_Name + '_' + ( SUBSTRING( '0000000000', 1,(10-len(OH_Idnr) ) ) ) + convert(varchar(10),OH_IDNR)) where oh_otype='SERV' and oh_name like 'UC4B#%' and oh_deleteflag = 1

 

ORACLE:
Update oh set oh_name=concat(concat( concat(OH_Name , '_') , ( SUBSTR( '0000000000', 1,(10-length(OH_IDNR) ) ) )) , TO_CHAR(OH_IDNR)) where oh_otype='SERV' and oh_name like 'UC4B#%' and oh_deleteflag = 1;

 

commit;
 
You have to adapt the value 'UC4B#%' to your Automic System name.

?